Hands On Presto Mastery - Learn by doing!
What you'll learn
- A deep dive into PrestoSQL
- Learn how to architect Presto based solutions
- How to install and configure Presto
- How to install and setup the Presto CLI
- How to connect RStudio to Presto
- How to connect Tableau to Presto (JDBC Connector)
- How to query data in a MySQL DB via Presto
- How to query data in Kafka via Presto
- How to query data in HDFS via Presto
- Setup and connect a Hive Metastore to Presto
- Basic familiarity with SQL
- Basic familiarity with the Linux CLI
- A Computer (PC, Mac or Linux)
- An Internet connection
Welcome to my Presto course - Hands On Presto Mastery - Learn by doing!. I want to first of all thank you for considering this course. Without you the student, I will not be able to create this course.
Big Data is very hot at the moment and Presto is one of the exciting projects in the Big Data ecosystem. Presto is a distributed query engine that excels at crunching petabytes of data efficiently and low latency analytics.
This Presto course contains everything you need to get started with Presto. We will go from zero to Presto in this single course and back it up with a lot of hands on work. By the end of this course, you will be full of confidence, skilled up and ready to take your career to the next level. So let's buckle up and lean in
In this course, we will wear many hats as we solve an end to end Big Data problem:
Product Hat: We will start with a real world scenario and dive into the user segments and pain points.
Architect Hat: Once we understand the pain points, we will architect a Presto based solution to address those pain points
Engineer Hat: Once we have that, we will then install and setup Presto. We will cover the fundamentals – coordinator, worker, connectors etc.
Engineer Hat: One nice thing is that presto forces you to interact with other projects in the Big Data ecosystem.
And so, to visualize data, we will setup clients like the Presto CLI, RStudio and Tableau.
For storage, we will setup data sources like the MySQL DB, Kafka and HDFS. Presto is strictly a compute engine and this means that it does not have its own storage.
Engineer Hat: Once we are done, we will demo the final product and show you how to join data from multiple data sources in a single query.
At the end of this journey, we will deliver a solution that solves the pain points identified earlier.
Who this course is for:
Thank you very much for enrolling in my course "The Ultimate Hands-On Presto - Learn by doing!". I truly appreciate it. A few things about this instructor ...
The instructor is currently a Big Data expert with experience in all aspect of the Big Data Pipeline including data extraction (ETL), transportation, storage, processing, visualization and metadata management.
Prior to this, he spent 15 years in Tech with relevant past work experience at Microsoft, Salesforce and NetApp. This course was created in the instructor's individual capacity
His educational background includes a Master's degree in Electrical Engineering (Rochester Institute of Technology) and an MBA (Carnegie Mellon University). In addition, he also has the following Amazon Web Services certificates - AWS Certified Big Data (Specialty), AWS Certified Solutions Architect (Associate), AWS Certified Developer (Associate) and AWS Certified SysOps Administrator (Associate)
And the following 8 months training certificates at University of Washington (Cont' Ed) - Big Data Technologies (8 months @ UW), Machine Learning (8 months @ UW), Cloud Application Development on AWS (8 months @ UW) and Android Development (8 months @ UW)
And so, I believe you are in good hands...