SnowflakeIntermediate+250 XP

Snowflake — Zero to Advanced

A real Snowflake track: warehouse fundamentals, architecture, SQL, loading, ELT, governance, performance, cost, dbt, operations, and system design.

Self-paced September 2026

Kafka Interview and System Design Guide Azure Introduction

Beginners

Starts from what a warehouse is and why Snowflake exists.

Data engineers

Covers loading, MERGE, ELT, tasks, monitoring, and operations.

Analytics engineers

Covers marts, dbt, testing, governance, and cost.

Interview prep

Builds senior-level Snowflake explanation and design language.

Planned modules

Deep modules live now

Sections

99+

Concepts covered

Prerequisites

This is a full Snowflake track, not a single article. Every module has a live lesson: plain-English explanation, SQL examples, production mistakes, cost and security notes, and interview framing.

// Curriculum

20 Modules. Snowflake from First Query to Production Platform.

Follow in order. Each module starts from the beginner mental model and ends with production and interview readiness.

Section 1 — Snowflake Foundations

MODULE 01LIVE

What is Snowflake?

Snowflake explained from scratch: warehouse vs database, OLAP vs OLTP, and why companies use it.

WarehouseOLAPStorageComputeAnalytics

55 min

Beginner

Start →

MODULE 02LIVE

Snowflake Architecture

Storage, virtual warehouses, cloud services, micro-partitions, metadata, caching, and scaling.

StorageVirtual warehousesCloud servicesMicro-partitionsCache

65 min

Beginner

Start →

MODULE 03LIVE

Setup and SQL Basics

Create warehouses, databases, schemas, tables, roles, and run the SQL every beginner needs.

WarehouseDatabaseSchemaTableRoleSQL

70 min

Beginner

Start →

MODULE 04LIVE

Roles and Security Basics

RBAC, grants, ownership, least privilege, users, roles, future grants, and common access mistakes.

RBACGrantsOwnershipUsersFuture grants

60 min

Beginner

Start →

Section 2 — Loading and Transforming Data

MODULE 05LIVE

Loading Data with Stages and COPY INTO

Internal stages, external stages, file formats, COPY INTO, validation, rejected rows, and load history.

StagesFile formatsCOPY INTOLoad historyValidation

75 min

Intermediate

Start →

MODULE 06LIVE

Semi-Structured Data: VARIANT, JSON, FLATTEN

Load and query JSON, arrays, nested fields, VARIANT, OBJECT, ARRAY, and LATERAL FLATTEN.

VARIANTJSONFLATTENOBJECTARRAY

70 min

Intermediate

Start →

MODULE 07LIVE

ELT and Medallion Architecture in Snowflake

Raw, Silver, Gold, dimensional marts, dbt models, tests, and production-grade transformation patterns.

ELTRawSilverGolddbtMarts

80 min

Intermediate

Start →

MODULE 08LIVE

MERGE, Upserts, and Idempotent Pipelines

MERGE syntax, staging tables, deduplication, reruns, watermarks, and exactly-once-style pipeline design.

MERGEUpsertIdempotencyWatermarkDeduplication

75 min

Intermediate

Start →

Section 3 — Snowflake Platform Features

MODULE 09LIVE

Time Travel, Fail-safe, and Zero-Copy Cloning

Recover data, debug mistakes, clone environments, and understand retention and storage implications.

Time TravelFail-safeCloneRecoveryRetention

65 min

Intermediate

Start →

MODULE 10LIVE

Snowpipe and Continuous Loading

Snowpipe architecture, auto-ingest, cloud notifications, latency, errors, and when not to use it.

SnowpipeAuto-ingestNotificationsLatencyErrors

70 min

Intermediate

Start →

MODULE 11LIVE

Streams and Tasks

Change tracking, scheduled SQL, task graphs, incremental ELT, serverless tasks, and production pitfalls.

StreamsTasksCDCTask graphIncremental

80 min

Advanced

Start →

MODULE 12LIVE

Dynamic Tables

Declarative incremental pipelines, target lag, refresh modes, comparison with streams/tasks and materialized views.

Dynamic tablesTarget lagRefreshIncremental

65 min

Advanced

Start →

Section 4 — Performance, Cost, and Governance

MODULE 13LIVE

Performance Tuning

Micro-partition pruning, clustering, search optimization, query profile, caching, and warehouse sizing.

PruningClusteringQuery profileCacheWarehouse sizing

85 min

Advanced

Start →

MODULE 14LIVE

Cost Optimization

Credits, warehouses, auto-suspend, query waste, resource monitors, chargeback, budgets, and query history.

CreditsAuto-suspendResource monitorsChargebackQuery history

75 min

Advanced

Start →

MODULE 15LIVE

Advanced Security and Governance

Masking policies, row access policies, object tagging, classification, access history, and auditing.

MaskingRow accessTagsClassificationAudit

80 min

Advanced

Start →

MODULE 16LIVE

Data Sharing and Marketplace

Secure data sharing, reader accounts, listings, clean rooms, and cross-organization governance.

Data sharingMarketplaceReader accountsClean rooms

60 min

Advanced

Start →

Section 5 — Production and Career Readiness

MODULE 17LIVE

Snowflake with dbt

dbt project structure, sources, models, tests, snapshots, incremental models, environments, and CI/CD.

dbtModelsTestsSnapshotsCI/CD

85 min

Advanced

Start →

MODULE 18LIVE

Production Operations and Monitoring

Account usage views, load/query/task history, alerts, incident response, runbooks, and SLAs.

MonitoringAccount usageAlertsRunbooksSLA

75 min

Advanced

Start →

MODULE 19LIVE

End-to-End Snowflake Project

Build a full orders analytics platform: ingest, clean, merge, test, model, secure, optimize, and monitor.

ProjectOrdersPipelineMartsMonitoring

120 min

Advanced

Start →

MODULE 20LIVE

Snowflake Interview and System Design

Interview answers, architecture tradeoffs, cost scenarios, incident debugging, and senior-level design prompts.

InterviewSystem designTradeoffsIncidents

90 min

Advanced

Start →

Kafka Interview and System Design Guide

Apache Kafka

Azure Introduction

Azure Track

Discussion

Have a better approach? Found something outdated? Share it — your knowledge helps everyone learning here.

Continue with GitHub