Course Content

1: Snowflake Architecture & Feature

• What is Snowflake & Key Features
• Snowflake Architecture (3 layers)
  a) Storage Layer
  b) Compute Layer (Query Processing)
  c) Services Layer
• Snowflake Editions
  a) Standard
  b) Enterprise
  c)  Business Critical
  d)  Virtual Private Snowflake
• Core Objects
  a) Warehouse
  b) Roles
  c) Database
  d) Schema
  e)Tables (Permanent, Transient, Temporary)
  f) Views (Non-Materialized, Materialized, Secure
• Hands-on
  a) Creating Databases, Schemas, Tables, Views
  b) Exploring Web UI(IDE)
• Billing Overview: Understanding credits & cost visibility
• Snow SQL Introduction & Basic Commands – DDL / DML
• Understand how Snowflake differs from traditional DWH
• Explain architectural components
• Perform basic DDL/DML operations
• Use Snow SQL for basic operations

2: Performance Concepts & Virtual Warehouse

• Virtual Warehouse Concepts
• Sizing, Scaling, and Billing Implications
• Multi-cluster Warehouses
• Resource Monitors: Setup and Use Cases
• Monitoring Compute Usage
• Billing Overview
• Multi-Cluster Warehouse
• Zero Copy Clone
•  Choose an appropriate warehouse size for workloads
• Implement resource usage controls
• Monitor compute consumption effectively

3: Performance Concepts & Query Optimization

• Query Caching (Result, Metadata, Data)
• Clustering Concepts and Manual Clustering
• Zero Copy Cloning: Use cases & Cost Impact
• Query Profile & Query History: Performance Analysis
•  Identify and leverage performance optimization techniques
• Use query analysis tools
• Implement cost-saving strategies like cloning

4: Data Loading and Unloading

• File Formats: CSV, JSON, Parquet, etc.
• Staging Data:
  a) Internal Stages (User, Table, Named)
  b) External Stages (AWS S3, Azure, GCP)
• COPY INTO Command: Syntax, Errors, Best Practices
• Snow PIPE Basics: Automated Ingestion
• Data Unloading: Unload data to stages

 5: Storage Layer & Data Protection

• Storage Layer Deep Dive
• Micro-partitioning: Structure & Benefits
• Time Travel: Recovery and Historical Access
• Fail-Safe: Data Recovery Mechanism (limitations, cost)

6:Snowflake Security & Access Control

7. Data Sharing & Data Marketplace

8. Python with Snowpark

9.UDFs, Stored Procedures, and Tasks