Current Level 1: SNOWFLAKE Level-0
0 / 5 Miles
0 / 6 Assignments
0 / 5 Exams

📖 Course Miles: Passed Failed Pending Not Attempted

Mile 1: Snowflake Journey Overview

🎬 YouTube Videos

No YouTube videos available

Check back later for new YouTube content.

📹 Library Videos

Snowflake Journey Overview

📚 Content

SECTION 1 SNOWFLAKE

2 min read

Welcome to Snowflake
Learn how Snowflake helps you store, manage, process and analyze data using a modern cloud-based data warehouse. Explore Snowflake architecture, write SQL queries, create databases and tables, load data from different cloud platforms, understand how to manage and optimize data efficiently.

Explore how Snowflake connects, stores, processes and shares data through its powerful cloud-based data platform.


This Snowflake Journey is divided into five progressive levels to build your skills step by step:

Level 0 – Foundation: Start from zero—understand cloud data warehousing, Snowflake architecture, key concepts, databases, schemas and tables.
Level 1 – Basic: Learn SQL fundamentals, DDL and DML commands, query syntax, operators, virtual warehouses and views.
Level 2 – Intermediate: Work with subqueries, CASE statements, SQL functions, transactions and constraints.
Level 3 – Advanced: Explore advanced SQL concepts, complex queries, performance optimization, data loading and Snowflake features.
Level 4 – Expert: Solve real-world Snowflake scenarios, build end-to-end data solutions, optimize workloads, troubleshoot issues and prepare for interview-level challenges.

Sign up or sign in to rate this section
SECTION 2 LEVEL 0. SNOWFLAKE FUNDAMENTALS

1 min read


Start your Snowflake journey from scratch by understanding the fundamentals of Snowflake, its cloud architecture, user interface and how to create your first database and table.

Snowflake Level-0: Learning Journey
1. Mile 1: Snowflake Journey Overview
2. Mile 2: Introduction to Snowflake
3. Mile 3: Snowflake Architecture Simplified
4. Mile 4: Exploring the Snowflake User Interface
5. Mile 5: Build Your First Database & Table

Sign up or sign in to rate this section
SECTION 3 LEVEL 1. BASIC SNOWFLAKE

1 min read


Build a strong foundation in SQL by learning how to write and execute queries, manage databases and tables, use SQL commands and work with Snowflake warehouses and views.

Snowflake Level-1: Learning Journey
Mile 6: SQL Fundamentals
Mile 7: Writing & Executing SQL
Mile 8: Data Types
Mile 9: Databases, Schemas & Tables
Mile 10: DDL Commands
Mile 11: DML Commands
Mile 12: Query Syntax
Mile 13: Query Operators
Mile 14: Virtual Warehouse Creation
Mile 15: Views

Sign up or sign in to rate this section
SECTION 4 LEVEL 2. INTERMEDIATE SNOWFLAKE

1 min read


Advance your Snowflake knowledge by exploring subqueries, conditional statements, functions, joins, transactions and data loading techniques. Learn to work with complex queries and manage data efficiently in Snowflake.

Snowflake Level-2: Learning Journey
Mile 16: Sub-queries
Mile 17: Case Statements
Mile 18: Functions & Transactions
Mile 19: Constraints in Snowflake
Mile 20: Information Schema
Mile 21: Joins in Snowflake
Mile 22: Aggregate Functions, GROUP BY & HAVING
Mile 23: Commands for Loading/Unloading
Mile 24: SnowSQL (CLI Client)
Mile 25: Stages in Snowflake

Sign up or sign in to rate this section
SECTION 5 LEVEL 3. ADVANCED SNOWFLAKE

1 min read


Explore advanced Snowflake capabilities, including cloud storage integration, data loading and unloading, Snowpipe, semi-structured data, data sharing, Time Travel and performance optimization.

Snowflake Level-3: Learning Journey
Mile 26: Loading Data Using Internal Stage in Snowflake
Mile 27: Unloading Data Using Internal Stage
Mile 28: Connecting to AWS S3
Mile 29: Loading Data from AWS S3 to Snowflake
Mile 30: Unloading Data to AWS S3
Mile 31: Loading Data to AWS S3
Mile 32: Snowpipe
Mile 33: Loading Data to Google GCS
Mile 34: Unloading Data to Google GCS
Mile 35: Connecting to Azure

Sign up or sign in to rate this section
SECTION 6 LEVEL 4. COMPLEX SNOWFLAKE

1 min read


Explore advanced Snowflake features and techniques to manage, secure, share and optimize data. Learn about semi-structured data, cloning, Time Travel, caching, performance tuning and resource management.

Snowflake Level-4: Learning Journey
Mile 36: Uploading Data to Snowflake from Azure
Mile 37: Different Types of Tables
Mile 38: Semi-Structured Data
Mile 39: Clone Feature in Snowflake
Mile 40: Data Sharing in Snowflake
Mile 41: Snowflake Time Travel and Fail-safe
Mile 42: Caching in Snowflake
Mile 43: Performance Tuning
Mile 44: Resource Monitor
Mile 45: Streams in Snowflake

Sign up or sign in to rate this section
Previous Next Mile

📝 Assignment

Available Assignments
Assignment Pass Mark Duration Actions
Snowflake Journey Overview
70% 01:00:00

📊 Exam

Available Exams
Exam Pass Mark Duration Questions Actions
Snowflake Journey Overview
70% 00:30:00 5

💬 Comments & Discussion

Sign up free or sign in to post a comment
Sign up free or sign in
No comments yet

Be the first to share your thoughts!