Learn how to access data in arrays using Presto.
- [Instructor] Now Presto is an advanced data platform…that works with complex data types.…If you are only used to working with relational…databases, these next couple of clips might…be a little bit abstract to you…because you haven't come across this yet.…But if you're more used to working…with big data systems, this will be very familiar.…And what I'm talking about here,…specifically are array functions.…So let's take a look and see what that even means.…Let's log into Presto.…and in Presto I want to create an array.…So I can do so by saying select array.…
And I'll just give it some numbers here.…Five, three, six, one, four.…And what it did there is it created a complex data type.…So again if you're not used to this you might be…wondering what's going on and so often data is nested…and this is specific to Jason data which comes…in where you may have a customer record and that…in database terms is one row and that customer…may have many orders.…Now, instead of having separate tables and normalization…and relationships and all kinds of stuff going on there,…
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?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
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.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.