Learn about the various date and time functions available in Presto.
- [Instructor] Dates always are treated special in SQL…and in data platforms, and Presto is no different.…I wanted to run through some of the basic…date functionality here for you…in case you're unfamiliar with the anti-SQL stuff.…We'll start by logging in to Presto.…Once you're logged in to Presto,…you don't really need a catalog or system to be working with…because we're just operating solely here…in the Presto environment itself.…So we'll start by looking at the current date.…select current_date,…and it'll give you today's date.…
You can also do this for time.…select current_time.…The exact UTC time.…You can also use now, which is one that I prefer.…select now.…This one you need open and closed parentheses.…And finish it off with a semicolon,…and you get both of those combined, date and time.…If you're working with data that comes from Web applications…you'll likely get it in the Unix timestamp format,…and this can be a little bit cumbersome to work with in…some platforms, but in Presto it's pretty straightforward.…
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.