コース概要

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

要求

  • Experience with SQL

Audience

  • Data Scientists
 14 時間

参加者の人数



Price per participant

お客様の声 (4)

関連コース

Presto for Data Science

14 時間

Data Management

35 時間

Pivotal Greenplum for Developers

21 時間

MarkLogic Server

14 時間

SAP ASE for Database Administrators

28 時間

Access Intermediate

14 時間

Access VBA

21 時間

Access Advanced

21 時間

Microsoft Access - download the data

14 時間

Access - podstawy

14 時間

Access - Data Base Designing

21 時間

SQL in Microsoft Access

14 時間

VBA For Access & Excel

21 時間

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

14 時間

MERN Fullstack Development

14 時間

関連カテゴリー