Gold - Mastering Snowflake: Fundamentals, Insights and Best Practices

Return to Dashboard

Course curriculum

1. Course Overview
2. Mastering Snowflake: Fundamentals, Insights & Best Practices
1. Introduction to Data Warehousing Principles
1. Demo: Set up Snowflake Trial Account
2. Hands on Lab: Set up Snowflake Trial Account
3. Demonstration: Installing the Hands-on-Lab
4. Hands on Lab: Install Lab Software and Data
5. Hands-on Lab: Set up Snowflake Trial Account
1. Introducing Snowflake Architecture
  FREE PREVIEW
2. Q15.1 - Architecture Quiz
3. eBook: Snowflake System Architecture
  FREE PREVIEW
4. Course Feedback
1. Exploring the Snowflake User Interface - Explorer
2. L20.1 - Hands on Lab: Executing SQL Statements
3. L20.2 - Hands on Lab: Navigate the Snowflake User Interface (Advanced)
1. Introducing Virtual Warehouses
2. L30.1 - Hands-on lab - Virtual Warehouses
3. Snowflake Compute and Costs
4. L30.2 - Hands-on lab: Compute Resources
5. Snowpark Optimized Warehouses
6. Q30.1 - Virtual Warehouse Quiz
7. Q30.2 - Compute & Costs Quiz
8. Course Feedback
1. Warehouse Scaling
2. L40.1 - Hands-on Lab: Warehouse Scaling
3. Benchmark Scale Up
4. Scale Out for Concurrency
5. Architecture and Virtual Warehouse Summary
6. Q40.1 - Architecture and Compute - Quiz
1. Snowflake Data Cloud & Editions
2. Q50.1 - Short Quiz - Snowgrid and the Snowflake Cloud
3. L50.1 - Hands-On Lab: Snowflake Editions
4. Q50.2 - Short Quiz - Snowflake Editions
5. Snowflake Object Hierarchy
6. L50.2 - Hands-On Lab: Snowflake Object Hierarchy
7. Q50.3 - Short Quiz - Snowflake Objects
1. Data Storage: Snowflake under the hood
2. L60.1 - Hands-on lab - Snowflake Micro-Partitions
3. Data Retention and Versioning
  FREE PREVIEW
4. L60.2 - Hands-on lab - Data Retention & Versioning
  FREE PREVIEW
5. Time Travel
6. L60.3 - Hands-On Lab: Using Time Travel
7. Q60.1 - Quiz: Data Storage
8. Q60.2 - Quiz: Data Retention & Versioning
  FREE PREVIEW
9. Course Feedback
1. Introducing Zero Copy Clones
2. L60.4 - Hands-on lab - Introducing Zero Copy Clones
3. Clones & Time Travel
4. L60.5 - Hands-on Lab: Clones & Time Travel
5. Active, Time Travel & Failsafe Data
6. L60.6 - Hands-on lab - Active, Time Travel & Fail-Safe Data
7. Q60. 3 - Quiz: Introducing Zero Copy Clones
8. Q60.4 - Quiz: Clones and Time Travel
9. Q60.5 - Quiz: Active, Time Travel and Failsafe Data
1. Transactional Vs. Analytic Workloads
2. L701. - Hands-on Lab: Tables, Views & SQL
3. Tables, Views & SQL
4. Q70.1 - Quiz: Tables, Views and SQL
1. Introducing Data Loading
2. L80.1 - Hands-on Lab: Introducing Data Loading
3. Stage and File Management
4. Snowflake COPY: Loading & Unloading Data
5. L80.2 - Hands-on Lab: Loading and Unloading
6. Handling Load Errors & Validation
7. L80.3 - Hands-on Lab: Handling Load Errors & Validation
8. Batch Data Loading - Best Practices
9. L80.4 - Hands-on Lab: Batch Data Loading - Best Practices
10. Q80.1 - Quiz: Data Loading Best Practices (Advanced Questions)
11. Q80.2 - Quiz: Staging Data in Snowflake
12. Q80.3 - Quiz: File Management, Loading and Unloading
13. Q80.4 - Quiz: Handling Load Errors and Validation
14. eBook: Introducing Snowflake Data Loading
15. eBook: Stage & File Management
16. eBook: Snowflake Copy (Loading & Unloading Data)
17. eBook: Handling Load Errors and Validation
18. eBook: Batch Data Loading Best Practices
1. Continuous Data Loading
2. Snowpipe Data Loading - Best Practices
3. Q80.5 - Quiz: Snowpipe
1. Introducing Streams & Tasks
2. L90.1 - Hands-on Lab: Introducing Streams & Tasks
3. Introducing Dynamic Tables
4. Hands-on Lab: Dynamic Tables
5. Q90.1 - Short Quiz - Dynamic Tables
6. Q90.2 - Quiz: Introducing Streams & Tasks
1. Performance: Caching
2. 100.1 - Hands-on Lab: Performance - Caching
3. Explain Plan
4. L100.2 - Hands-on Lab: Explain Plan
5. Snowflake Query Profile
6. Introducing SQL Performance Tuning
7. L100.3 - Hands-on Lab: SQL Performance Tuning
1. Introducing Role Based Access Control
2. L110.1 - Hands-on Lab: Introducing Role Based Access
3. Course Feedback
1. Mastering Snowflake: Fundamentals, Insights & Best Practices
2. Course Feedback

Course Includes:

97 lessons
19 eBooks
20 Hands-on Exercises
13 Sets of Quiz Questions

Gold - Mastering Snowflake: Fundamentals, Insights and Best Practices

Course curriculum

Course Overview

Introduction to Data Warehousing

Setting things up

15 - Snowflake Architecture

20 - Explore the Snowsight User Interface

30 - Virtual Warehouses

40 - Virtual Warehouse Scaling

50 - System Overview

60 - Data Storage and Time Travel

60 - Zero Copy Clones

70 - Tables, Views & SQL

80 - Batch Data Loading

80 - Continuous Data Loading

90 - ETL Pipeline Development

100 - Snowflake Performance

110 - Role Based Access Control

Snowflake eBooks

Course Includes: