Snowflake Decoded - Fundamentals And Hands On Training

What you'll learn
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
Requirements
Familiarity with database & data warehousing concepts
Familiarity with SQL
Description
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 SnowflakeArchitecture - 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.
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 The Snowflake Story
Section 2: Getting Started with Snowflake
Lecture 3 Signup for Snowflake
Lecture 4 Downloading Resources for this course
Lecture 5 What to do if you encounter low video quality in a lecture?
Lecture 6 Creating our first Database & Table
Lecture 7 Load Data into our first table
Lecture 8 Snowflake Pricing Overview
Lecture 9 Setting up Required Snowflake tools
Section 3: Snowflake Concepts
Lecture 10 Optional: What is a data warehouse?
Lecture 11 Optional: Why cloud computing?
Lecture 12 Snowflake Architecture
Lecture 13 Virtual Warehouse & Scalability
Lecture 14 Snowflake Pricing
Section 4: Getting data into Snowflake
Lecture 15 Ingestion / Loading Methods
Lecture 16 4 Steps to Managing Loads
Lecture 17 Preparing your data
Lecture 18 Staging your data
Lecture 19 Loading from an S3 stage
Lecture 20 Loading JSON data - high level steps
Lecture 21 Loading JSON data - hands on lab
Lecture 22 What is Snowpipe?
Lecture 23 Loading data via Snowpipe - high level steps
Lecture 24 Loading data via Snowpipe - hands on lab
Section 5: Performance Optimisation
Lecture 25 Performance Optimisation in Snowflake
Lecture 26 Using Dedicated Virtual Warehouses
Lecture 27 Lab: Using Dedicated Virtual Warehouses
Lecture 28 Scale up/down the virtual warehouse
Lecture 29 Multi-cluster virtual warehouse or Scaling Out
Lecture 30 Lab: Multi-cluster virtual warehouse
Lecture 31 Maximise Cache usage
Lecture 32 Lab: Query Caching in Action
Lecture 33 Clustering large tables & improve partition elimination
Lecture 34 Lab: Cluster keys for large tables
Section 6: Time Travel, Failsafe & Zero Copy Clones
Lecture 35 Back to the future with Snowflake
Lecture 36 Travel to a specific time or before a query
Lecture 37 Undrop databases, schema & tables
Lecture 38 Failsafe in Snowflake
Lecture 39 Lab: View storage used by Fail-safe
Lecture 40 Zero Copy Clone
Lecture 41 Cloning with Time Travel
Section 7: Secure Data Sharing
Lecture 42 Secure Data Sharing in Snowflake
Lecture 43 Sharing with other Snowflake users
Lecture 44 Sharing - who's compute is used?
Lecture 45 Sharing - Data always up-todate
Lecture 46 What is a Share?
Lecture 47 Sharing with non Snowflake Users
Lecture 48 Lab: Sharing with non Snowflake Users
Lecture 49 Lab: Sharing entire schemas & databases
Lecture 50 Lab: Sharing views
Lecture 51 Using the Web UI to share
Section 8: Snowflake Access Management
Lecture 52 Snowflake Approach to Access Control & Key Concepts
Lecture 53 Out of the Box Snowflake Roles
Lecture 54 Role Hierarchy in Snowflake
Lecture 55 ACCOUNTADMIN role
Lecture 56 Outline of the IAM hands on lectures
Lecture 57 Lab: Demonstrating ACCOUNTADMIN role
Lecture 58 SECURITYADMIN role
Lecture 59 Lab: Demonstrating SECURITYADMIN role
Lecture 60 SYSADMIN role
Lecture 61 Lab: Demonstrating SYSADMIN role
Lecture 62 Lab: Demonstrating use of the Custom Roles
Lecture 63 Custom roles
Lecture 64 PUBLIC role
Section 9: Conclusion & Mega Quiz
Lecture 65 Conclusion
Snowflake beginner to intermediate skills.,Basic knowledge of databases & data warehousing


Homepage

https://www.udemy.com/course/snowflake-essentials/