- 具有SQL的經驗
受眾
- 數據科學家
Presto 是一個用於大數據分析的分散式查詢引擎。使用 Presto，用戶可以原生查詢數據，從多個系統訪問數據等。
這是一個由講師指導的培訓（線上或線下），針對希望學習如何使用 Presto 的 COST IT 模組進行成本分析的中級數據科學家。
在培訓結束時，參與者將能夠：
- 了解 Presto 的基礎知識及其在大數據分析中的角色。
- 熟練使用 Presto 的 COST IT 模組進行成本分析。
- 優化 Presto 查詢以提升性能和資源利用率。
- 識別並實施基於成本的優化策略。
- 排查並解決 Presto 中常見的性能和成本相關問題。
課程形式
- 互動式講座與討論。
- 大量練習與實踐。
- 在實時實驗環境中進行動手操作。
課程定制選項
- 如需為此課程定制培訓，請聯繫我們安排。
简介
- Presto及其架构概述
- COST IT模块简介
成本分析
- 理解大数据环境中的成本分析
- Presto中的成本因素和注意事项
查询优化
- Presto查询优化技术
- 分析查询执行计划
- 识别性能瓶颈
- 利用Presto的优化功能
- 查询的成本估算与分析
基于成本的优化与最佳实践
- 基于成本的优化简介
- 实施基于成本的连接优化
- 分区裁剪和谓词下推技术
- 动态过滤和查询重写
- 管理成本与资源分配
- 解决性能与成本相关问题
总结与下一步
United Arab Emirates - Cost Analysis with Presto COST IT Module
Qatar - Cost Analysis with Presto COST IT Module
Egypt - Cost Analysis with Presto COST IT Module
Saudi Arabia - Cost Analysis with Presto COST IT Module
South Africa - Cost Analysis with Presto COST IT Module
Brasil - Cost Analysis with Presto COST IT Module
Canada - Cost Analysis with Presto COST IT Module
中国 - Cost Analysis with Presto COST IT Module
香港 - Cost Analysis with Presto COST IT Module
澳門 - Cost Analysis with Presto COST IT Module
台灣 - Cost Analysis with Presto COST IT Module
USA - Cost Analysis with Presto COST IT Module
Österreich - Cost Analysis with Presto COST IT Module
Schweiz - Cost Analysis with Presto COST IT Module
Deutschland - Cost Analysis with Presto COST IT Module
Czech Republic - Cost Analysis with Presto COST IT Module
Denmark - Cost Analysis with Presto COST IT Module
Estonia - Cost Analysis with Presto COST IT Module
Finland - Cost Analysis with Presto COST IT Module
Greece - Cost Analysis with Presto COST IT Module
Magyarország - Cost Analysis with Presto COST IT Module
Ireland - Cost Analysis with Presto COST IT Module
Luxembourg - Cost Analysis with Presto COST IT Module
Latvia - Cost Analysis with Presto COST IT Module
España - Cost Analysis with Presto COST IT Module
Italia - Cost Analysis with Presto COST IT Module
Lithuania - Cost Analysis with Presto COST IT Module
Nederland - Cost Analysis with Presto COST IT Module
Norway - Cost Analysis with Presto COST IT Module
Portugal - Cost Analysis with Presto COST IT Module
România - Cost Analysis with Presto COST IT Module
Sverige - Cost Analysis with Presto COST IT Module
Türkiye - Cost Analysis with Presto COST IT Module
Malta - Cost Analysis with Presto COST IT Module
Belgique - Cost Analysis with Presto COST IT Module
France - Cost Analysis with Presto COST IT Module
日本 - Cost Analysis with Presto COST IT Module
Australia - Cost Analysis with Presto COST IT Module
Malaysia - Cost Analysis with Presto COST IT Module
New Zealand - Cost Analysis with Presto COST IT Module
Philippines - Cost Analysis with Presto COST IT Module
Singapore - Cost Analysis with Presto COST IT Module
Thailand - Cost Analysis with Presto COST IT Module
Vietnam - Cost Analysis with Presto COST IT Module
India - Cost Analysis with Presto COST IT Module
Argentina - Cost Analysis with Presto COST IT Module
Chile - Cost Analysis with Presto COST IT Module
Costa Rica - Cost Analysis with Presto COST IT Module
Ecuador - Cost Analysis with Presto COST IT Module
Guatemala - Cost Analysis with Presto COST IT Module
Colombia - Cost Analysis with Presto COST IT Module
México - Cost Analysis with Presto COST IT Module
Panama - Cost Analysis with Presto COST IT Module
Peru - Cost Analysis with Presto COST IT Module
Uruguay - Cost Analysis with Presto COST IT Module
Venezuela - Cost Analysis with Presto COST IT Module
Polska - Cost Analysis with Presto COST IT Module
United Kingdom - Cost Analysis with Presto COST IT Module
South Korea - Cost Analysis with Presto COST IT Module
Pakistan - Cost Analysis with Presto COST IT Module
Sri Lanka - Cost Analysis with Presto COST IT Module
Bulgaria - Cost Analysis with Presto COST IT Module
Bolivia - Cost Analysis with Presto COST IT Module
Indonesia - Cost Analysis with Presto COST IT Module
Kazakhstan - Cost Analysis with Presto COST IT Module
Moldova - Cost Analysis with Presto COST IT Module
Morocco - Cost Analysis with Presto COST IT Module
Tunisia - Cost Analysis with Presto COST IT Module
Kuwait - Cost Analysis with Presto COST IT Module
Oman - Cost Analysis with Presto COST IT Module
Slovakia - Cost Analysis with Presto COST IT Module
Kenya - Cost Analysis with Presto COST IT Module
Nigeria - Cost Analysis with Presto COST IT Module
Botswana - Cost Analysis with Presto COST IT Module
Slovenia - Cost Analysis with Presto COST IT Module
Croatia - Cost Analysis with Presto COST IT Module
Serbia - Cost Analysis with Presto COST IT Module
Bhutan - Cost Analysis with Presto COST IT Module