Coursera Plus Annual is 40% Off — Ends July 13.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Presto Essentials: Data Science

via LinkedIn Learning

Write review

No Longer Offered

Scrimba Ad

Free courses from frontend to fullstack and AI

Learn More → Boot.dev Ad

The Fastest Way to Become a Backend Developer Online

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Get up to speed with Presto, the open-source SQL query engine developed by Facebook. Learn the key concepts and how to use them to take advantage of your modern big data system.

Syllabus

Introduction
  • Welcome
  • What you should know
  • Exercise files
1. Introducing Presto
  • Presto origins
  • Why use Presto?
  • What does Presto do?
  • How Presto works
2. Running Presto
  • Deployment options
  • Sandbox setup
  • Command-line interface
  • Connect from Tableau
  • Connect from R
  • Presto web UI
3. Connectors
  • Connect to Hive
  • Connect to MySQL
  • Connect to the local system
  • Benchmark with TPCH
  • Additional connectors
4. SQL Syntax
  • Retrieve data
  • Combine data sources
  • Group results
5. Basic SQL functions
  • Conditional expressions
  • Date and time functions
  • Data aggregation
  • Conversion between data types
6. Advanced SQL Functions
  • Window functions
  • Bollinger bands
  • Access data with arrays
  • Access data with maps
  • Parse URL strings
  • Work with JSON data
7. Migrating from Hive
  • Migrate from Hive
Conclusion
  • Next steps

Taught by

Ben Sullins

Reviews

4.1 rating at LinkedIn Learning based on 58 ratings

Start your review of Presto Essentials: Data Science

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.