Snowflake Fundamentals 4-Day (Multi-Week)

INTRODUCING SNOWFLAKE TRAINING FUNDS ➤  Learn more HERE. To purchase, contact us.  COVID-19 UPDATES ➤   Instructor-led classes will be delivered via virtual classroom only.

Snowflake Fundamentals 4-Day (Multi-Week)

Snowflake Fundamentals 4-Day (Multi-Week)


In this multi-week course, students will learn the fundamental concepts, design considerations, and best practices intended for key stakeholders who will be working on the Snowflake Cloud Data Platform. The course will consist of lecture, demos, labs and office hours with the instructor to cover a wide range of foundational topics.


4 Days


By the end of this class, you will be able to:

  • Illustrate the unique and differentiated architecture of the Snowflake Cloud Data Platform
  • Load and transform data
  • Evaluate Query Constructs and DDL & DML Operations
  • Review Snowflakes broad SQL support for data analysis
  • Describe how user and application access can be easily managed
  • Demonstrate best practices for working with semi-structured data
  • Discuss how Snowflake provides a unique approach to caching Examine the various ways to connect and interact with the Snowflake Platform
  • Employ Snowflake's method for continuous data protection
  • Utilize Data Sharing to send your data in real-time to Customers and Partners
  • Scale your Virtual Warehouse for performance and concurrency
  • Explain the different ways you can manage and monitor your Snowflake account


Who should attend:

  • Data Analysts
  • Data Engineers
  • Data Scientists
  • Database Architects
  • Database Administrators

The "Multi-Week" Fundamentals course is intended for students that cannot attend training over back-to-back days. This class covers the standard Fundamentals content delivered virtually by a live instructor 1 x day/week (typically on Mondays). Each class day will include lecture in the morning from 9:00am-12:30pm followed by "office hours" to cover the hands-on labs and Q&A from 1:30pm-4:30pm.


Previous Data Warehouse knowledge is assumed.

Setup Requirements

Fundamentals 4-Day Training students need...

  • to bring a laptop
  • a Snowflake compatible browser (see options HERE)

Additional Notes

  • This offering is delivered virtually by a live instructor over Zoom web conferencing.
  • Class sessions are scheduled over multiple, consecutive weeks (1 x day per week). Be sure to check the session days and times on the event page and/or your enrollment confirmation email.
  • Cancellations, transfers and reschedules for these events will follow our standard terms and conditions.
  • Course materials will be accessible on the first day of class and remain available for 90 days.
  • Lab access will be available for 30 days from the first day of class.
  • Missed class sessions cannot be made up in a later event. Students can contact their instructor via email to discuss missed topics and/or utilize the afternoon office hours to ask questions.


Week 1:

Snowflake Architecture and Overview

  • Snowflake Technical Overview 

  • Cloud Services Layer

  • Storage Layer

  • Compute Layer


Snowflake Clients & Ecosystem

  • Snowflake Clients and Connectors Overview

  • SnowSQL – Snowflake CLI



  • Caching Features in Snowflake

  • Best Practices of using caching for performance and cost optimization


Week 2:

Snowflake Objects & Commands

  • Data Description Language (DDL) 

  • Data Manipulation Language (DML)

  • Querying and Filtering

  • Collations

  • Subqueries

  • The Query Profile


Data Movement

  • Data Loading

  • Unloading

  • Best Practices


Streams & Tasks


Week 3:

Snowflake SQL Support for Data Analysis

  • SQL Support and Query Best Practices 

  • SQL Analytic Functions

  • High Performing Estimation Functions

  • UDF and Stored Procedure

  • Demo Query Profile

Managing Security

  • Access

  • Authentication

  • Authorization

  • Data Protection and Encryption


Access Control and User Management

  • System Roles

  • Custom Roles and Inheritance

  • Ownership

  • Configure and Manage Access


Semi-Structured Data

  • Query Semi-Structured Data

  • Load and Unload Semi-Structured data


Week 4:

Continuous Data Protection

  • Cloning

  • Time Travel

  • Database Replication and Failover

Data Sharing

  • Data Providers

  • Data Consumers

  • Reader Accounts

  • The Data Marketplace


Performance & Concurrency

  • Data Clustering

  • Scaling a Virtual Warehouse

  • SQL Performance Tips


Account and resource management & monitoring

  • System Resource Usage and Billing

  • Managing Virtual Warehouses

  • Workload independence and segmentation

  • Monitoring Tools: Resource Monitors

  • Monitoring Tools:  Information Schema and Account Usage


View and download the Fundamentals 4-Day Course Datasheet.

Upcoming Classes


Instructor-led online training

Location Jan 2022 Feb 2022 Mar 2022 Apr 2022 May 2022 Jun 2022 Jul 2022 Aug 2022 Sep 2022 Oct 2022 Nov 2022 Dec 2022 Jan 2023
Virtual Classroom (AMER/CT) Mar 7 – Mar 28
Apr 4 – Apr 25
Virtual Classroom (EMEA/GMT) Mar 7 – Mar 28
Apr 4 – Apr 25

Already enrolled in an Instructor-Led class or paid On-Demand course? Log in to your Learner Dashboard.