> Wandering …
Launch · May 11, 2026
COF-C02 · 50 days · 8 weeks
The Curriculum

50 days.
5 domains.
One pass on COF-C02.

A structured daily series taking you from Snowflake basics to exam-ready. Built by a working data engineer, not a course factory. Every concept day ships a topic breakdown, a hands-on lab, an exam-tip cheat sheet, and 5 practice questions mapped to the official exam guide.

01 / What lands in your inbox

Every concept day follows the same structure. No fluff, no filler — just the parts that move the needle on exam day.

01

Concept, explained

The day’s topic broken into 2–4 short sections with diagrams and runnable SQL. Built to read in one coffee.

02

Hands-on lab

Copy-paste SQL you can run on a free Snowflake trial. Every lab includes setup, demo, and cleanup.

03

Exam tip box

The “watch for this on the exam” callouts. Common traps, edge cases, and answer-pattern shortcuts.

04

5 practice questions

Single and multi-select, with explanations. Mapped to the same domain weighting as the real exam.

02 / The full 50-day map

Eight weeks. Five domains, mid-week reviews where the topics demand them, and a Weekly Practice Test at the end of every week to lock in what you just learned.

Concept + lab In-week review Weekly practice test Full mock exam
Week 01

Foundations & Architecture

Domain 1What Snowflake is, how it’s organized, and where it runs

  1. Day 01
    What is Snowflake? Cloud data platform overview
  2. Day 02
    Snowflake’s 3-layer architecture
  3. Day 03
    Editions & cloud platforms
  4. Day 04
    Interfaces: Snowsight, CLI & IDE
  5. Day 05
    Object hierarchy: Org → Account → DB → Schema
  6. Day 06
    Week 1 recap + practice questions

Weekly Practice Test — Week 1

Domain 1 fundamentals · Mixed single & multi-select

Test
Week 02

Compute, Storage & Tables

Domain 1Warehouses, partitions, and the table types you’ll be tested on

  1. Day 07
    Virtual warehouses deep dive
  2. Day 08
    Multi-cluster warehouses & scaling
  3. Day 09
    Warehouse best practices & use cases
  4. Day 10
    Micro-partitions & data clustering
  5. Day 11
    Table types: Permanent, Transient, Temp, External, Dynamic, Iceberg
  6. Day 12
    View types: Standard, Materialized, Secure

Weekly Practice Test — Week 2

Compute & storage · Mixed single & multi-select

Test
Week 03

AI/ML Features → Access Control

Domain 1 → 2Closing out architecture and entering account management

  1. Day 13
    AI/ML features: Snowpark, Notebooks, Streamlit
  2. Day 14
    Snowflake Cortex & ML features
  3. Day 15
    Domain 1 comprehensive review
  4. Day 16
    RBAC & access control fundamentals
  5. Day 17
    System-defined roles & custom roles
  6. Day 18
    Authentication: MFA, SSO, OAuth, key-pair

Weekly Practice Test — Week 3

Domain 1 wrap-up & access control · Mixed

Test
Week 04

Governance, Security & Stages

Domain 2 → 3Wrapping up account management, opening up data loading

  1. Day 19
    Network policies & security features
  2. Day 20
    Data governance: masking, tagging, privacy
  3. Day 21
    Encryption, replication & failover
  4. Day 22
    Resource monitors & cost management
  5. Day 23
    Domain 2 review + practice questions
  6. Day 24
    Stages: internal vs external

Weekly Practice Test — Week 4

Governance & security · Mixed single & multi-select

Test
Week 05

Loading, Pipes, Streams & Tasks

Domain 3Getting data in and keeping it moving

  1. Day 25
    File formats & COPY INTO (loading)
  2. Day 26
    Data unloading: COPY INTO <location>
  3. Day 27
    Snowpipe & Snowpipe Streaming
  4. Day 28
    Streams & Tasks: change data capture
  5. Day 29
    Dynamic tables & connectors
  6. Day 30
    Domain 3 review + practice questions

Weekly Practice Test — Week 5

Data loading & movement · Mixed single & multi-select

Test
Week 06

Performance & Querying

Domain 4Reading profiles, tuning, and query acceleration

  1. Day 31
    Query profile & performance tuning
  2. Day 32
    ACCOUNT_USAGE views & query history
  3. Day 33
    Caching: result, metadata, warehouse
  4. Day 34
    Query acceleration & search optimization
  5. Day 35
    Clustering keys & materialized views for performance
  6. Day 36
    Workload management best practices

Weekly Practice Test — Week 6

Performance & tuning · Mixed single & multi-select

Test
Week 07

Querying → Collaboration

Domain 4 → 5Finishing performance, opening up sharing & cloning

  1. Day 37
    Semi-structured & unstructured data
  2. Day 38
    SQL functions: aggregates, windows & optimization
  3. Day 39
    Domain 4 review + practice questions
  4. Day 40
    Time Travel & Fail-safe
  5. Day 41
    Zero-copy cloning
  6. Day 42
    Secure data sharing

Weekly Practice Test — Week 7

Performance & collaboration · Mixed single & multi-select

Test
Week 08

Final Stretch — Review & Mock Exams

All domainsMarketplace, full-domain review, two mock exams, and exam-day prep

  1. Day 43
    Marketplace, listings & native apps
  2. Day 44
    Domain 5 review + practice questions
  3. Day 45
    Full review: Domains 1 & 2
  4. Day 46
    Full review: Domains 3, 4 & 5
  5. Day 47
    Mock Exam #1 (full length)
  6. Day 48
    Mock Exam #1 review & gap analysis
  7. Day 49
    Mock Exam #2 + final weak-area drill
  8. Day 50
    Exam day prep & final tips

Why this isn’t another course dump

Most SnowPro material is either a 12-hour video you’ll never finish or a thousand-question dump with no context. This series is a daily habit designed for working engineers studying in 30-minute windows.

You won’t memorize trivia. You’ll understand why Snowflake makes the choices it does — which is exactly how the exam tests you.

  • Domain-weighted, not topic-dumped Each week mirrors the COF-C02 exam guide weighting so you spend more time where the points are.
  • Live-verified against Snowflake docs Every limit, default, and edition note is checked against current Snowflake documentation — not pulled from outdated training data.
  • Built by a practitioner Written by a working data engineer, not a content team. Exam-tip patterns come from actual gotchas, not generic flashcards.
  • Real labs, not pseudo-code Every concept day’s SQL runs end-to-end on a free Snowflake trial. Setup → demo → cleanup, no residue.

Copyright © 2026 Teachix