Fundamentals of Presto
4.7 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
776 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Fundamentals of Presto to your Wishlist.

Add to Wishlist

Fundamentals of Presto

Learn the fundamentals of Presto
4.7 (5 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
776 students enrolled
Created by BigData Edu
Last updated 7/2017
English
Curiosity Sale
Current price: $10 Original price: $20 Discount: 50% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn the fundamentals of Presto
  • Running Presto
  • Retrieving data
  • Much more!
View Curriculum
Requirements
  • Basics of Hadoop and Hive
  • Basic SQL
Description

Presto is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes ranging from gigabytes to petabytes. Presto allows querying data where it lives, including Hive, Cassandra, relational databases or even proprietary data stores. A single Presto query can combine data from multiple sources, allowing for analytics across your entire organization.

Developed by Facebook, it is also used by other leading companies such as Netflix, Airbnb, LinkedIn, and Uber. Many of these companies use Presto to query SQL on Hadoop at big data scale.

In this course, you'll learn the fundamentals of Presto. You'll learn about the concepts and architecture behind Presto, how to install and configure Presto for different requirements and how to administer Presto, including tuning, performance, and diagnosis.

We'll also get into how to use different interfaces with Presto—such as R and Tableau. We'll then dive into the expressive SQL language that Presto offers for your analysis. By the end of this course, you'll know the key concepts of Presto and how to use them to take full advantage of your modern big data system.


Who is the target audience?
  • Developers
  • Anyone wanting to learn Presto
Students Who Viewed This Course Also Viewed
Curriculum For This Course
26 Lectures
01:46:38
+
Connectors
5 Lectures 18:40
Connecting to Hive
02:29

Connect to MySQL
05:24

Connect to the local system
03:05

Benchmark with TPCH
05:52

Additional connectors
01:50
+
SQL Syntax and Functions
5 Lectures 32:34
Retrieve and combine data
14:17

Conditional expressions
05:18

Date and time functions
04:33

Data aggregation
05:29

Conversion between data types
02:57
+
Advanced SQL Functions
5 Lectures 22:28
Window functions
05:37

Bollinger bands
03:43

Access data with arrays and maps
05:37

Parse URL strings
03:04

Work with JSON data
04:27
+
Conclusion
2 Lectures 04:30
Migrate from Hive
04:00

Final words
00:30
About the Instructor
BigData Edu
4.7 Average rating
5 Reviews
776 Students
1 Course
Data Engineer

We are an independent nonprofit education company. We democratize learning by providing top-notch curricular materials, and we aim to strike the perfect balance between academic rigor and practical relevance. Established in 2007, we were inspired by the Scandinavian educational system to create low-cost, high-quality education so as to change the way people learn technology. Over the past decade, we have built a sustainable collaboration and education platform, and we continue to collaborate with top universities and companies to help students further their education.