|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/ultimate-snowflake-challenges/
课程评论:没有评论
课程名称:终极雪花挑战:十大实战技巧 课程概述:课程由一位世界级的雪花数据专家讲授,他曾是“数据超级英雄”,并在SnowPro认证中担任过主题专家,参与过多个考试问题的设计。课程将带您深入了解雪花的数据架构,同时解决各种复杂的SQL查询和层次数据问题。 学习内容: - 探索雪花中一些鲜为人知但有趣的知识点 - 解决雪花查询中的棘手问题 - 修正中级到高级的SQL查询 - 在雪花中使用有趣和富有挑战性的难题 - 以有趣和引人入胜的方式深入了解雪花生态系统 - 独立思考并尝试解决问题,观看实战实验并跟随提示 - 学习中级到高级的SQL和Python编程 - 了解如何在雪花中使用Streamlit - 获取先进的技巧和窍门 课程将涵盖的雪花知识领域: - 时间旅行 - 审计和查询历史 - 生成合成但真实的数据 - 数据分类 - 从Python代码调用的Snowpark存储过程 - Streamlit应用 - 数据清理室 - 行访问策略 - 雪花中的SQL查询 - 查询元数据 - 用户管理和无服务器任务 - 雪花的虚拟仓库 - 图表和图形 - 针对层次数据的递归SQL查询 - 半结构化数据 - 成本管理和成本估算 - 多表插入 - 扩展的透视查询 - 多租户架构 - SnowSQL变量替换 - 对象依赖关系 - Python工作表 立即注册,您一定不会后悔!
Who I AmWorld-Class Expert in Snowflake.Former Snowflake "Data Superhero".Former SnowPro Certification SME (Subject Matter Expert): many exam questions have been created by me.SnowPro Exams in Core, Architect, Data Engineer, and Data Analyst Certifications.Seasoned Data Architect, Data Engineer, Machine Learning Engineer...What You Will Learn More AboutFind out about some obscure but very interesting things in Snowflake.Solve tricky issues with Snowflake queries and hierarchical data.Fix intermediate to advanced SQL queries.Solve funny and challenging puzzles using Snowflake.Learn more about the Snowflake ecosystem in a funny and engaging way.See the questions and try to solve them on your own.Watch my hands-on experiments and follow my hints.Follow extra-curriculum recommended material.Learn intermediate to advanced SQL and Python programming in Snowflake.Learn something about Streamlit and how to use it in Snowflake.Advanced tips and tricks.What Snowflake Areas Will Be ConsideredTime TravelAuditing and Query HistoryGenerating Synthetic but Realistic DataData ClassificationSnowpark Stored Procedures from Python CodeStreamlit AppsData Clean RoomsRow Access PoliciesSQL Queries in SnowflakeQuerying MetadataUser-Managed and Serverless TasksDetails on Snowflake's Virtual WarehousesCharts and GraphsRecursive SQL Queries on Hierarchical DataSemi-Structured DataCost Management and Cost EstimatesMultiple-Table InsertsExtended Pivot QueriesMulti-Tenant ArchitecturesSnowSQL Variable SubstitutionObject DependenciesPython Worksheets== Enroll today, you'll not regret it! ==