|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/programming-in-snowflake/
课程评论：没有评论
**课程名称：** Snowflake 编程精通实战 **课程概述：** 本课程面向具有 Snowflake、关系数据库、SQL 和 Python 编程**中级**基础的学习者。课程内容深入探讨 Snowflake 的高级特性，包括安全性、软件和数据工程、REST API 等，不适合初学者。 **讲师背景：** * 加拿大籍 Snowflake 数据超级英雄（2021 年）。 * 前 SnowPro 认证主题专家 (SME)，参与编写过大量考试题目。 * 已通过八项 SnowPro 认证考试，均一次性通过。 * 拥有数年 Snowflake 专注经验，曾为 Snowflake 合作伙伴公司工作，并为众多客户提供咨询服务。 * 目前独立从事 Snowflake 相关工作，不受公司约束。 **学习目标：** * **API 自动化和扩展：** 掌握通过 Snowflake 的各类 API 进行访问、扩展和自动化。 * **实时工具开发：** 使用 Snowflake API 构建实用的工具和小型应用程序。 * **数据摄取：** 通过数据管道和 Snowpipe 摄取 CSV 和 JSON 数据。 * **高级 SQL 查询：** 编写中等到复杂的数据分析查询。 * **性能和成本优化：** 优化查询、计算、存储及总体成本。 * **半结构化数据处理：** 处理和渲染 Snowflake 中的半结构化数据及元数据。 * **API 广度：** 涵盖 Snowflake SQL、Snowflake Scripting、存储过程、UDF、UDTF、Python 客户端、Snowpark for Python、Python Worksheets、Streamlit Web Apps、Streamlit for Snowflake、Snowflake Native Apps Framework、安全数据共享、Data Clean Rooms、私有数据交换/公开市场份额、Snowflake SQL REST API、Snowpipe REST API、Account Usage 和 Information Schema 的元数据查询等。 **课程不包含内容：** * 数据科学和机器学习 API。 * 大部分外部集成，如外部函数、Kafka 和 Spark 连接器。 * 与其他数据传输应用或第三方合作伙伴应用的集成。 * Go、PHP、Java 等语言的客户端驱动程序编程。 * Java 或 Scala 的 Snowpark 编程。 * （主要关注 SQL 和 Python，附带 JavaScript、C#、Java、Scala 的少量代码片段）。 **实战应用：** * **CDC 数据管道：** 使用 Streams 和 Tasks 或 Dynamic Tables 构建。 * **多层级数据查看器：** 实现通用和元数据（数据血缘、对象依赖、角色层级等）的多层级数据查看。 * **增强型查询剖析器。** * **脚本自动化：** 访问 SQL REST API。 * **Streamlit Web 应用和 Native Apps：** 从零开始构建应用，并使用 Streamlit 创建本地或远程 Web 应用，可部署到 Snowflake 或分享为 Native Apps。 **课程价值：** * 讲师保证提供比任何书籍或文档（包括 Snowflake 官方）都更深入的见解、实操练习和知识转移。 * 一次购买，永久访问，并可获得后续更新（随着 Snowflake 新 API 的发布）。
IMPORTANT: This course requires an INTERMEDIATE level and it may NOT be for you if you just recently started with Snowflake, relational databases, with SQL and/or Python programming. It occasionally deals with advanced notions about security, software and data engineering, REST APIs etc, that are not explained here. Check the minimum Requirements for this course, and the "What is NOT Included in This Course" section below, before buying this course.Who I AmThe only world-class expert from Canada selected for the Snowflake Data Superhero program in 2021.Former SnowPro Certification SME (Subject Matter Expert): i.e. many exam questions have been created by me.Passed eight SnowPro certification exams to date, all from the first attempt.Specialized in Snowflake for the past few years, I worked for Snowflake Partner companies, and I served dozens of clients in this capacity or as an independent consultant.Today I continue to work with Snowflake, but I am no longer affiliated with their company in any capacity. I recently left most of their programs to keep my professional independence.What You Will LearnHow to access, expand and automate Snowflake through most if not ALL their existing APIs.How to build useful real-life tools and small apps with Snowflake APIs.How to ingest CSV and JSON data into Snowflake, through data pipelines and Snowpipe.How to write medium to complex data analytics queries for Snowflake.How to optimize queries, compute, storage and overall costs for Snowflake.How to process and render semi-structured and hierarchical data and metadata in Snowflake.I tried to cover almost everything from Snowflake to date, only from a programming perspective.What Snowflake APIs You Will Learn AboutSQL (DDL/DML/DCL) and Snowflake ScriptingStored Procedures, User-Defined Functions (UDFs), User-Defined Table Functions (UDTFs)Python Client, Snowpark for Python, Python WorksheetsStreamlit Web Apps, Streamlit for Snowflake, Snowflake Native Apps FrameworkSecure Data Sharing and Data Clean RoomsSharing with private Data Exchange or public MarketplaceSnowflake SQL REST API and Snowpipe REST APIQuerying metadata from Account Usage and Information SchemaI tried to cover most possible APIs that Snowflake offers today!What is NOT Included in This CourseData Science and Machine Learning APIs.Most external integrations, such as external functions, or Kafka and Spark connectors.Integrations with data transfer applications or other third-party partner apps.Client driver programming in Go, PHP, Java etc.Snowpark programming in Java or Scala.Main focus was on SQL and Python, with small extra snippets in JavaScript, C#, Java, Scala.Real-Life Applications You Will Learn To BuildCDC Data Pipelines with streams and tasks, or dynamic tablesGeneric hierarchical data viewerHierarchical metadata viewer (for data lineage and object dependencies, role hierarchy, etc.)Enhanced query profileScript automation accessing the SQL REST APIWe'll build all apps from scratch. We'll use then Streamlit - for many of them - to create simple web apps, local or remote. We may deploy them into Snowflake, as Streamlit Apps. Or even share them with local partner accounts, as Native Apps.I sold tools similar to these to real-life clients and Snowflake partners!No other course, book or documentation around - including those from Snowflake! - will offer as much insights, hands-on exercises and knowledge transfer as my course here, guaranteed!Enroll today, to keep this course forever. And help me continue to update it with new APIs Snowflake comes frequently up with.
