|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/snowflake-cloud-data-warehouse/
课程评论：没有评论
课程名称：Snowflake大师班（存储过程+演示+最佳实践+实验室） 课程概述：本课程旨在帮助您理解如何使用Airflow、Talend和Snowflake构建工作流程。如果您希望学习与Snowflake云数据库及其ETL（Airflow+Python+Talend）相关的知识，可以查看我最新的课程。2023年4月9日，我更新了课程内容，新增了关于Snowflake搜索优化服务、外部表、行访问策略及标记功能的章节。本课程是我在Snowflake工作超过四年的经验的结果，Snowflake是一个处理海量数据的绝佳工具。您可以轻松地加载、查询和导出TB和PB级的数据，并执行事务查询。使用Snowflake时，您无需担心基础设施设置、安全性、性能调优、垃圾收集、节点故障等问题。如果您曾经使用Spark与EMR或Data bricks，您会对Snowflake的性能与简单性感到惊讶。然而，如果您对Snowflake的工作原理不够了解，您可能会失去控制，编写成本高昂的查询，并错误使用许多Snowflake特性。由于Snowflake是为了性能而构建的，错误的查询和设计决策会导致您的账单飙升。我犯过很多这样的错误，并从中吸取了教训。这个课程旨在通过我的经历引导您，避免犯相同的错误。许多细节只能通过经验学习，而这些在文档中无法找到，本课程将向您揭示这些内容。 课程分为三个模块： 模块一： - 讲座：38 - 实时演示：11 - 作业：10 - 测验：6 该模块将巩固Snowflake的基础概念和架构，使您对Snowflake有一个坚实的基础。 模块二： - 讲座：46 - 实时演示：31 - 作业：14 - 测验：2 该模块将带您了解在Snowflake中加载和卸载数据的不同技术和方法，您将在此模块结束时对使用COPY命令和不同数据处理对象充满信心。 模块三： - 讲座：45 - 实时演示：35 - 测验：3 该模块将深入评估Snowflake的重要特性，帮助您理解每个特性的底层工作原理，使您在决定何时使用这些特性时更具判断力。 各模块内容概述： **模块一**：Snowflake环境设置、架构、缓存、微分区、集群、虚拟仓库层、性能调优及数据库特性。 **模块二**：在Snowflake中加载数据、使用内部阶段加载数据、从AWS S3、Google GCS和Azure加载数据、COPY命令选项及工作、加载非结构化数据。 **模块三**：Snowpipe、数据共享、时间旅行、故障保护、克隆功能、数据采样、任务、流式处理、连续数据加载、物化视图。 欢迎加入这个学习之旅！
If you would like to understand how to build workflows using Airflow, Talend and Snowflake Please check out my new course,Snowflake cloud database with ETL(Airflow+Python+Talend)Latest update: Added new section on snowflake search optimisation service.( 9th April 2023 ) Added new section on snowflake external tables. Added new section on ROW ACCESS POLICY in snowflake. Added new section on Tagging in Snowflake This course is the result of my over 4 years of experience working with Snowflake. Snowflake is a fantastic tool to handle huge volumes of data. You can load, query and export, and run transactional queries on TB's and PB's of data easily.You don't have to worry about infrastructure setup, security, performance, tuning, Garbage collection, node failures etc etc.if you have already worked with Spark with EMR or with Data bricks you will be amazed by snowflake performance and simplicity.But there is a catch, if you are not fully aware of how things works in snowflake, you will easily loose control and end up writing costly queries and end up using many of snowflake features wrongly.I mentioned costly queries because snowflake is build for performance.Costly queries and wrong design decisions in snowflake will sky rocket your snowflake bill. I have made lot of such mistakes and learned from those mistakes.This course is an effort to walk you through such experiences so that you don't end up doing same mistakes which i did!!!Few things can only be learned by experience you can't find them in documentations this course will expose such details to you.Hope you join me in this journey...................The course is broadly divided into 3 modules,Module#1 Lectures ------>: 38 Real time Demos--->: 11 Assignments----->: 10 Quiz--------->: 6 This module will concretize snowflake fundamental concepts and architecture. By the end of this module you will be having very strong foundation about snowflake.Module#2 Lectures ------>: 46 Real time Demos--->: 31 Assignments----->: 14 Quiz--------->: 2 In this module i will walk you through, different techniques and options to load and unload data in snowflake. By the end of this module, you will be having great confidence in using COPY command and different data processing objects in snowflake.Module#3 Lectures ------>: 45 Real time Demos--->: 35 Quiz--------->: 3 In this module, we closely evaluate important features of snowflake. This module helps you to understand, how each feature works under the hood. Through this knowledge you will be in a better position to decide, when to use the feature and when not to use the snowflake features.High level overview of all modules with sections details is given below,In module#1, > Snowflake environment setup. > Snowflake architecture. > Snowflake caching , micro-partitions, clusters. > Snowflake clustering deep dive. > Snowflake virtual warehouse layer. > Performance tuning and DB characteristics.In module#2, > Loading data in snowflake. > Loading data using internal stage. > Load data from aws s3. > Load data from google gcs. > Load data from Azure. > Copy command options. > Working with copy command. > Assignments. > Loading unstructured dataIn module#3, > Snowpipe in snowflake. > Data sharing in snowflake. > Time travel. > Fail safe. > Clone feature. > Data sampling. > Tasks in snowflake. > Streaming in snowflake. > Continuous data load. > Materialized views.
