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
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (3)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
- UNIFI
Course - NoSQL Database with Microsoft Azure Cosmos DB
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
