Overview

This four-day course covers the core concepts, design considerations, and Snowflake recommended best practices intended for critical stakeholders who will be working on the Snowflake AI Data Cloud. The course consists of lectures, demos, and labs covering a wide range of essential topics.

Skills Covered

  • Outline the unique and differentiated architecture of the Snowflake AI Data Cloud.
  • Load and transform data.
  • Summarize query constructs, DDL, and DML operations.
  • Use Snowflake’s extensive SQL capabilities for data analysis.
  • Describe how user and application access can be easily managed.
  • Apply Snowflake’s recommended best practices for working with semi-structured data.
  • Discuss Snowflake’s unique approach to caching.
  • Implement the options provided to connect and interact with the Snowflake AI Data Cloud.
  • Employ Snowflake’s continuous data protection features.
  • Utilize data sharing to send your data in real-time to Customers and Partners.
  • Scale your Virtual Warehouses to improve performance and address concurrency needs.
  • Explain the different ways you can manage and monitor your Snowflake account.
  • Summarize Snowflake’s AI and ML capabilities.

Prerequisites

  • Recommended completion of the “Snowflake Multi-Factor Authentication (MFA) Essentials” free on-demand course.
  • Previous Data Warehouse knowledge is assumed

Target Audience

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

Course Curriculum

Module 1: Overview and Architecture

  • Overview
  • Snowflake Structure
  • Using Snowsight
  • Storage Layer
  • Compute Layer
  • Cloud Services Layer
  • Snowgrid
  • Generative AI

Module 2: Connecting to Snowflake

  • Connection Options
  • SnowSQL
  • Visualizations in Snowsight
  • Data Protection Features
  • Cloning
  • Time Travel
  • Fail-safe
  • Introduction to Replication

Module 3: SQL Support in Snowflake

  • Tables, Views, and Data Types
  • Transactions
  • Standard SQL and Snowflake
  • Collation
  • Multi-table Inserts
  • Query Tags
  • Working with Parameters

Module 4: Metadata and Caching in Snowflake

  • Overview
  • Metadata
  • Query Result Cache
  • Data Cache

Module 5: Query Performance

  • Using Explain
  • Query Profile
  • SQL Performance Tips

Module 6: Data Loading and Unloading

  • Data Loading Objects
  • Data Loading Process
  • Transformations and Copy Options
  • Data Loading Recommendations
  • Continuous Data Loading
  • Unloading Data

Module 7: Functions, Procedures, and Snowflake Scripting

  • User-defined Functions
  • Stored Procedures
  • Snowflake Scripting

Module 8: Using Tasks, Streams, and Dynamic Tables

  • Tasks Overview
  • Creating Tasks
  • Managing Tasks
  • Streams Overview
  • Dynamic Tables Overview

Module 9: Managing Security

  • Security Overview
  • Access
  • Authentication
  • Authorization
  • Data Protection
  • Trust Centre

Module 10: Access Control and User Management

  • Concepts
  • Types of Roles
  • Ownership
  • View Grants

Module 11: Semi-structured Data

  • Overview
  • Query Semi-structured Data

Module 12: Introduction to Data Sharing

  • Snowflake Data Sharing Overview
  • Shares

Module 13: Virtual Warehouse Scaling

  • Types of Virtual Warehouse Scaling
  • Auto-scaling Policies

Module 14: Cost Management

  • Overview
  • Visibility
  • Control
  • Optimization

Module 15: Introduction to Snowflake AI and ML

  • Overview of Cortex LLM Functions
  • Overview of Snowflake ML Functions

Dates & Locations

Let’s make it work for you

Can’t find a date that fits? Need to train your whole team? Looking for a discount?
Speak to one of our learning experts today.

x Clear all selections

July 28, 2026 - July 31, 2026

Location: Online
Modal: VILT
Availability: TBC
Exam:
RM 1688
RM 13500
Trainocate exam and cert

Exam & Certification

SnowPro® Core Certification (COF-C03)

The SnowPro® Core Certification will validate practical, hands-on experience with the Snowflake AI Data Cloud.

This certification will test the ability to:

  • Use the Snowflake AI Data Cloud architecture
  • Manage Snowflake accounts and virtual warehouses
  • Perform data loading, unloading, and transformation
  • Use structured, semi-structured, and unstructured data
  • Monitor and optimize performance
  • Enable data collaboration and protection
  • Establish Snowflake connectivity

Training & Certification Guide

  • Exam Version: COF-C03
  • Total Number of Questions: 100
  • Question Types: Multiple Select, Multiple Choice
  • Time Limit: 115 minutes
  • Languages: English, Japanese, Korean, French, Spanish
  • Registration fee: $175 USD
  • India Registration fee: $140 USD
  • Passing Score: 750 + Scaled Scoring from 0 – 1000
  • Unscored Content: Exams may include unscored items to gather statistical information for future use. These items are not identified on the form and do not impact your score, and additional time is factored into account for this content.
  • Prerequisites: No prerequisites

  • Snowflake AI Data Cloud Features & Architecture 31%
  • Account Management and Data Governance 20%
  • Data Loading, Unloading, and Connectivity 18%
  • Performance Optimization, Querying, and Transformation 21%
  • Data Collaboration 10%

Frequently Asked Questions

Speak to a Training Consultant

All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631

Preferred mode of training
Checkboxes