Course Outline
Introduction
- Overview of Presto and its architecture
- Introduction to the COST IT module
Cost Analysis
- Understanding cost analysis in big data environments
- Cost factors and considerations in Presto
Query Optimization
- Presto query optimization techniques
- Analyzing query execution plans
- Identifying performance bottlenecks
- Leveraging Presto's optimization features
- Cost estimation and analysis for queries
Cost-Based Optimizations and Best Practices
- Introduction to cost-based optimizations
- Implementing cost-based join optimizations
- Partition pruning and predicate pushdown techniques
- Dynamic filtering and query rewriting
- Managing costs and resource allocation
- Troubleshooting performance and cost-related issues
Summary and Next Steps
Requirements
- Experience with SQL
Audience
- Data Scientists
Testimonials (5)
I like that Kamil adjusted the materail for me and my understand. He really wanted to make sure I understood.
Austin Robertson
Course - MongoDB for Administrators
Learning about indexes with examples, configuring replicaSet with sharding and showing what it looks like underneath. It was also nice to play with aggregations and talk about change streams. Finally I also know what this Oplog is about,
Łukasz - G2A.COM Limited
Course - MongoDB for Developers
Machine Translated
perfect level of knowledge transfair
Pascal - Diehl
Course - Access Advanced
Our group was not that big so every time we asked a question we received an extensive answer with examples. So everything was well explained and it can be noticed that trainer has a great knowledge.
Iwona - Universal-Investment-Gesellschaft mit beschränkter Haftung
Course - Access Intermediate
Training Room and quite location and all the stuff.