Artificial Intelligence Training Course

Course Description

This course focuses exclusively on Starburst Enterprise SQL and Query Plan Optimization, equipping participants to harness Starburst with enterprise data lakes, data warehouses, SQL and NoSQL databases for advanced querying and performance tuning.

Aim

• Develop essential and advanced SQL skills for querying large datasets within Starburst Enterprise.
• Gain expertise in interpreting, tuning, and optimizing query plans using Starburst’s distinctive distributed query engine.

Duration & Delivery Mode

3-day, instructor-led classroom training with hands-on labs using Starburst Enterprise UI.

Who Should Attend

• Data Power Users
• Data Platform Administrators
• Architects interested in distributed query performance

Prerequisites

None required; basic SQL familiarity is helpful but not necessary.

Learning Objectives

By the end of this training, participants will be able to:

• Write and execute basic and advanced SQL queries using Starburst Enterprise.
• Apply Starburst SQL functions and windowing for big data analytics.
• Understand and interpret Starburst query plans, including stages, fragments, tasks, splits, exchanges, and drivers.
• Use EXPLAIN and EXPLAIN ANALYZE to optimize query execution.
• Evaluate how statistics, file format, and partitioning impact query plan selection and performance.
• Configure and manage Starburst clusters and catalogs for enterprise workloads.
• Employ federated queries, data products, analyse optimizer strategies, and troubleshoot plan inefficiencies.
• Implement fault-tolerant query execution and distributed data management best practices.