
After completing this module you'll understand:
The difference between OLTP (transactional) and OLAP (data warehouse) processing
The difference between workloads executed on OLTP and Data Warehousing systems
The basics of ETL - Extract Transform and Load processing
Types of data Snowflake can process (Structured, Semi-Structured and Unstructured)
What is a Data Lake and how it works with Snowflake
Once complete you'll have a Snowflake account where you can load data, execute queries and learn practice your skills. You'll have 30 days with $400 of free credits - enough to complete the exercises about ten times over.
Best of all, if you want to continue your learning, you can create a second account after the 30 days runs out and practice what you've learned.
This lesson will enable you to set up a secondary security method (MFA) in addition to your username and password.
Explore snowpark optimized warehouses, offering 16x memory over standard warehouses for snowpark, spark, and python workloads, including machine learning training; use standard warehouses for ETL and monitor costs before adopting.
Expand warehouse size to double throughput and cut execution time, from four hours on small to about one minute on six x large, while hourly costs rise.
Snowflake scales out for concurrency with multi-cluster warehouses, automatically adding or suspending clusters between min and max counts on enterprise edition, as shown in Deliveroo auto scale out example.
Understand Snowflake's three-tier architecture—cloud services, virtual warehouses, and storage—and how multi-cluster scale-out balances end-user and batch workloads with scalable warehouses and auto suspend.
Master Snowflake's object hierarchy from organization to regions, accounts, databases, and schemas, and learn how unique account and schema level objects like tables, views, and a virtual warehouse are managed.
Explore Snowflake data retention and versioning to recover from mistakes, with time travel up to 90 days (standard edition 1 day) and DDL changes retained.
Most Snowflake courses teach features.
This Snowflake course teaches you how Snowflake actually works.
Whether you’re new to Snowflake or already using Snowflake SQL, you’ll learn how to design, scale and optimise Snowflake properly — avoiding the performance and cost mistakes that catch most data engineers out.
We start with Snowflake fundamentals and build toward architecture, virtual warehouse scaling, performance tuning and cost optimisation — the skills required to design production-ready Snowflake systems with confidence.
What You’ll Learn in This Snowflake Course
Snowflake fundamentals for beginners
Snowflake architecture and design principles
How Snowflake virtual warehouses scale (and why you shouldn't)
Snowflake performance tuning techniques
Snowflake cost optimisation strategies
Writing efficient Snowflake SQL
Production-ready Snowflake best practices
Foundations useful for SnowPro certification
4.5 Hours of Focused Video — By Design
The video content is intentionally concise. That means:
No 12-hour slide marathons.
No obscure features you’ll never use
Just the architecture, performance, and cost principles that matter in production.
Because performance and cost discipline aren’t learned by watching slides. They’re learned by doing.
This course includes extensive hands-on labs where you will:
Analyse real query profiles
Tune warehouse usage
Test architectural decisions
Apply performance and cost best practices immediately
Who This Snowflake Training Is For
Data engineers learning Snowflake
Analysts transitioning from traditional data warehouses
Developers building data pipelines in Snowflake
Professionals preparing for SnowPro certification
Anyone looking for a practical Snowflake tutorial beyond the basics
No prior Snowflake experience is required. We start from fundamentals and progressively build toward advanced Snowflake design and performance optimisation.
Why This Snowflake Course Is Different
Unlike many Snowflake tutorials that focus only on features, this course focuses on architecture, performance, and cost control in real production environments.
Built from five years working inside Snowflake UK and delivering training to 100+ organisations, this course reflects what actually causes performance issues, cost overruns, and architectural mistakes in the real world — not just what the documentation says.
Hands-On Snowflake Training
25 practical Snowflake exercises with guided solutions
Step-by-step labs with clear expected outcomes
60+ targeted review questions to reinforce learning
Included 200-Page Snowflake Architecture & Design Handbook
You also get full access to a structured online Snowflake handbook covering every major topic in depth.
This is not a copy of the slides.
It’s a detailed revision and reference guide with diagrams, architecture explanations, and production best practices — designed to support long-term understanding, not just course completion.