Tour the command-line interface for Presto and get comfortable using it throughout the course.
- [Instructor] So here in my Presto terminal,…we're going to browse around and get familiar…with the command line interface.…I'm going to go ahead and maximize this,…and I'll just clear my window so you can have a clean slate…to work from.…And first I want to take a look at what files we have.…So I'll type ls, and notice we have bin and prestoadmin.…Let's go inside a bin,…and inside a bin we hae the presto dash admin…which operates several admin functions…and then you have the cli, the command line interface.…
So just to simplify things, what I'm going to do is…rename the presto-cli as just presto.…So I'm going to copy it, presto dash cli presto.…Now when I run functions, I just have to type presto…and then whatever the function is.…For example, let's log in to our Presto server.…So I'll type presto dash dash server,…localhost is where it's running, and port 8080.…Now that I'm in presto, I have several different functions,…and the first one is about the catalog,…so as I mentioned before, Presto can connect to…
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.