Unlock actionable real-time insights with Starburst Galaxy
$600.00
August 22 @ 9:00 am – 5:00 pm UTC+5:30
About the event
Are you a data analyst, BI specialist, or data engineer looking to accelerate your data exploration and visualization capabilities? Join our hands-on session, Getting Started with Starburst for Data Analysts, and learn how to streamline data access, optimize queries, and drive smarter business decisions using Starburst Galaxy.
Why Attend?
In this power-packed hands-on session, you’ll:
- Master federated queries across 50+ enterprise connectors to unify data effortlessly.
- Learn how to query diverse file-based formats with Starburst Galaxy.
- Dive into practical SQL techniques aligned with real-world use cases.
- Optimize query performance with advanced SQL functions and best practices.
- Develop complex analytical queries using rollups and windowing functions.
Secure your seat and boost your analytics with Starburst – the future of federated query engines.
Key Outcomes
By the end of this session, you will:
- Be proficient in writing and optimizing federated queries
- Understand how to leverage Starburst Galaxy for real-time analytics
- Be equipped to enhance data quality and analytical speed
- Confidently handle windowing and rollup functions in large-scale datasets
Prerequisites
- Intermediate SQL knowledge
- Familiarity with relational databases and data analysis tools
Target Audience
- Data Analysts
- Business Intelligence Specialists
- Data Engineers
- Data Scientists with analytical roles
Foundations
- Starburst Overview
- Starburst Web UI
- Data Sources
- Client Tools Integration
- Starburst Architecture
- Federated Querying
Best Practices
- Using Approximations
- Building Data Rollups and Cubes
- Join Considerations
SQL Functions
- Transforms and Aggregates
- Limiting Results
- Error Handling
- Decisioning
Windowing
- Windowing basics
- RANK and row numbering
- LAG and LEAD Functions
- FIRST/LAST/NTH_VALUE
- Sliding Windows using RANGE or ROWS