share img lab 101 oct2021 1


Presto 101 for beginners

Learn how to get started with Presto, the open source SQL query engine, on Ahana Cloud, the Presto managed service.

Thursday, October 28 | 10am PT

Presented by: ahana trademarked site logo


Free registration

Virtual Lab: Presto 101 for beginners

In this 90 minutes hands-on virtual lab you’ll get started with the basics of Presto, an open source SQL query engine. Come prepared to have your video on while following along with the instructor – this is an interactive session and we encourage participation from everyone attending!

What you’ll learn

  • What is Presto and why you’d use it
  • How to write a Presto query
  • How to create and deploy a Presto cluster in AWS using Ahana Cloud
  • How to use Presto to query your AWS S3 data lake
  • How to use Presto to query across other data sources like MySQL, RedShift, and AWS Glue
  • How to create dashboards/visualizations of your data

Course outline:

  • Introduction to Presto
  • Writing your first Presto Query
  • Create and deploy your first Presto cluster in AWS using Ahana Cloud
  • Add data sources to Presto like MySQL, Amazon Glue and Amazon RedShift
  • Query AWS S3 with your Presto and Hive metastore cluster using Apache Superset
  • Build a dashboard to view your data

By the end of this lab, you’ll know how to run basic queries with Presto and how to query your AWS S3-based data lake.