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

Number of participants



Price per participant

Testimonials (5)

Related Categories