Brief Introduction
Learn Presto - distributed SQL Query Engine for Big Data! Query parquet files in AWS S3! Join them with PostgreSQL data.Description
Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes. Presto was designed and written from the ground up for interactive analytics and approaches the speed of commercial data warehouses while scaling to the size of organisations like Facebook.
In the first part of the course I will talk about Presto's theory including Presto's architecture and components - coordinator, worker, connector, query execution model, etc. Additionally, I will explain to you how Kafka, Cassandra, Hive, PostgreSQL and Redshift work before I mention the specifics to their connectors.
In the second part of the course, you are going to have many practical lectures where I will help you to build a development environment including Docker images for Hive and Presto, Helm chart for the whole Presto infrastructure and then deploy the chart to a local Kubernetes cluster.
Later, you will learn how to run a real world example by joining parquet files in S3 with PostgreSQL data in a single SQL query. When you learn how to run and use Presto's features locally, I will show you how to setup your AWS account and how to deploy your Presto cluster to a managed Kubernetes (EKS) cluster in Amazon where you will be able to analyse terabytes or even petabytes of data at scale.
Finally, I am going to talk about all available managed and non-managed Presto services on the market, describing pros and cons for each of them.
Requirements
- 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
Mihail Petkov
3.8 Raiting
Learn MongoDB : Leading NoSQL Database from scratch
- 3.8
-
![]()
![]()
![]()
![]()
![]()
Learn all concepts you need to know for building a MongoDB based Applications. This course will help you to master one of the most popular NoSQL databases MongoDB....
A Consultant's Guide to PowerPoint
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Everything you need to know to use PowerPoint like an experienced McKinsey, Bain, or BCG consultant. COURSE OVERVIEW It's no secret that consultants are masters of PowerPoint....
Master ExpressJS to Build Web Apps with NodeJS&JavaScript
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Based on ExpressWorks automated workshop, author Azat Mardan (Pro ExpressJS) walks you through each exercise. You might have heard about such rapidly-growing-in-popularity technologies as NodeJS or the M....
Parallel Programming in Java
- 4.6
-
![]()
![]()
![]()
![]()
![]()
This course teaches learners (industry professionals and students) the fundamental concepts of parallel programming in the context of Java 8. Why take this course?...
