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

Noble Desktop Ad

Live Online Classes in Design, Coding & AI — Small Classes, Free Retakes

Learn More → DataCamp Ad

Power BI Fundamentals - Create visualizations and dashboards from scratch

Learn More →

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
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.