Snowflake Fundamentals 4-Day


*Looking for flexible schedule (after hours or weekend)? Please call or email us: 858-208-4141 or

Student financing options are available.

Transitioning military and Veterans, please contact us to sign up for a free consultation on training and hiring options.

Looking for group training? Contact Us

Download PDF of Course Details

Course Description:

This 4-day course covers 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 lectures, demos, and labs on a wide range of foundational topics.





Course Outline

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

Course Objectives

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

Target Audience

Who should attend:

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


Previous Data Warehouse knowledge is assumed.


With CCS Learning Academy, you’ll receive:

  • Instructor-led training
  • Training Seminar Student Handbook
  • Collaboration with classmates (not currently available for self-paced course)
  • Real-world learning activities and scenarios
  • Exam scheduling support*
  • Enjoy job placement assistance for the first 12 months after course completion.
  • This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
  • Government and Private pricing available.*

*For more details call: 858-208-4141 or email:;


Shopping Cart