Video library
Explore the growing list of videos to learn about Starburst products, installation, tuning, management, SQL, and more. Use timestamps to drill down and learn about a specific topic:
- Advanced SQL in Starburst
- Understanding and tuning Starburst query processing
- Securing Starburst Enterprise
- Starburst cluster sizing, and performance tuning
- What Data Mesh Means for Data Analysts
- Mars - Enabling Profitable Growth by Leveraging Data and Analytics
- SQL and Trino - The Golden Language Prevails
- The State of Data Analysts
- Lightning demo - Tableau and Starburst
- Lightning demo - ThoughtSpot and Starburst
Cluster sizing and performance tuning
Learn how to tune and size your deployment for optimal performance. Click on the video below to view the full video in YouTube, or go to the performance tuning section to view the video in segments, with links to the relevant documentation.
- Cluster configuration and node sizing
- Memory configuration and management
- Improving task concurrency and worker scheduling
- Tuning your JVM configuration
- Investigating queries for join order and other criteria
- Tuning the cost-based optimizer
Video date: 9 September 2020
Running time: 2h15m
Securing Starburst
Learn how to securely deploy Starburst at scale. Click on the video below to view the full video in YouTube, or go to the security section to view the video in segments, with links to the relevant documentation.
- Authentication, including password & LDAP Authentication
- Authorization to access your data sources
- Encryption including client-to-coordinator communication
- Secure communication in the cluster
- Support for Kerberos
- Secrets usage for configuration files including catalogs
Video date: 26 August 2020
Running time: 2h07m
Advanced SQL
Learn how to run more complex and comprehensive SQL queries with Starburst. Click on the video below to view the full video in YouTube, or go to view the video in segments, with links to the relevant documentation in our SQL section.
- Using JSON and other complex data types
- Advanced aggregation techniques
- Window functions
- Array and map functions
- Lambda expressions
- Many other SQL functions and features
Video date: 29 July 2020
Running time: 2h14m
Query tuning
Learn how Starburst executes queries to help you improve query performance. Click on the video below to view the full video in YouTube, or go to the query performance section to view the video in segments, with links to the relevant documentation.
- Explaining the EXPLAIN
- Learning how queries are analyzed and executed
- Understanding what the optimizer does, including some of its limitations
- Showcasing the cost-based optimizer
Video date: 12 August 2020
Running time: 2h09m