Snowflake SnowPro Core Training

Live Online & Classroom Enterprise Training

Validates expertise in Snowflake’s cloud data platform, including architecture, data sharing, and performance optimization. Prepares learners to manage secure, scalable data warehouses in multi-cloud environments.

Looking for a private batch ?

REQUEST A CALLBACK

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Snowflake SnowPro Core Course about?

The SnowPro Core Certification validates foundational knowledge of the Snowflake platform, covering core features such as architecture, data management, security, performance optimization, and business use cases. This course provides a comprehensive learning experience for professionals aiming to build, manage, and optimize data solutions on Snowflake. With practical labs, exercises, and exam-focused guidance, learners will gain the confidence to implement Snowflake in real-world environments and successfully pass the SnowPro Core exam.

What are the objectives of Snowflake SnowPro Core Course ?

Understand Snowflake’s architecture and cloud-native features.
Load, transform, and query structured and semi-structured data.
Apply best practices for data storage, performance, and optimization.
Implement access control, security, and data sharing within Snowflake.
Prepare effectively for the SnowPro Core certification exam.

Who is Snowflake SnowPro Core Course for?

Data Engineers and Database Administrators.
Data Analysts and BI Developers.
Data Architects designing scalable data warehouses.
Cloud professionals adopting Snowflake solutions.
Professionals preparing for the SnowPro Core certification.

What are the prerequisites for Snowflake SnowPro Core Course?

Prerequisites:

Basic knowledge of SQL and relational databases.
Familiarity with data warehousing concepts.
Understanding of cloud computing fundamentals.
Exposure to ETL/ELT and BI tools (preferred).
Motivation to pursue Snowflake certification.

Learning Path:

Introduction to Snowflake and Its Cloud Architecture
Data Loading, Storage, and Transformation in Snowflake
Query Processing, Performance, and Optimization
Security, Access Control, and Data Sharing Features
Exam Preparation: Practice Questions and Case Studies

Related Courses:

Introduction to Data Warehousing
Apache Spark Fundamentals
Data Engineering on Google Cloud Platform
Snowflake Advanced: Data Engineer Track

Available Training Modes

Live Online Training

2 Days

Course Outline Expand All

Expand All

Module 1- Introduction

Course Structure

Making the Most of This Course

Module 2- Snowflake Features & Architecture

Snowflake Features & Architecture Introduction

What is Snowflake?

Multi-cluster Shared Data Architecture

Storage Layer Overview

Query Processing Layer Overview

Services Layer Overview

Snowflake Editions

Snowflake Object Model

Organizations, Accounts, Databases & Schemas

Table & View Types

Databases, Schemas, Tables & Views

User Defined Functions (UDFs)

Stored Procedures

UDFs, External Functions & Stored Procedures

Sequences

Tasks & Streams

Module 3- Account Access & Security

Account Access & Security Introduction

Access Control Overview

Roles

Privileges

User Authentication

Multi-factor Authentication (MFA)

Federated Authentication

Key Pair Authentication, OAuth & SCIM

Network Policies

Data Encryption

Column Level Security

Row Level Security

Secure Views

Module 4- Performance Concepts: Virtual Warehouses

Performance Concepts: Virtual Warehouses Introduction

Virtual Warehouse Overview

Virtual Warehouse State & Properties

Virtual Warehouse Sizing and Billing

Resource Monitors

Multi-cluster Warehouses

Query Acceleration Service (QAS)

Module 5- Performance Concepts: Query Optimisation

SQL Tuning

Caching

Materialized Views

Clustering

Automatic Clustering

Search Optimization Service

Module 6- Data Loading & Unloading

Data Loading and Unloading Introduction

Stages

Bulk Loading - COPY INTO TABLE command

File Formats

Snowpipe

Data Unloading

Semi-structured Overview

Loading and Unloading Semi-structured Data

Accessing Semi-structured Data

Semi-structured Functions

Module 7- Data Transformations

Data Transformations Introduction

Summary of Snowflake Functions

Estimation Functions

Table Sampling

Unstructured File Functions

Directory Tables

File Support REST API

Module 8- Storage, Data Protection & Data Sharing

Storage, Data Protection & Data Sharing Introduction

Storage Layer Overview

Micro-partitions

Time Travel & Fail-Safe

Cloning

Replication

Storage Billing

Secure Data Sharing

Who is the instructor for this training?

The trainer for this Snowflake SnowPro Core Training has extensive experience in this domain, including years of experience training & mentoring professionals.

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree