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

Go to class Write review

This course may be unavailable.

Scrimba Ad

Free courses from frontend to fullstack and AI

Learn More → Coursera Ad

Gain a Splash of New Skills - Coursera+ Annual Nearly 45% Off

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
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

Go to class

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.