Description
In this course, you will :
- Learn how to harness the power of your big data system with the Presto platform, which eliminates the false dilemma of having to choose between an expensive commercial solution that provides fast analytics and a slow, ostensibly free solution that necessitates a lot of hardware.
- This course will help you get up to speed with Presto and use it to perform a variety of data science and analytics tasks.
- uses various Presto interfaces, such as R and Tableau, and delves into the expressive SQL language that Presto provides for your analysis.
- By the end of this course, you'll understand the key concepts of Presto and how to apply them to get the most out of your modern big data system.
Syllabus :
1. Introducing Presto
- Presto origins
- Why use Presto?
- What does Presto do?
- How Presto works
2. Running Presto
- Deployment options
- Sandbox setup
- Command-line interface
- Connect from Tableau
- Connect from R
- Presto web UI
3. Connectors
- Connect to Hive
- Connect to MySQL
- Connect to the local system
- Benchmark with TPCH
- Additional connectors
4. SQL Syntax
- Retrieve data
- Combine data sources
- Group results
5. Basic SQL functions
- Conditional expressions
- Date and time functions
- Data aggregation
- Conversion between data types
6. Advanced SQL Functions
- Window functions
- Bollinger bands
- Access data with arrays
- Access data with maps
- Parse URL strings
- Work with JSON data
7. Migrating from Hive