Learn where Presto originates from and who uses it.
- [Instructor] Let's start by talking…about where Presto comes from.…And I think it's always important…to understand the nature of something,…because this will help us understand its purpose…and how we can use this platform…to solve the challenges that we face…when we're trying to deliver insights to our customers.…It all started in 2006, when a group of developers…from a company called Nutch were hired by Yahoo.…This project they were working on became Hadoop…and they open-sourced it at this time,…and the point of Hadoop was to help Yahoo…index all of the data on the internet…that they were ingesting…and then trying to provide search for.…
Now this worked exceedingly well…because it was able to spread the data out…across multiple different machines,…different nodes in the cluster,…and create what we now call…a distributed computing platform.…The problem with Hadoop was that in order to access…and work with the data, you had to understand…some very low-level APIs and know Java.…This is when Google added MapReduce.…
Data science expert Ben Sullins helps you get up to speed with Presto, and leverage it to accomplish a wide-range of data science and analytics tasks. He uses different interfaces with Presto—such as R and Tableau—and digs into the expressive SQL language that Presto offers for your analysis. At 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.
- What does Presto do?
- Running Presto
- Connecting from Tableau and R
- Connecting to Hive, MySQL, and the local system
- Retrieving data
- Combining data sources
- Basic SQL functions
- Advanced SQL functions
- Migrating from Hive
Skill Level Intermediate
SQL: Data Reporting and Analysiswith Emma Saunders2h 16m Intermediate
Advanced SQL for Data Scientistswith Dan Sullivan1h 24m Advanced
1. Introducing Presto
2. Running Presto
4. SQL Syntax
5. Basic SQL functions
6. Advanced SQL Functions
7. Migrating from Hive
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.