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 (4)
The situation was atypical because an intensive training for developers was to be conducted with non-developers. Lukasz took up this challenge with empathy and a lot of humour. Through his intelligent and flexible manner, he was able to ensure that a concrete learning gain was achieved for everyone. I enjoyed this very much and would gladly take a seminar with Lukasz again.
Christoph - Honda Bank GmbH
Course - MERN Fullstack Development
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.