Snowflake Mastery: Performance, Pipelines & Best Practices

Hands-on Snowflake training with 20 eBooks and proven strategies from 50+ high-performance data deployments

What you'll learn

Snowflake fundamentals: architecture, warehouses, storage & compute

How to build high performance, massively scalable data warehouse systems

Proven Best Practices used in production used by 50+ of the top Fortune 500 enterprises

Practical real-world techniques including Data Loading, Performance Tuning, ETL pipeline design and Access Control

Hands-on experience using 20 guided exercises complete with outcomes and analysis

Reinforced learning from 20 exclusive eBooks complete with lessons learned and Snowflake Best Practices

Requirements

No prior Snowflake experience needed - We'll even include an introduction to Data Warehouses

Basic familiarity with SQL is helpful but not essential

Description

Boost your Snowflake career with expert insights gained as a Senior Solution Architect working for over 50 multi-million dollar Snowflake deployments across Fortune 500 companies.Starting with the fundamentals, this course builds your confidence through practical techniques and real-world examples. You’ll learn how to design, build, and optimize scalable, high-performance Snowflake systems—guided by proven best practices, not just textbook basics.What Makes This Course Different?Real-World Best PracticesLearn from actual enterprise deployments—not theory, not documentation. Discover how Snowflake is used at scale, with proven design patterns and practical strategies that work. Deep Snowflake Insights — Not Just “What”, But “Why”Go beyond the manuals. Understand how Snowflake works under the hood so you can architect and deploy high-performance systems with confidence.25 Hands-On ExercisesReinforce your learning with guided labs, step-by-step instructions, expected outcomes, and detailed solution walkthroughs.60+ Multiple-Choice QuestionsBoost retention and confidence with targeted quizzes, complete with answers and full explanations.400-Page Companion eBookEach major topic is covered in depth, featuring hand-drawn diagrams, best practices, and curated links to further learning.My Money-Back GuaranteeHaving designed, built, and delivered Snowflake training globally, I’m confident you’ll find this course both practical and transformative. If you're not satisfied, I’ll refund you—no questions asked.

Overview

Section 1: Introduction to this course

Lecture 1 Introducing this course

Lecture 2 The eBook - Snowflake Best Practices

Section 2: Introduction to Data Warehousing Techniques

Lecture 3 Introduction to Data Warehousing

Section 3: Setting things up

Lecture 4 Set up Snowflake Trial Account

Lecture 5 Hands on Lab - Set Up Snowflake Trial Account

Lecture 6 Demonstration - How to Install the Scripts and Data for the hands-on-lab

Lecture 7 10.2 - Hands on Lab - Install Lab Software and Data

Section 4: Snowflake Architecture

Lecture 8 Introducing Snowflake Architecture

Lecture 9 Q15.1 - Snowflake Architecture Quiz

Section 5: Snowflake User Interface

Lecture 10 Exploring Snowsight User Interface

Lecture 11 20.1 - Executing SQL Queries (Basic)

Section 6: Virtual Warehouses

Lecture 12 Introducing Virtual Warehouses

Lecture 13 30.1 - Lab: Introducing Virtual Warehouses

Lecture 14 Snowflake Compute & Costs

Lecture 15 30.2 - Lab: Snowflake Compute and Costs

Lecture 16 Snowpark Optimized Warehouses

Lecture 17 Q30.1 - Virtual Warehouse Quiz

Section 7: Virtual Warehouse Scaling

Lecture 18 Introducing Warehouse Scaling

Lecture 19 40.1 - Lab: Introducing Warehouse Scaling

Lecture 20 Benchmark Scaling Up

Lecture 21 Scale Out for Concurrency

Lecture 22 Architecture Summary - What we've covered so far

Lecture 23 Q40.1 - Architecture and Compute - Quiz

Section 8: System Overview

Lecture 24 Snowflake Data Cloud and Editions

Lecture 25 50.1 - Lab: Snowflake Editions

Lecture 26 Snowflake Object Hierarchy

Lecture 27 50.2 - Lab: Snowflake Object Hierarchy

Lecture 28 Quiz - Snowflake System Overview

Section 9: Data Storage and Time Travel

Lecture 29 Data Storage: Snowflake under the hood

Lecture 30 60.1 - Lab: Snowflake Micro-Partitions

Lecture 31 Data Retention and Versioning

Lecture 32 60.2 - Lab: Data Retention & Versioning

Lecture 33 Q60.1 - Storage, Retention and Processing - Quiz

Lecture 34 Snowflake Time Travel

Lecture 35 60.3 - Lab: Using Time Travel to Recover Data

Section 10: Zero Copy Clones

Lecture 36 Introducing Zero Copy Clones

Lecture 37 60.4 - Lab: Introducing Zero Copy Clones

Lecture 38 Clones and Time Travel

Lecture 39 60.5- Lab: Clones and Time Travel

Lecture 40 Active, Time Travel & Failsafe Data

Lecture 41 60.6 - Lab: Active, Time Travel & Fail-Safe Data

Lecture 42 Q60.7 - Clones, Time Travel and Fail-Safe - Quiz

Section 11: Tables, Views and SQL

Lecture 43 Transactional Vs. Analytic Workloads

Lecture 44 L701. - Hands-on Lab: Tables, Views & SQL

Lecture 45 Tables, Views, SQL and Transaction Management

Lecture 46 Q70.1 - Quiz: Tables, Views and SQL

Section 12: Batch Data Loading

Lecture 47 Introducing Data Loading

Lecture 48 80.1 - Lab: Introducing Data Loading

Lecture 49 Stage and File Management

Lecture 50 Snowflake COPY: Loading & Unloading Data

Lecture 51 85.1 - Lab: Loading and Unloading

Lecture 52 Handling Load Errors & Validation

Lecture 53 85.2 - Lab: Handling Load Errors & Validation

Lecture 54 Batch Data Loading - Best Practices

Lecture 55 85.3 - Lab: Batch Data Loading Best Practices

Lecture 56 Q85.4 - Data Loading Best Practices - Quiz

Section 13: Continuous Data Loading

Lecture 57 Introducing Continuous Data Loading

Lecture 58 Snowpipe Data Loading - Best Practices

Lecture 59 Q80.5 - Quiz: Snowpipe

Section 14: ETL Pipeline Development

Lecture 60 Introducing Streams & Tasks

Lecture 61 # 90.1 - Lab: Introducing Streams & Tasks

Lecture 62 Introducing Dynamic Tables

Lecture 63 Q90.1 - Quiz: Streams, Tasks and Dynamic Tables

Section 15: Snowflake Performance & Tuning

Lecture 64 Performance: Caching

Lecture 65 100.1 - Lab: Performance Caching

Lecture 66 Using Snowflake Explain Plan

Lecture 67 100. 2 - Lab: Explain Plan

Lecture 68 How to read the Snowflake Query Profile

Lecture 69 Introduction to Snowflake SQL Performance Tuning

Lecture 70 100.2 - Lab: SQL Performance Tuning

Section 16: Role Based Access Control

Lecture 71 Introducing Role Based Access Control (RBAC)

Lecture 72 L110.1 - Hands-on Lab: Introducing Role Based Access

Beginners with little or no Snowflake experience,Aspiring and practicing data engineers who want to take their understanding to the next level,Data analysts, architects, and IT professionals moving to cloud data platforms,Teams looking to implement Snowflake following best practices,People who care about both "Getting it Done" while also "Doing it the Right Way".