Following Snowflake Syllabus will be coverd along with some more advanced concepts and explanations

Section 1 : 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

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

Section 3 : Architecture, Features & Pricing
• Key Concepts & Architecture
• Supported Cloud Platforms & Regions
• Snowflake Editions
• Snowflake Releases
• Snowflake Pricing
• Data Integration

Section 4 : 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

Section 5 : Semi Structured Data
• Loading and Unloading JSON data - high level steps
• ORC data handling
• Parquet data handling

Section 6 : Stage data transformations
• Querying Data in Staged Files
• Querying Metadata for Staged Files
• Transforming Data During a Load

Section 7 : Databases, Tables & Views
• Working with Temporary, Transient & Permanent Tables
• Working with Externals Tables
• Overview of Views
• Working with Materialized Views
• Table Design Considerations

Section 8 : Time Travel, Failsafe & Zero Copy Clones
• Back to the future with Snowflake
• Travel to a specific time or before a query
• Un drop databases, schema & tables
• Failsafe in Snowflake
• Zero Copy Clone
• Cloning with Time Travel

Section 9 : Performance Optimization
• Performance Optimization in Snowflake
• Using Dedicated Virtual Warehouses
• Multi-cluster virtual warehouse or Scaling Out
• Maximize Cache Usage
• Clustering large tables & improve partition elimination
• Search Optimization

Section 10 : Secure Data Sharing
• Secure Data Sharing in Snowflake
• Sharing with other Snowflake users
• Sharing - Who's compute is used?
• Sharing - Data always up-to date
• What is a share?
• Sharing with non-Snowflake users

Section 11 : 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

Section 12 : Advanced Features
• Change Tracking Using Table Streams
• Schedule Using Tasks
• UDF
• Snow Scripting
• Stored Procedures
• Column-level Security
• Row-level Security
• Data Masking
• Tagging in Snowflake
• Working with Resource Monitors
• ELT Vs ETL
• Type of Loads (Incremental/Full/Batch/Bulk)
• Understanding SCDs