Course Content

​

Module 1: Introduction to Snowflake

• What is Snowflake?

• History and evolution of cloud data warehousing

• Key features of Snowflake

• SaaS model & multi-cloud support

• Snowflake Editions & Pricing

• Snowflake vs Traditional Data Warehouses (Redshift, BigQuery, Synapse)

Module 2: Snowflake Architecture

• Cloud Services Layer

• Compute Layer (Virtual Warehouses)

• Storage Layer

• Separation of Storage & Compute

• Micro-partitioning

• Caching in Snowflake

• Time Travel & Fail-safe

• Snowflake Ecosystem Overview

Module 3: Getting Started

• Creating a Snowflake account (Trial)

• Understanding UI, Worksheets & Snowsight

• Role-based access control overview

• Creating Users & Roles

• Creating Databases, Schemas & Warehouses

• Resource Monitors & Cost Controls

Module 4: Snowflake SQL Essentials

• Basic SQL (SELECT, WHERE, GROUP BY, ORDER BY)

• Joins & Subqueries

• CTEs

• Window Functions

• Conditional Expressions

• Built-in Functions

• Semi-structured data queries (JSON, XML, AVRO)

Module 5: Managing Snowflake Storage

• Stages (Internal & External)

• File Formats (CSV, JSON, PARQUET)

• Loading Data with COPY INTO

• Snowpipe (Auto-ingestion)

• Unloading data from Snowflake

• Data retention & storage optimization

Module 6: Snowflake Compute & Performance Optimization

• Virtual Warehouses

• Warehouse Sizing & Auto-scaling

• Query Profiling & Optimization

• Clustering Keys

• Caching Benefits

• Best Practices for Cost Optimization

Module 7: Semi-Structured Data Handling

• VARIANT data type

• Working with JSON / PARQUET

• FLATTEN function

• Schema-on-read

• Best practices for handling complex data

Module 8: Data Sharing & Collaboration

• Secure Data Sharing

• Snowflake Marketplace

• Reader Accounts

• Data Exchange

• Use cases for enterprise collaboration