Snowflake Data Essentials & SnowPro Associate Certification Prep
Categories: Data Analytics
About Course
This comprehensive course is designed to help you master the fundamentals of Snowflake—the modern cloud data platform—while also preparing you to confidently pass the SnowPro® Core Certification (SnowPro® Associate: Platform) exam.
Whether you’re a beginner in cloud data warehousing or an experienced data professional looking to formalize your skills, this course will walk you through the core Snowflake concepts, best practices, and real-world use cases, followed by exam-focused training
What Will You Learn?
- Snowflake Architecture: Understand Snowflake’s unique multi-cluster, shared-data architecture
- Key Concepts: Warehouses, databases, schemas, stages, and data sharing
- Data Loading & Unloading: Learn how to work with internal and external stages
- Access Control: Role-based access, privileges, and security best practices
- Performance & Cost Optimization: Use caching, scaling, and resource monitoring effectively
- Backup & Recovery: Master Time Travel, Fail-safe, and Zero-Copy Cloning
- Data Sharing & Marketplace: Explore secure data collaboration in Snowflake
- Snowflake Ecosystem: Work with Partner Connect, integrations, and Snowpark
- Certification Readiness: Includes domain-wise breakdown, practice questions
Course Content
Getting Started
-
Snowflake Trial
Database Fundamentals
-
Creating a database, schemas and roles
08:24 -
Quiz 1
-
Authentication and access control
08:18 -
Quiz 2
-
DAC
05:27 -
Quiz 25
-
Privileges and other access concepts
-
Topic Privileges and other access concepts Quiz 24
-
Intro to Warehouse
03:53 -
Quiz 3
Introduction to Data concepts
-
Example Introduction
02:00 -
Quiz 4
-
Sheet and sample statements
01:50 -
Quiz 5
-
Dataset Creation Concept
07:08 -
Quiz 6
-
Designing and Creating Time Range Tables for Recipes Quiz 18
-
Dataset Creation Implementation
05:12 -
Quiz 9
-
Insert Data
-
Quiz 7
-
More on Worksheets
-
Quiz 10
-
More on Warehouse and other related concepts
03:22 -
Quiz 8
-
Best Practices and tips
07:10 -
Quiz 11
-
Time Travel and Fail-safe
-
Backup and Recovery
-
Wrap Up
-
Assignment: Snowflake Data Recovery & Continuity Scenario
-
Solution for assignment
-
Summary on Backup & Recovery Features
-
Snowflake Backup & Recovery – Quiz
Data Loading
-
Introduction and dataset
06:25 -
Notebooks and how to use them
05:20 -
Introduction to Streamlit
-
Quiz 12
-
Streamlit to insert data into our Main_Courses
09:41
Staging in Snowflake
-
Intro to stages
08:44 -
Quiz 13
-
Creating a Stage
07:14 -
Quiz 14
-
Specifics of a stage
04:57 -
COPY INTO Command in Snowflake Quiz 14
-
Create a Stage and Load data
03:32 -
Loading Data into Tables from Files Quiz 17
-
File formats Hands on
05:37 -
Creating Reference Tables for Recipes Quiz 16
-
Other Concepts Related To Stage
-
Stage Catchup Quiz
Data Architecture and Storage Essentials
-
Introduction to ERD Concepts
08:20 -
Quiz 19
-
Many-to-Many Relationships with Example
09:56 -
Quiz 20
-
Sequence and Inserting data with it
09:30 -
Quiz 21
-
Introduction to Semi-Structured Data in Snowflake
06:02 -
Quiz 22
-
Loading a Json data set and looking at the results
14:14 -
Quiz 23
-
Introduction to Nested JSON Data in Snowflake
10:06 -
Loading & Querying Nested JSON in Snowflake
Snowflake Architecture
-
Architecture basics
-
Snowflake’s Three-Layer Architecture
10:07 -
Snowflake’s Three-Layer Architecture Quiz 27
-
Metadata Handling in the Cloud Services Layer
05:52 -
Micro-Partitions in the Storage Layer
-
Virtual Warehouse Sizing in the Compute Layer
05:23 -
Quiz 28
-
SnowGrid
08:20 -
Snowgrid – Snowflake’s Global Data Network Quiz 42
-
Advanced Concepts
Snowflake UI
-
Snowsight (Modern Web UI)
16:40 -
Quiz 31
-
SnowSQL (CLI)
06:45 -
Quiz 32
-
SnowSQL Assignment
-
Object Browser & Data Preview (Snowsight)
-
Query History
-
Quiz 33
-
Summary
-
Quiz 29
-
Migration to Snowflake
07:32 -
Migration to Snowflake – Quiz Questions
-
Partner Connect, Data Integration & Analytics Ecosystem
05:34 -
Partner Connect – Quiz Questions
-
Unified Data Management with Snowflake
-
Solution for Assignment
-
Third-Party Integrations in Snowflake
-
Third-Party Integrations – Quiz Questions
Sharing and Marketplace
-
Snowflake Sample data
09:06 -
Private Sharing in Snowflake – Quiz
-
Privileges for SNOWFLAKE_SAMPLE_DATA
-
Sample Queries for Shared Database
-
Quiz
-
Snowflake Data Exploration & Usage Monitoring
-
Sharing data with other accounts – Part 1
09:24 -
Sharing Data to Other Accounts – Part 2
12:33 -
How to Export Shared Data?
03:46 -
Data Sharing in Snowflake Quiz 30
-
Introduction to Snowflake Marketplace
10:36 -
Marketplace Example
-
Quiz: Snowflake Marketplace Fundamentals Quiz 36
Snowflake AI Intro
-
Snowflake Cortex AI (Introduction)
10:43 -
Cortex AI (General LLM Functions) – Quiz 40
-
Cortex AI
-
Snowflake Copilot
07:58 -
Snowflake Copilot – Quiz 39
-
Introduction to Document AI in Snowflake
08:12 -
Document AI hands on
09:54 -
Document AI – Quiz 37
-
Introduction to Snowflake Cortex Analyst
07:51 -
Cortex Analyst – Quiz 38
-
Cortex search
09:20 -
Snowflake Cortex Search- Quiz 41
-
Quiz: Snowflake Cortex AI & LLM Functions Quiz 34
Understand Snowflake Costs
-
Introduction to costs
07:52 -
Snowflake Credit-Based Compute Costs Quiz 35
-
Cost Example and an excercise
-
Resource monitor
12:37 -
Resource Monitors in Snowflake – Quiz
Student Ratings & Reviews
No Review Yet