Presto Foundation Courses

The Future of Presto's Query Optimizer

Delve into modern query optimizer evolution with database pioneer Bill McKenna, exploring Presto's current capabilities and future developments in database optimization technology.

• YouTube
• 44 minutes
• Self-Paced
• Free Video

Using Federated Queries to Power External Reporting with Presto

Discover how Varsity Tutors leverages Presto's federated queries and Ahana Cloud to streamline cross-database reporting, enabling efficient data management across MySQL, Postgres, and Redshift for educational analytics.

• YouTube
• 16 minutes
• Self-Paced
• Free Video

Scalable Feature Engineering with Tecton on Athena

Discover how to transform raw data into ML features using Tecton's integration with Athena, enabling rapid development and deployment of feature pipelines for real-time machine learning.

• YouTube
• 14 minutes
• Self-Paced
• Free Video

The Thrift Connector: A Magic Door Into Storage Modernization

Discover how IBM's SOC Platform team leveraged Presto's Thrift connector to modernize storage infrastructure, reduce costs, and maintain seamless user experience through storage disaggregation.

• YouTube
• 22 minutes
• Self-Paced
• Free Video

Presto at Meta for the Interactive Data Lakehouse

Discover how Meta leverages Presto to power their massive data lakehouse, exploring key improvements and optimizations that make it ideal for interactive data analysis at scale.

• YouTube
• 22 minutes
• Self-Paced
• Free Video

Presto C++ Migration Progress Towards General Availability - From Batch to Interactive Workloads

Dive into Meta's journey migrating batch workloads to Presto C++, exploring challenges, solutions, and strategies for handling correctness issues and multi-region deployment.

• YouTube
• 44 minutes
• Self-Paced
• Free Video

PrestoPy - Enhancing SQL with Python

Discover how to integrate Python scripts within SQL queries using PrestoPy, enabling advanced data manipulation and analysis through UDF functions while maintaining security and efficiency.

• YouTube
• 26 minutes
• Self-Paced
• Free Video

Multimodal GenAI with Presto: Building Vector Data Lake Queries

Discover how to build universal multimodal AI applications using Presto, exploring vector data lake querying through Arrow flight connector and LanceDB integration.

• YouTube
• 24 minutes
• Self-Paced
• Free Video

Enabling Accelerator Offload in Presto-Velox

Discover how hardware acceleration enhances Presto-Velox performance through specialized integration, profiling tools, and benchmark analysis for optimized query execution and improved workload efficiency.

• YouTube
• 23 minutes
• Self-Paced
• Free Video

Advancing Query Efficiency and Data Management in Presto with Apache Hudi

Dive into advanced query optimization techniques using Presto-Hudi connector, exploring multi-modal indexing, enhanced data retrieval methods, and upcoming developments for efficient large-scale data operations.

• YouTube
• 35 minutes
• Self-Paced
• Free Video

Bolt's Data Platform Journey with Presto and IBM watsonx.data

Discover how Bolt leverages Presto and IBM watsonx.data to power their European mobility services platform, enhancing data operations for ride-hailing and delivery services.

• YouTube
• 30 minutes
• Self-Paced
• Free Video

Demystifying Expression Evaluation in Presto C++ - Vectorized Database Optimization

Dive into advanced expression evaluation techniques in Velox, exploring vectorized execution optimizations, dictionary operations, and sophisticated fuzz testing frameworks for enhanced database performance.

• YouTube
• 28 minutes
• Self-Paced
• Free Video

Using Denodo MPP with Presto to Create Cost and Speed Efficiencies

Discover how to optimize data processing and analytics using Denodo MPP with Presto, focusing on enhanced performance, cost reduction, and scalable solutions for large-scale data operations.

• YouTube
• 25 minutes
• Self-Paced
• Free Video

Presto C++ - The Road to a Native Future

Explore the evolution of Presto C++ through Presto Sidecar, enhancing native evaluation capabilities and bridging gaps between Java and C++ implementations for improved runtime performance.

• YouTube
• 42 minutes
• Self-Paced
• Free Video

Lessons Learned from Packaging a Commercial Version of Presto

Discover key insights into commercial Presto deployment, covering security protocols, performance optimization, and multi-platform distribution challenges for enterprise environments.

• YouTube
• 39 minutes
• Self-Paced
• Free Video