Programme 6 of 14 · Warehouses & lakehouses

Snowflake - Data Cloud Mastery

1,090 words5 min read

Master the Snowflake Data Cloud from fundamentals to expert: architecture, data engineering, modeling, security, and the multi-cloud integration that makes Snowflake a backbone of the modern data stack.

SnowflakeSnowpipeSnowparkStreams & TasksSQL
Snowflake - Data Cloud Mastery: the syllabus at a glance1Snowflakearchitecture2Dataengineering onSnowflake3Modeling andperformance4Security andintegrationProject
Curriculum · 20 chapters in 4 modules

The full syllabus

Four modules of five chapters each, sequenced so the material builds cumulatively. The brochure carries a note on what each chapter teaches.

M1 Snowflake architecture Ch 1-5 · 5 chapters
  1. The multi-cluster shared-data architecture
  2. Virtual warehouses and compute
  3. Storage and micro-partitions
  4. Databases, schemas, and objects
  5. The Snowflake pricing and scaling model
M2 Data engineering on Snowflake Ch 6-10 · 5 chapters
  1. Loading and unloading data
  2. Streams and tasks for pipelines
  3. Snowpipe and continuous ingestion
  4. Transformations and dynamic tables
  5. Semi-structured data and VARIANT
M3 Modeling and performance Ch 11-15 · 5 chapters
  1. Data modeling in Snowflake
  2. Clustering and performance tuning
  3. Query optimization
  4. Managing cost and compute
  5. Time Travel and cloning
M4 Security and integration Ch 16-20 · 5 chapters
  1. Roles, access, and governance
  2. Data sharing and the marketplace
  3. Integration with AWS, Azure, and GCP
  4. Snowpark for data programming
  5. The Snowflake platform capstone
Where Snowflake - Data Cloud Mastery can leadThis programmeopens roles inData Engineer (Snowflake)Analytics EngineerData Platform EngineerData / Cloud Architecttoward Principal Cloud & Data Platforms
FAQ

Frequently asked questions

What is the Snowflake - Data Cloud Mastery programme?

Master the Snowflake Data Cloud from fundamentals to expert: architecture, data engineering, modeling, security, and the multi-cloud integration that makes Snowflake a backbone of the modern data stack.

Who is this programme for?

It suits data engineers building on Snowflake, along with others described on this page.

How is it delivered?

Self-paced with hands-on labs and projects, from architecture to a Snowflake capstone.

Is there a project or capstone?

Build a production Snowflake data platform: continuous ingestion with Snowpipe, transformation pipelines with streams and tasks, a well-modeled and clustered analytics layer, governed with roles, and integrated with a cloud object store, tuned for cost and performance.

How does this fit the wider journey?

Snowflake opens the warehouses-and-lakehouses stage. It sits at the center of many modern data stacks and integrates across all three clouds, so it complements the cloud-platform programmes and is a pillar of the senior data-platform skill set.

Can my organization run this as a private cohort?

Yes. Every programme can be delivered as a tailored corporate cohort. Contact us to scope it.

How it is delivered

Three ways to take Snowflake Data Cloud Mastery

Self-paced is a document-and-media programme with lifetime access - no live sessions. Cohort and enterprise add live instructor-led training. Mentorship is not offered in any tier.
Feature Self-paced Cohort Enterprise
Format Written chapters, video explainers and podcasts Everything in self-paced, plus scheduled live sessions Everything in cohort, delivered privately to your team
Live sessions None Scheduled, instructor-led Scheduled, instructor-led, private
Mentorship Not offered Not offered Not offered
Access Lifetime Lifetime Lifetime for every enrolled seat
Pace Entirely your own Guided schedule with a peer group Agreed with your desk
Tailoring Fixed curriculum Fixed curriculum Sequenced to your markets, systems and governance
Best for Individuals learning around a job Individuals who want structure and deadlines Desks building the same capability together
For individuals

Get the programme guide

The full chapter list, what each module covers, and how the tiers compare - sent to your inbox as a PDF.

For teams

Run this for my desk

Private delivery for your desk, sequenced to your markets and systems. Tell us the team and we will scope it.

Run this for my desk