|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/snowflake-cost-optimization-techniques/
课程评论：没有评论
**课程名称：** 100 种 Snowflake 成本优化技巧 **课程概述：** 本课程旨在帮助您掌握在 Snowflake 中优化成本的各种技术和策略，让您能够更经济高效地使用 Snowflake 平台。您将学到： * **虚拟仓库优化：** 如何利用更大但成本更低的仓库来处理查询，以及如何根据工作负载调整仓库大小。 * **成本陷阱规避：** 识别并避免 Snowflake 中常见的成本陷阱，通过调整参数值来降低不必要的开销。 * **查询、计算和存储优化：** 全面优化 SQL 查询性能、计算资源使用以及数据存储，从而实现整体成本的降低。 * **仓库整合与利用：** 如何有效整合和管理未充分利用的仓库，提高资源利用率。 * **Serverless 功能成本管理：** 理解 Snowflake 各个 Serverless 功能的工作原理，并学会估算其成本。 * **并行数据处理：** 在数据传输和处理的各个环节中，最大化利用并行能力以提升效率和降低成本。 * **多版本 Snowflake 整合：** 如何在组织内有效地部署和组合使用不同版本的 Snowflake。 * **数据可视化辅助分析：** 利用数据可视化工具来更好地估算和监控您的 Snowflake 支出。 * **跨账户成本控制：** 掌握降低在所有 Snowflake 账户上支出的通用方法。 此外，本课程还提供超过 300 页的高质量演示文稿，详细总结了每个优化技巧，以及一个包含数十个动手练习和实验的开源 GitHub 仓库。 **知识应用场景：** * 大幅降低您个人 Snowflake 账户的成本。 * 更高效地创建和管理多个不同版本的 Snowflake 账户。 * 帮助您的客户减少在 Snowflake 上的开支。 * 协助您的雇主在组织内部降低 Snowflake 成本。 * 识别并避免使用 Snowflake 时大多数人会遇到的常见误区。 * 编写高性能且成本效益高的 SQL 查询。 * 学习如何通过使用大型仓库和数百个节点来实现更低成本的查询。 **Snowflake 核心能力学习：** * 深入了解虚拟仓库的概念和管理。 * 掌握查询的监控和优化方法。 * 学习资源监视器和预算的配置与应用。 * 理解查询加速和搜索优化的原理。 * 学习高效的自动聚类和物化视图维护。 * 全面了解 Time Travel 和 Zero-Copy Cloning 的功能和使用。 * 学习如何高效地部署 Snowflake 以及与其他应用的集成。 **讲师资质：** * 2021 年被选为 Snowflake 数据超级英雄，是来自加拿大的世界级专家。 * SnowPro 认证的科目专家 (SME)，参与创建了许多 SnowPro 考试题目。 * 已通过四项 SnowPro 认证考试（Core, Architect, Data Engineer, Data Analyst），且均一次通过。 * 专注于 Snowflake 领域数年，曾在 Snowflake 合作伙伴公司工作，为数十位客户提供咨询服务，并分享其专业知识。 **课程价值声明：** 本课程是 Snowflake 成本优化的“圣经”，保证提供比任何其他课程、书籍或文档都更深入的见解、实际操作实验和知识转移。现在报名，即可永久拥有此课程。
What You Will Learn About SpendingHow to use even bigger virtual warehouses for less expensive queries.How to avoid huge cost traps in Snowflake by changing different parameter values.How to optimize queries, compute, storage and overall costs in Snowflake.How to properly consolidate underutilized warehouses.How each serverless feature in Snowflake works and how to estimate their cost.How to use parallel data transfer and processing everywhere you can.How to combine different Snowflake editions in your organization.How to use better data visualizations to estimate spending.How to reduce your spending on all your Snowflake accounts.I also offer over 300 high-quality presentation slides with the summary on each tip or technique!Where You May Use This KnowledgeDrastically reduce costs on your own Snowflake accounts.Create more Snowflake accounts - with different editions - and use them efficiently.Help your clients reduce spending on their Snowflake accounts.Help your employer reduce costs on Snowflake in your own organization.Learn to recognize the traps most people fall into when using Snowflake.Create not just highly performant, but also cost-effective SQL queries.Learn how to get cheaper queries with huge warehouses, using hundreds of nodes.I also offer an open-source GitHub repository with dozens of hands-on exercises and experiments!What You Will Learn About SnowflakeLearn all about the virtual warehouses.Learn how to monitor and optimize queries.Learn about resource monitors and budgets.Learn query acceleration and search optimizationEstimate efficient automatic clustering and maintenance of materialized views.Learn all that matters about time travel and zero-copy cloning.Learn how to efficiently deploy and combine Snowflake with other applications.I have many brief but focused hands-on presentations of different Snowflake features!Who I AmThe only world-class expert from Canada selected for the Snowflake Data Superhero program in 2021.SnowPro Certification SME (Subject Matter Expert) - many SnowPro exam questions have been created by me.Passed four SnowPro certification exams to date (with no retakes): Core, Architect, Data Engineer, Data Analyst.Specialized in Snowflake for the past few years: I worked for Snowflake Partner companies, I served dozens of clients in this capacity or as an independent consultant, today I share my knowledge with highly specialize courses on Snowflake.This is truly "the" Bible on Snowflake spending!No other course, book or documentation around will offer as much insights, hands-on experiments and knowledge transfer on optimizing the cost on Snowflake as my course here, guaranteed!Enroll today, and keep this course forever!
