• Introduction to SQL and Advance analytics functions.
• Introduction to Data warehouse.
•  Snowflake Masterclass

Section 1 : Introduction
What is a data warehouse?
Why cloud computing?
The Snowflake History

Section 2 : Getting Started with Snowflake
Signup for Snowflake
Using Snowflake UI
Creating our first Database, Schema & Table
Load Data into our first table
Setting up Required Snowflake tools
Assignment & Quiz

Section 3 : Snowflake Warehouse for Compute
Creating our first Virtual Warehouses
Virtual Warehouses sizes & Scalability
Warehouse - Maximized vs Auto Scale
Multi-Cluster Warehouse Scaling Policy's
Assignment & Quiz

Section 4 : Architecture, Features & Pricing
Key Concepts & Architecture
Supported Cloud Platforms & Regions
Snowflake Editions
Snowflake Releases
Snowflake Pricing
Data Integration
Assignment & Quiz

Section 5 : Loading & Unloading Structured Data
Ingestion / Loading Methods
Steps to Managing Loads
Preparing your data
Staging your data
Loading data from an Internal stage
Loading data from different Internal stages
Loading data from External S3 stages
What is Snowpipe?
Loading data via Snowpipe - high level steps
Unloading of data
Assignment & Quiz

Section 6 : Semi Structured Data
Loading and Unloading JSON data - high level steps
Analytics on JSON data - hands on lab
ORC data handling
Parquet data handling
Assignment & Quiz

Section 7 : Stage data transformations
Querying Data in Staged Files
Querying Metadata for Staged Files
Transforming Data During a Load
Assignment & Quiz

Section 8 : Databases, Tables & Views
Working with Temporary, Transient & Permanent Tables
Working with Externals Tables
Overview of Views
Working with Materialized Views
Table Design Considerations
Assignment & Quiz

Section 9 : Time Travel, Failsafe & Zero Copy Clones
Back to the future with Snowflake
Travel to a specific time or before a query
Assignment : Time Travel to a point in time
Undrop databases, schema & tables
Assignment : Un-drop tables, schemas & databases
Assignment : Test drive the time travel
Failsafe in Snowflake
Lab : View storage used by Fail-safe
Assignment : Understanding storage used by Fail-safe
Zero Copy Clone
Cloning with Time Travel
Assignment & Quiz

Section 10 : Performance Optimization
Performance Optimization in Snowflake
Using Dedicated Virtual Warehouses
Multi-cluster virtual warehouse or Scaling Out
Maximize Cache Usage
Lab : Query Caching in Action
Clustering large tables & improve partition elimination
Lab : Cluster keys for large tables
Search Optimization
Assignment & Quiz

Section 11 : Secure Data Sharing
Secure Data Sharing in Snowflake
Sharing with other Snowflake users
Assignment : Share a table with another Snowflake user
Sharing - Who's compute is used?
Sharing - Data always up-to date
What is a share?
Sharing with non Snowflake users
Lab : Sharing with non Snowflake users
Assignment : Share a table with non Snowflake user
Lab : Sharing entire schemas & databases
Lab : Sharing views
Assignment : Share a view, combining data from multiple tables
Assignment & Quiz

Section 12 : Snowflake Access Management
Snowflake Approach to Access Control & Key Concepts
Role Hierarchy in Snowflake
ACCOUNT ADMIN role
Outline of the IAM hands on lectures
SECURITY ADMIN role
SYSADMIN role
Custom roles
PUBLIC roles
Assignment & Quiz

Section 13 : Advanced Features
Change Tracking Using Table Streams
Schedule Using Tasks
UDF
Stored Procedures
Column-level Security
Row-level Security
Working with Resource Monitors

Milestone project