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
 14 Hours

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.
Investment

Price per private group, online live training, starting from 3200 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (4)

Upcoming Courses

Related Categories