Trino Courses and Certifications

Presto Foundation

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 Foundation

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

Presto Foundation

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

Presto Foundation

Advanced SQL Capabilities for AI-Driven Data Lakes with Presto and Lance

Discover how to leverage Presto-Lance integration for high-performance AI analytics, vector data lakes, and advanced SQL capabilities with enhanced semantic search and multimodal data management.

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

Presto Foundation

Bridging the Divide - Running Presto SQL on Vector Data Lake with Lance

Discover how to unify AI data management by running Presto SQL queries on Lance-based vector data lakes, enabling 10x faster searches and simplified data transformations.

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

Presto Foundation

Detecting and Resolving Presto Performance Hurdles

Master advanced monitoring techniques for optimizing Presto clusters, from identifying query latency and resource issues to implementing proactive solutions using tools like Prometheus and Grafana.

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

Presto Foundation

Enhancing Presto's Query Performance and Data Management with Hudi - Innovations and Future

Discover how Hudi's multi-modal indexing framework enhances Presto's query optimization, featuring advanced data management capabilities and improved efficiency for point and range lookups.

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

Presto Foundation

Supporting Machine Learning Workloads in Presto - Optimizing Data Preparation and Processing

Explore how Presto optimizes machine learning workflows through efficient data storage, compressed execution, and late materialization techniques for large-scale training datasets.

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

Presto Foundation

Unraveling the Non-Deterministic Query Conundrum for Prestissimo Verification

Dive into advanced techniques for verifying non-deterministic queries in Prestissimo, exploring query rewriting methods and correctness verification using Presto Verifier and Velox Fuzzer.

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

Presto Foundation

Presto Query Governance - Production Best Practices and Infrastructure

Discover how Uber implements production best practices and infrastructure for governing Presto query workloads, featuring insights into their developed systems and methodologies.

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

Presto Foundation

Prestissimo: A Year In, The Path to Veloxification

Dive into Meta's journey of replacing Presto's Java worker with C++ through Prestissimo, exploring Velox integration, production learnings, and performance optimization strategies.

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

Presto Foundation

Introduction to Prestissimo - Understanding C++ Native Worker for Presto

Discover Prestissimo, a C++ Native Worker replacing Java in Presto clusters, offering enhanced performance through vectorization, improved memory management, and sophisticated runtime optimizations for efficient query processing.

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

Presto Foundation

Statistics with Sampling Using Iceberg on Presto

Discover how to optimize Presto query planning through table sampling techniques and statistical inference, enhancing performance without full table scans for large datasets.

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

Presto Foundation

Presto at IBM - Leaning into Open Source for the Open Data Lakehouse

Discover how IBM leverages Presto for watsonx.data, exploring its open-source integration, performance optimization, and key contributions to data lakehouse architecture.

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

Presto Foundation

History Based Optimizer - Making Query Plans More Efficient Through Past Executions

Discover how History Based Optimizer (HBO) leverages past query executions to create more efficient query plans, exploring its framework design and optimization benefits.

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