Video library

Training videos

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:

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.

Topics:
  • 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.

Topics:
  • 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.

Topics:
  • 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.

Topics:
  • 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