Trending Programs
SNOWFLAKE TRAINING PROGRAM
Module 1: Introduction & History of Snowflake
Snowflake History
Cloud Data Platform
Modern Data Architecture
Value Of Cloud Data Platform
One Platform, One Data Copy, Many Workload
Module 2: Snowflake editions and Self-Registration
How To Choose Snowflake Editions
How To Choose Cloud Providers & Editions
How To Choose Compute & Storage Pricing
Create User
Validating Snowflake Instance
Module 3: Snowflake Architecture
Snowflake Architecture
3 Layers Services (Storage, Compute & Service)
Snowflake At A Glance
Snowflake Capabilities & Unique Features
Classic Web UI Layout
Switching Role & Performance
Module 4: Snowflake Legacy WebUI
Classic Web Ui Layout
Switching Role & Performance
Top Bar (Databases, Shares, Data Marketplace, Warehouse, History)
SQL Worksheet & Object Navigations
Query Profile & Other Features
Module 5: SnowSight (Modern Web UI)
Access SnowSight Via Preview App
Legacy Web UI Vs SnowSight
Worksheets & Data Profiling
Dashboard & Sharing
Module 6: Snowflake Objects – Databases, Schema & Tables
Snowflake Account & Container Hierarchy
Account, Database & Schema Level Objects
Display & Describe Objects
Table Objects – Permanent, Transient, Temporary
Module 7: Snowflake Role Hierarchy
What Are RBAC & DAC Concepts
Default Roles In Snowflake
Role Hierarchy & Its Power
Grants Privileges
SQL Commands For Roles
Roles & Data Privacy
Design & Implementation Roles In Snowflake
Module 8: Snowflake Objects (What’s New) & Snowflake
Bulk/Batch Load
File Formats
Stage Objects
Overview Of Data Loading
Understand Stage Concept Using Internal Stage
Understanding Stage Concept Using External Stage
Integration Objects In External Stage
Data Loading Feature
Data Loading Considerations
Bulk Load Using COPY Command
Module 9: Continuous Data Load- SnowPipe
Pipe Objects In Snowpipe
Overview Of Continues Data Loading
Snowpipe Hands On
Continuous Data Loading Considerations
Module 10: External Table & Data Load
External Table Architecture In Snowflake
SQL Construct + Options
Query External Table
External Table Auto Refresh
External Table Information Schema
Module 11: Virtual Warehouse
VWH Concept
VWH Size & Price (Different Edition)
VWH Auto Resume/Suspend Properties
Multi Cluster Concept
VWH Performance
VWH Monitoring
Module 12: Snowflake Monitoring & Billing
Resource Monitoring
Types Of Resource Monitor
Resource Monitor Frequency
Resource Monitor Notification
RM Trigger & Query Suspension Action
Module 13: Snowflake Cluster Concept
How Micro Partition Works In Snowflake
Micro Partition & Columnar/Compressed Format
What Is Clustering Key
Auto Partition & Re-Clustering
Clustering Depth & Clustering Overlap
Cost Of Re-Clustering With Partition Key
Query Performance Pruning & Query Profile
Module 14: Time travel
Data Protection & Time Travel
Time Travel & Snowflake Editions
Time Travel & Fail Safe
Time Travel For Permanent, Transient & Temporary Tables
Account Level Configuration For Time Travel
Extended SQL For Time Travel & Keywords
Cost Of Time Travel
Drop & Undrop Table, Schema & Table (Time Travel Feature)
Module 15: Data Masking Policy in Snowflake
Module 16: Views, Secure Views and Materialized Views
Module 17: Data Cloning Feature
Zero Copy Cloning
Objects That Can Be Cloned
Cost Of Cloning
DB & Schema Cloning
Roles & Grants & Cloning
Module 18: Snowflake Stream Objects
How Does Stream Work?
Type Of Streams + SQL Construct – SCD Type 2 Implementation
How To Consume Stream Data?
Stream & External Table
Cloning Stream
Offset Concept + Data Retention Parameters
Limitation Of Streams
Module 19: Dynamic tables in Snowflake and difference
between Streams vs Dynamic tables
Module 20: Snowflake Task Objects
How Does Task Object Work?
Task SQL Constructs & Scheduling
Stream & Task Together
Task Tree
Task Limitations
Module 21: Snowflake Data Sharing - Reader’s account
How Sharing Works
Types Of Sharing In Snowflake
Cross Region & Cross Cloud Sharing
Reader Account
Snowflake Edition Sharing
Storage & Compute Cost
Limitation With Sharing
Module 22: ETL in Snowflake (Streams & Task together)
How Task Works With Stream
Understand System$stream_has_data
CDC & Delta Processing
Merge Statements
End To End Data Flow
Module 23: Stored Procedure, UDF’s & Views
Stored Procedure Overview In Snowflake
Stored Procedure Languages – SQL, JavaScript, Scala And Python
Stored Procedures Vs UDFs
SQL Injection
Design Tips For Stored Procedure
Module 24: Snowflake Information Schema
Information Schema Views
Information Schema Table Functions
Account Usage Vs Information Schema
Module 25: Snowflake Connectors (JDBC/ODBC/Python)
JDBC
ODBC
Python
Module 26: Reporting tools with Snowflake – Sample reports
Build Web UI Using Streamlit