● What is Cloud?
● Different Cloud Vendors
● Advantages of Cloud over Traditional Databases

● What is a Data Warehouse?
● Database Vs Data Warehouse
● Why do we need a Data Warehouse?
● OLTP Vs OLAP
● What is ETL?

● Supported Cloud Platforms
● Snowflake Architecture
● Cloud Service Layer
● Compute or Query processing Layer
● Storage Layer
● Snowflake Editions
● Setting up virtual warehouses

● User Interface – snow sight
● SnowSQL (CLI Client)
● Using python

● Introduction to Time Travel
● Configure Retention time property
● Query historical results
● Clone historical objects
● Restore the dropped objects

● Introduction to Fail safe
● Check fail safe storages consumption
● Fail safe storage charges

● Different table types
● Permanent tables & databases
● Transient tables & databases
● Temporary tables & databases

● Partitioning in Traditional Data Warehouses
● Partitioning in Traditional Data Warehouses
● Advantages of Micro-Partitioning
● Structure of Micro-Partition
● Query Processing 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

● Creating stage & raw file
● Parsing JSON
● Handling nested data
● Dealing with hierarchy
● Insert final data

● What is a stage? Types of stages
○ Table stages
○ User Stage
● Named Stage
● Creating stages
● Data Loading/Unloading into/from stages
● Querying Data in Staged Files
● External stages
○ AWS registration
○ Bucket creation
○ IAM policies
○ Accessing bucket through outside
○ Integrating AWS S3 to snowflake
○ Loading files from S3 but to snowflake

● Introduction to Snowpipe
● Load CSV data from S3 using Snowpipe
● Load JSON data from S3 using Snowpipe
● Snowpipe

● Introduction to Data Sharing
● Data Providers
● Data Consumers
● INBOUND and OUTBOUND Shares

● Introduction to Tasks
● Task tree
● Implement standalone task
● Check task history

● Introduction to streams
● Insert operation in streams
● Delete operation in streams
● Update operation in streams

● 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

● Downloading and installing SnowSQL
● Creating database, tables in SnowSQL
● Loading and unload data using
● SnowSQL

● System Usage & Billing
● Understanding Snowflake Credit and Storage Usage

● System defined User roles
● Custom roles
● Creating Users
● Creating Custom Roles
● Granting roles to users
● Data Encryption in Snowflake
● Data Encryption at customer side

● 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

● Cache introduction
● Types of Cache in Snowflake

● Views in Snowflake
● Secure views in Snowflake
● Views vs. Secure Views
● Understand and create materialized views
● Refresh materialized views
● When to use materialized views

● Understanding data masking
● Creating a masking policy
● Recreate and Unset Masking Policy
● Apply Masking policies on objects
● Alter Masking Policies