1. Introduction to Cloud
• What is Cloud?
• Different Cloud Vendors
• Advantages of Cloud over On-Premise

2. Data Warehousing Concepts
• What is a Data Warehouse?
• Database Vs Data Warehouse
• Why do we need Data Warehouse?
• OLTP Vs OLAP
• What is ETL?

3. Introduction to Snowflake
• Supported Cloud Platforms
• Snowflake Architecture
• Cloud Service Layer
• Compute or Query processing Layer
• Storage Layer
• Snowflake Editions
• Setting up virtual warehouses
• Scaling policy

4. Connecting to Snowflake
• User Interface
• SnowSQL (CLI Client)
• Using python
• Using 3rd party tools

5. Data Loading and Unloading in Snowflake
• File formats supported in Snowflake
• Creating file formats
• Types of data loading
• Limited data
• Bulk data
• Continuous data
• Limited data loading/unloading using Web Interface
• Bulk data loading/unloading from/to local file
• Bulk data loading/unloading from/to Amazon S3
• Bulk data loading from Microsoft Azure
• Bulk data loading from Google cloud

6. Working with Semi-structured data in Snowflake
• Creating stage & raw file
• Parsing JSON
• Handling nested data
• Dealing with hierarchy
• Insert final data
• Loading PARQUET data

7. Stages
• What is a stage?
• Types of stages
• Table stages
• User stages
• Internal names stages
• External stages
• Creating stages
• Data Loading/Unloading into/from stages
• Querying Data in Staged Files

8. Snowflake Continuous Data Ingestion Service (Snowpipe)
• Introduction to Snowpipe
• Load CSV data from S3 using Snowpipe
• Load JSON data from S3 using Snowpipe
• Load Parquet data from S3 using Snowpipe

9. Sharing Data in Snowflake
• Introduction to Data Sharing
• Data Providers
• Data Consumers
Adding or removing consumer accounts
from share
• Create database from share in
• consumer account
• Sharing data with non-Snowflake
• customers (Reader Account)
• Create and Configure Reader Account
• Managing Reader Accounts
• Dropping shares

10. Tasks in Snowflake – Scheduling Service
• Introduction to Tasks
• Task tree
• Implement standalone task
• Check task history

11. Snowflake Streams – Change Data Capture (CDC)
• Introduction to streams
• Insert operation in streams
• Delete operation in streams
• Update operation in streams

12. Time travel
• Introduction to Time Travel
• Configure Retention time property
• Query historical results
• Clone historical objects
• Restore the dropped objects

13. Fail Safe
• Introduction to Fail safe
• Check fail safe storages consumption
• Fail safe storage charges

14. Zero Copy Cloning
• Introduction to Zero Copy Cloning
• Clone Database, Pipes, Streams, Tasks & Stages
• Clone Schema and Tables
• DML changes in cloned table
• Cloning using Time Travel
• Swap the Tables

15. SnowSQL
• Downloading and installing SnowSQL
• Creating database, tables in SnowSQL
• Loading and unload data using SnowSQL

16. Managing Your Snowflake Account
• System Usage & Billing
• Understanding Snowflake Credit and Storage Usage

17. Understanding Snowflake Data Transfer Billing
• Monitoring Credit and Storage Usage
• Resource Monitors
• Parameter Management
• User Management

18. Types of Tables in Snowflake
• Different table types
• Permanent tables & databases
• Transient tables & databases
• Temporary tables & databases

19. Micro-Partitioning in Snowflake
• Partitioning in Traditional Data Warehouses
• Partitioning in Snowflake – Micro Partitioning
• Advantages of Micro-Partitioning
• Structure of Micro-Partition
• Query Processing in Snowflake

20. Managing Security in Snowflake
• System defined User roles
• Custom roles
• Creating Users
• Creating Custom Roles
• Granting roles to users
• Multi-Factor Authentication (MFA)
• Access Control in Snowflake (DAC & RBAC)
• Data Encryption in Snowflake

21. Snowflake Pricing
• What are Snowflake Credits?
• Server less Features cost
• Storage Cost
• Check storage cost for different regions
• Virtual Warehouses – Compute Cost
• Cloud Services Cost
• Data Transfer Cost
• Check consumed CREDITS on your account

22. Performance Tuning
• Performance in Snowflake
• Create dedicated virtual warehouses
• Scaling up and Scaling down
• Caching
• Clustering

23. Caching in Snowflake
• Cache introduction
• Types of Cache in Snowflake

24. Views, Secure Views and Materialized views
• Views in Snowflake
• Secure views in Snowflake
• Views vs Secure Views
• Understand and creating materialized views
• Refresh materialized views
• When to use materialized views

25. Dynamic Data Masking
• Understanding data masking
• Creating a masking policy
• Recreate and Unset Masking Policy
• Apply Masking policies on Views
• Alter Masking Policies

26. Resource monitors (Track Compute Consumption)
• Resource Monitors – Introduction
• Properties of Resource Monitor
• Actions or Triggers of Resource Monitors
• Suspension or Resumption
• Create a Resource Monitor using Web UI
• SQL queries to Create Resource Monitor

27. Data Sampling
• Why data sampling?
• Methods of data sampling
• Sampling data: Hands-on

28. Snowflake Partner Connect
• Introduction to Partner Connect
• Know about available Tools
• Start Free Trial for Matillion ETL

29. Visualization – Power BI & Tableau
• Data Visualization
• Download & install Power BI
• Connect Power BI & Snowflake
• Working in Power BI
• Download & install Tableau
• Connect Tableau & Snowflake
Mini Project – Setup Row Level Security
We will build mini – project to understand project structure in Snowflake.

Real time major project – Complete End to End data pipe line (Real time data moving from AWS to Snowflake)
We will build Major project from scratch where we used most of features available in
Snowflake and so that you will get complete real time analysis about snowflake projects.