Presto Foundation Courses

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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• 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
• On-Demand
• Free Video

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
• On-Demand
• Free Video

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
• On-Demand
• Free Video

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
• On-Demand
• Free Video

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
• On-Demand
• Free Video

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
• On-Demand
• Free Video

Nimble: A New File Format for Large Datasets - Enhancing Data Warehouse Efficiency

Discover how Nimble, Meta's open-source file format, revolutionizes large dataset management with enhanced efficiency, flexibility, and superior performance for ML training data preparation.

• YouTube
• 25 minutes
• On-Demand
• Free Video