Snowflake Decoded - Fundamentals and hands on Training
- 4.5 hours on-demand video
- 32 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- Snowflake Essentials, it's unique architecture & its differentiation
- Scalability through the virtual warehouse compute clusters
- Staging & Ingesting bulk & streaming data from cloud storage
- Unique features such as zero copy clones, time travel
- Snowflake value proposition through its pricing model
- Secure data sharing with snowflake & non-snowflake users
- Familiarity with database & data warehousing concepts
- Familiarity with SQL
This course is not affiliated with Snowflake (the company).
This course provides Snowflake concepts & hands on expertise to help get you started on implementing solutions using Snowflake. This course reinforces the learning through hands on labs, assignments & quizzes.
At a high level we will go through the following topics
Introduction - A bit of history about snowflake & its differentiation.
Getting Started with Snowflake - Sign up for a snowflake trial, setup the required tools and will create & load our first table into Snowflake
Architecture - A look into the snowflake concepts, how the snowflake decoupled architecture differs from the traditional database architectures. We will explore how Snowflake virtual warehouses allow scaling up and down of compute as per demand.
Getting data into Snowflake - We will explore the ingestion or loading methods available in Snowflake i.e. bulk copy & snowpipe. We will stage the data in an S3 bucket and load into Snowflake table using both bulk copy and snowpipe. We will also explore ways to load semi structured data like JSON into Snowflake.
Time Travel & Zero Copy Clones - Time travel & cloning is a very powerful feature unique to Snowflake. We will explore how time travel can help you recover data before a query was run or before a specific time. Combine time travel with cloning and you can create new tables which contain data back in time, and all that without incurring additional storage cost.
Secure Data Sharing - Snowflake based solutions can easily share data with other Snowflake users as well as non Snowflake users. We will explore ways on how to share your data and also how the sharing reuses existing storage.
- Snowflake beginner to intermediate skills.
- Basic knowledge of databases & data warehousing
In this optional lecture we will explore the concept of a cloud computing, why it was needed and the advantages it brings. We will also look at the various flavours of offerings i.e. On-Premise, IaaS, PaaS, SaaS etc.. If you are already aware of the concepts please feel free to skip this lecture.
This lecture describes the unique architecture that snowflake utilises, which enables a per second pricing and allows a snowflake to scale independent of storage
What-if snowflake would take care of increasing & decreasing the virtual warehouses in your system. Meet "Multi-cluster virtual warehouses", through which you can set your snowflake system to scale out and scale back "automagically" in response to changing demands.
When tables become very large, you would usually want some control on their partitioning. Clustering keys is the way to define the partitioning schemes in Snowflake. In this lecture we will look at what clustering keys are and how do they improve performance
This lecture introduces the students to the concept of time travel in Snowflake, which enables users to see their data as it was on a specific date/time or as it was before a query was executed.
In this series of lectures we will explore the unique data sharing capabilities provided by Snowflake which enables easy, least effort sharing of data with other snowflake customers & even with non-snowflake users.