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)
Los ejemplos claros que presentó el instructor
José Ernesto Cruz Pineda - Datavision digital
Course - SAP ASE for Database Administrators
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
Simplifying operational tasks.
Kesh - Vodacom
Course - MongoDB for Administrators
Tamil was excellent at explaining even the difficult topics in a way that I understood them straight away. The presentation and delivery were both clear and methodical, and the teacher passionate about the subject.
Mark Novak - Kiloo
Course - MongoDB for Advanced Users
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