Search
Close this search box.

Getting Started With Trino

Run SQL at scale to achieve Analytics Anywhere

Duration

8 hrs

Level

Basic Level

Design and Tailor this course

As per your team needs

Edit Content

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.

Edit Content
  • 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)
Edit Content
  • 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
Edit Content
  • A working knowledge of the Linux/macOS CLI
  • Knowledge of databases, SQL, and data pipeline

Connect

we'd love to have your feedback on your experience so far