This course aims to introduce learners to the open-source Presto technology, a distributed SQL engine for data lake analytics. By the end of the course, students will understand the benefits of using Presto, including ad hoc querying of data in place, improved performance, scale, and ecosystem integration. The course covers topics such as Presto connectors, Presto-on-Spark, scan optimizations, and Presto use cases like interactive querying, reporting, dashboarding, and data science. The teaching method includes lectures and a quick demo on setting up Presto in AWS. This course is intended for data professionals, analysts, data engineers, and anyone interested in learning about distributed SQL engines for data analytics.
Overview
Syllabus
DATA+AI SUMMIT 2022
Rohan Pednekar
Presto Overview
Common Questions?
Pluggable Presto Connectors Today's top five popular connectors
Presto Connector Data Model • Connector: Driver for a data source.
Presto Hive Connector for Object store Files systems
Presto Hive Connector - Data File Type
Why Presto consistently outperforms • In-Memory processing
Presto Use Cases
Interactive - Reporting and Dashboa
Interactive - Data Science
Batch - Transformation, cleansing et
Ahana At A Glance • The Presto Company
One Presto, many use cases
Taught by
Databricks
