- 具有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