Duration
8 hrs
Level
Basic Level
Design and Tailor this course
As per your team needs
Explore the world of Trino, the open-source, analytical, distributed, SQL query engine, in our new course: “Getting Started With Trino.” Trino empowers you to efficiently query data from diverse sources, regardless of their size. Using standard SQL queries, it seamlessly connects to a wide array of established business intelligence and reporting tools.
Join our team of Starburst certified and vetted expert instructors for an interactive introduction to Trino. Through guided demonstrations and hands-on exercises, you’ll learn how to set up a Trino, configure catalogs, and leverage different tools for data querying. Additionally, gain insights into Starburst Galaxy, the web-based UI wrapper for this amazing distributed analytical SQL Engine.
By the end of this course, you’ll have the knowledge and skills to embark on your journey using this powerful query engine.
- You need to efficiently query multiple databases, data warehouse, and data lakes at scale
- You want to leverage your knowledge of SQL across all data sources and preferably through one Query Engine
- You are a data engineer looking for implementing a cost-effective data lake analytics platform (DLAP)
- The Current Data Scenario
- Query engines – Types and Differences
- Introduction to Trino a Massively Parallel Processing Query Engine
- Trino Architecture
- Trino Cluster with coordinator, and worker nodes
- Working of a MPP Query Engine
- Checking prerequisites
- Trino in a Docker container
- Running the Container
- Using Trino CLI
- Overview of available Clients and Connectors
- Configuring Catalogs as Data sources for first use
- Hands-on exercises: Exploring and Connecting to Connectors
- Hands-on exercises: Running queries in Trino CLI
- Challenges with Apache Trino
- Introduction to Starburst
- Benefits of using Starburst
- Exploring Starburst Galaxy’s Web UI
- Exploring Data Sources
- Client Tools Integrations
- Starburst Architecture
- Hands-on: Federated Querying
- A working knowledge of the Linux/macOS CLI
- Knowledge of databases, SQL, and data pipeline
