Getting Started with Starburst for Data Analysts
Duration
4 hrs
Level
Intermediate Level
Design and Tailor this course
Official Course
Overview
This course introduces data analysts to the fundamentals of using Starburst to explore, query, and analyze data across diverse sources. Youʼl learn how to connect to Starburst, run SQL queries using familiar tools, and efficiently access data from multiple systems without complex data movement. By the end of the course, youʼl be able to navigate the Starburst interface, create meaningful analyses, and leverage Starburstʼs power to accelerate data-driven insights.
Upon successful completion of this course, participants will be able to:
- Navigate the Starburst Enterprise web UI
- Connect to and query data across multiple sources
- Work with curated data products
- Use SQL in Starburst to explore and analyze data
- Understand best practices for integrating results into BI/visualization tools
- Generate and analyze basic query plans
Audience
This course is designed for experienced data analysts, business intelligence specialists, data engineers, and data scientists.
Prerequisites
A minimum of intermediate experience with SQL is assumed.
Curriculum
- What is Starburst?
- Starburst in the Modern Data Ecosystem
- How Do Analysts Use Starburst?
- Hands-On Exercise: Access Your Lab Environment
- Catalog Hierarchy
- Catalogs, Schemas, & Objects
- Multiple Ways to Reference Tables & Views
- Instructor Demonstration: Catalog Exploration in the SEP web UI
- Hands-On Exercise: Explore Available Data in the Lab Environment
- Starburst SQL
- What Can You Do With Multiple Catalogs?
- Query Federation the Traditional Way
- Query Federation the Starburst Way
- Instructor Demonstration: Joining sales data from a cloud warehouse with marketing data in object storage
- Hands-On Exercise: Write Queries to Answer Key Business Questions
- What is a Data Product?
- Why Are Data Products Important?
- How Data Products Benefit Data Analysts
- Instructor Demonstration: Explore a Customer 360 Data Product
- Hands-On Exercise: Compare Results From Raw Tables vs. a Curated Data Product
- Starburst Client Tools
- Working With BI Tools Connected to Starburst
- Starburst Clients & BI Tool Support
- ODBC Driver & Data Optimization
- Why Performance Matters
- Server Stereotypes
- How a Query is Executed
- Understanding Query Plans (High Level)
- Common Pitfalls to Avoid
- Group Activity: Improve a Slow Query
- Instructor Demonstration: Generating and Reviewing a Query Plan
Group Activity: Why did revenue drop last quarter?
Duration
4 hrs
Level
Intermediate Level
Design and Tailor this course
Official Course
