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 -
Checkpoint Quizzes
-
Authentication and access control
08:18 -
Checkpoint Quizzes
-
DAC
05:27 -
Checkpoint Quizzes
-
Privileges and other access concepts
06:23 -
Checkpoint Quizzes
-
Intro to Warehouse
03:53 -
Checkpoint Quizzes
Introduction to Data concepts
-
Example Introduction
02:00 -
Checkpoint Quizzes
-
Sheet and sample statements
01:50 -
Checkpoint Quizzes
-
Dataset Creation Concept
07:08 -
Checkpoint Quizzes
-
Checkpoint Quizzes
-
Dataset Creation Implementation
05:12 -
Checkpoint Quizzes
-
Insert Data
-
Checkpoint Quizzes
-
More on Worksheets
-
Checkpoint Quizzes
-
More on Warehouse and other related concepts
03:22 -
Checkpoint Quizzes
-
Best Practices and tips
07:10 -
Checkpoint Quizzes
-
Time Travel and Fail-safe
05:57 -
Time Travel and Fail-safe (Demo)
-
Backup and Recovery
-
Wrap Up
-
Assignment: Snowflake Data Recovery & Continuity Scenario
-
Solution for assignment
-
Summary on Backup & Recovery Features
-
Checkpoint Quizzes
Data Loading
-
Introduction and dataset
06:25 -
Notebooks and how to use them
05:20 -
Introduction to Streamlit
-
Checkpoint Quizzes
-
Streamlit to insert data into our Main_Courses
09:41
Staging in Snowflake
-
Intro to stages
08:44 -
Checkpoint Quizzes
-
Creating a Stage
07:14 -
Checkpoint Quizzes
-
Specifics of a stage
04:57 -
Checkpoint Quizzes
-
Create a Stage and Load data
03:32 -
Checkpoint Quizzes
-
File formats Hands on
05:37 -
Checkpoint Quizzes
-
Other Concepts Related To Stage
-
Checkpoint Quizzes
Data Architecture and Storage Essentials
-
Introduction to ERD Concepts
08:20 -
Checkpoint Quizzes
-
Many-to-Many Relationships with Example
09:56 -
Checkpoint Quizzes
-
Sequence and Inserting data with it
09:30 -
Checkpoint Quizzes
-
Introduction to Semi-Structured Data in Snowflake
06:02 -
Checkpoint Quizzes
-
Loading a Json data set and looking at the results
14:14 -
Checkpoint Quizzes
-
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 -
Checkpoint Quizzes
-
Metadata Handling in the Cloud Services Layer
05:52 -
Micro-Partitions in the Storage Layer
-
Virtual Warehouse Sizing in the Compute Layer
05:23 -
Checkpoint Quizzes
-
SnowGrid
08:20 -
Checkpoint Quizzes
-
Advanced Concepts
Snowflake UI
-
Snowsight (Modern Web UI)
16:40 -
Checkpoint Quizzes
-
SnowSQL (CLI)
06:45 -
Checkpoint Quizzes
-
SnowSQL Assignment
-
Object Browser & Data Preview (Snowsight)
-
Query History
-
Checkpoint Quizzes
-
Summary
-
Checkpoint Quizzes
-
Migration to Snowflake
07:32 -
Checkpoint Quizzes
-
Partner Connect, Data Integration & Analytics Ecosystem
05:34 -
Checkpoint Quizzes
-
Unified Data Management with Snowflake
-
Solution for Assignment
-
Third-Party Integrations in Snowflake
-
Checkpoint Quizzes
Sharing and Marketplace
-
Snowflake Sample data
09:06 -
Checkpoint Quizzes
-
Privileges for SNOWFLAKE_SAMPLE_DATA
-
Sample Queries for Shared Database
-
Checkpoint Quizzes
-
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 -
Checkpoint Quizzes
-
Introduction to Snowflake Marketplace
10:36 -
Marketplace Example
-
Checkpoint Quizzes
Snowflake AI Intro
-
Snowflake Cortex AI (Introduction)
10:43 -
Checkpoint Quizzes
-
Cortex AI
-
Snowflake Copilot
07:58 -
Checkpoint Quizzes
-
Introduction to Document AI in Snowflake
08:12 -
Document AI hands on
09:54 -
Checkpoint Quizzes
-
Introduction to Snowflake Cortex Analyst
07:51 -
Checkpoint Quizzes
-
Cortex search
09:20 -
Checkpoint Quizzes
-
Checkpoint Quizzes
Understand Snowflake Costs
-
Introduction to costs
07:52 -
Checkpoint Quizzes
-
Cost Example and an excercise
-
Resource monitor
12:37 -
Checkpoint Quizzes
Student Ratings & Reviews
No Review Yet