Snowflake Fundamentals 4-Day (Multi-Week)

NEW ADVANCED CERTIFICATION AVAILABLE ➤  Learn more about the SnowPro Advanced: Architect exam.   NEW PERFORMANCE AUTOMATION & TUNING COURSE ➤  Learn more and sign up for the first public instructor-led class!   COMPLETE YOUR SNOWPRO CORE CERT. PREP WITH OUR ON-DEMAND PREPARATION COURSE➤   Learn more!   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)
  • permissions to install software on your computer (**Students will install SnowSQL IN CLASS with the instructor.)

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 Oct 2020 Nov 2020 Dec 2020 Jan 2021 Feb 2021 Mar 2021 Apr 2021 May 2021 Jun 2021 Jul 2021 Aug 2021 Sep 2021 Oct 2021
Virtual Classroom (EMEA/GMT) Nov 2 – Nov 23
Jan 4 – Jan 25
Virtual Classroom (AMER/CT) Nov 2 – Nov 23
Jan 4 – Jan 25

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