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

TrainSec Ad

Learn EDR Internals: Research & Development From The Masters

Learn More → DataCamp Ad

AI Engineer - Learn how to integrate AI into software applications

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates 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.2 rating at LinkedIn Learning based on 74 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.