Plan Szkolenia

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

Wymagania

  • Experience with SQL

Audience

  • Data Scientists
 14 godzin

Liczba uczestników



Cena za uczestnika

Opinie uczestników (5)

Szkolenia Powiązane

Presto for Data Science

14 godzin

Data Management

35 godzin

Pivotal Greenplum for Developers

21 godzin

MarkLogic Server

14 godzin

Reporting Services

14 godzin

SQL – przetwarzanie danych

21 godzin

MS Access - poziom średniozaawansowany

14 godzin

VBA w Access

21 godzin

Access dla zaawansowanych

21 godzin

Microsoft Access - pobieranie danych

14 godzin

Access - podstawy

14 godzin

Access - projektowanie baz danych

21 godzin

SQL in Microsoft Access

14 godzin

Visual Basic for Applications (VBA) w Microsoft Office Access i Excel

21 godzin

FARM (FastAPI, React, and MongoDB) Full Stack Development

14 godzin

Powiązane Kategorie