Mastering Presto: Hands-On Learning

Learn Presto - distributed SQL Query Engine for Big Data! Query parquet files in AWS S3! Join them with PostgreSQL data.

Created by: Mihail Petkov
Big Data Engineer

What Will I Learn?

• Query parquet files in AWS S3
• Deploy to Kubernetes cluster in AWS
• Join parquet files in S3 with data from PostgreSQL table
• Deep knowledge about Presto's internal architecture
• Learn more about Cassandra, Kafka, Redshift, Hive and PostgreSQL
• Run development environment in local Kubernetes cluster using minikube
• Understand Presto configurations
• Presto service providers
• Build Docker images for Presto and Hive
• Create a Presto Helm chart

Requirements

• An Internet connection
• Computer with either MacOS or Linux
• Basic comprehension in SQL and any database
• Basic knowledge about Docker, Kubernetes and Helm
• A desire to learn

Target audience

• Software Engineers curious about Presto
• Software Engineers looking for distributed SQL query engine
• Data Engineers looking for a way to optimize their queries over a huge data lake
• Data Engineers looking to improve their Data Platforms