Join Ben Sullins for an in-depth discussion in this video What you should know, part of Presto Essentials: Data Science.
- [Instructor] In order to be successful with this course, you should have a basic understanding of SQL, you probably need to be familiar with Hadoop and Hive, and you need to be comfortable on the Linux command line. If you're unfamiliar with any of these things, you can take some other courses here that will help you get up to speed, and the first one I recommend is SQL Essential Training. This will get you everything you need to know about SQL and how that works. Also, if you're new to Hadoop, there's a good course out there by Lynn Langit called Hadoop Fundamentals, and if you haven't worked with Hive much on Hadoop, I have a course out there as well that will help you get up to speed, which is Analyzing Big Data with Hive.
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
Cassandra Data Modeling Essential Trainingwith Dan Sullivan1h 38m Intermediate
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.