Snowflake Decoded - Fundamentals And Hands On Training

Master the Fundamental Snowflake concepts & acquire the necessary skills to start implementing Snowflake based solutions

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