Intro to Snowflake for Devs, Data Scientists, Data Engineers

This course is part of multiple programs.

Instructor: Snowflake Northstar

Access provided by Syrian Youth Assembly

25,936 already enrolled

3 modules

Gain insight into a topic and learn the fundamentals.

213 reviews

Beginner level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

3 modules

Gain insight into a topic and learn the fundamentals.

213 reviews

Beginner level

Recommended experience

1 week to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

Create and manipulate Snowflake's core objects, such as virtual warehouses, databases, schemas, tables, and stages.
Use important Snowflake features and objects, such as time travel, cloning, resources monitors, UDFs, stored procedures, and Snowpark DataFrames.
Understand the basics of Snowflake’s capabilities for data engineering, generative AI, machine learning, and app development.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

27 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is available as part of

When you enroll in this course, you'll also be asked to select a specific program.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Snowflake

There are 3 modules in this course

This course introduces learners to Snowflake as a platform for building applications, data pipelines, and AI models and workflows. It takes them from zero Snowflake knowledge all the way to creating user-defined functions, using a Snowflake Cortex LLM function, editing a Streamlit app, and more.

The course unfolds in three parts: First, participants learn to use Snowflake’s core objects such as virtual warehouses, stages, and databases. Then they learn about slightly more advanced objects and features such as time travel, cloning, user-defined functions, and stored procedures. Finally, they’re introduced to Snowflake’s capabilities for data engineering, generative AI, machine learning, and app development. Learners come away equipped to start building with Snowflake and to continue their Snowflake learning journeys. This course is a prerequisite for upcoming Snowflake courses on data engineering, AI, and apps.

After a very brief intro to the course, learners will create a free trial, open a worksheet, and query sample data. They’ll learn about scaling virtual warehouses and create a virtual warehouse to ingest Tasty Bytes data. They’ll learn about stages, databases, schemas, and tables. They’ll manipulate semi-structured data. They’ll also learn about the different Snowflake architectural layers.

What's included

18 videos11 readings8 assignments

18 videos Total 93 minutes

Intro and Course Overview 6 minutes
Worksheets and a Simple Example - Part I 5 minutes
Worksheets and a Simple Example - Part II 4 minutes
Virtual Warehouses Overview 5 minutes
Virtual Warehouses Scaling - Part I 4 minutes
Virtual Warehouses Scaling - Part II 5 minutes
Stages and Basic Ingestion - Part I 4 minutes
Stages and Basic Ingestion - Part II 5 minutes
Databases and Schemas - Part I 5 minutes
Databases and Schemas - Part II 6 minutes
Tables - Part I 5 minutes
Tables - Part II 5 minutes
Views - Part I 6 minutes
Views - Part II 4 minutes
Semi-Structured Data Types 8 minutes
Semi-Structured Data Manipulation 10 minutes
Snowflake Architecture Overview 5 minutes
Wrap-up of Snowflake’s Core Objects and Architecture 1 minute

11 readings Total 32 minutes

Course Components & Resources 5 minutes
[Optional Reference] Worksheets and a Simple Example - Code 1 minute
Code to Run Before Hands-on Assignment 10 minutes
[Optional Reference] Virtual Warehouses - Code 1 minute
[Optional Reference] Stages and Basic Ingestion - Code 1 minute
Code to Run Before Hands-on Assignment 5 minutes
[Optional Reference] Databases and Schemas - Code 1 minute
[Optional Reference] Tables - Code 1 minute
Code to Run Before Hands-on Assignment 5 minutes
[Optional Reference] Views - Code 1 minute
[Optional Reference] Semi-Structured Data - Code 1 minute

8 assignments Total 85 minutes

Worksheets Hands-on Assignment 6 minutes
Virtual Warehouses Hands-on Assignment 12 minutes
Stages & Basic Ingestion Hands-on Assignment 10 minutes
Databases & Schemas Hands-on Assignment 12 minutes
Tables Hands-on Assignment 8 minutes
Views Hands-on Assignment 12 minutes
Semi-Structured Data Hands-on Assignment 10 minutes
Module 1 Assessment (Knowledge Check) 15 minutes

Learners will identify a recently introduced “error” in the data and use time travel to correct it. They’ll learn about permanent, transient, and temporary tables, and cloning. They’ll create resource monitors. They’ll create UDFs, a UDTF, and a SQL stored procedure. They’ll learn about role-based access, the VS Code extension, Snowpark DataFrames, and the Snowflake CLI.

What's included

18 videos10 readings9 assignments

18 videos Total 93 minutes

Intro to Snowflake Feature Overview 1 minute
Time Travel - Part I 3 minutes
Time Travel - Part II 8 minutes
Permanent, Transient, and Temporary Tables 5 minutes
Cloning 6 minutes
Resource Monitors 7 minutes
User-Defined Functions (UDFs) - Part I 4 minutes
User-Defined Functions (UDFs) - Part II 5 minutes
User-Defined Table Functions (UDTFs) 4 minutes
Stored Procedures - Part I 4 minutes
Stored Procedures - Part II 7 minutes
Role-based Access Control (RBAC) - Part I 5 minutes
Role-based Access Control (RBAC) - Part II [Tether] 4 minutes
VS Code Extension 6 minutes
Snowpark DataFrames - Part I 8 minutes
Snowpark DataFrames - Part II 6 minutes
Snowflake CLI 6 minutes
Wrap-up of Snowflake Feature Overview 2 minutes

10 readings Total 12 minutes

[Optional Reference] Time Travel - Code 1 minute
Code to Run Before Hands-on Assignment 3 minutes
[Optional Reference] Permanent, Transient, and Temporary Tables - Code 1 minute
[Optional Reference] Cloning - Code 1 minute
[Optional Reference] Resource Monitors - Code 1 minute
[Optional Reference] UDFs & UDTFs - Code 1 minute
[Optional Reference] Stored Procedures - Code 1 minute
[Optional Reference] Role-based Access Control - Code 1 minute
[Optional Reference] Snowpark DataFrames - Code 1 minute
[Optional Reference] Snowpark CLI - Code 1 minute

9 assignments Total 107 minutes

Time Travel Hands-on Assignment 12 minutes
Table Types Knowledge Check Quiz 8 minutes
Cloning Hands-on Assignment 10 minutes
Resource Monitors Hands-on Assignment 8 minutes
UDFs & UDTFs Hands-on Assignment 12 minutes
Stored Procedures Hands-on Assignment 15 minutes
RBAC Hands-on Assignment 12 minutes
Snowpark DataFrames Hands-on Assignment 15 minutes
Module 2 Assessment (Knowledge Check) 15 minutes

Learners will explore four Snowflake workloads: Data Engineering, Generative AI, Machine Learning, and Applications. After reviewing each workload, they’ll see one aspect of that workload in practice: for DE, ingesting streaming data with Snowpipe; for GenAI, using the Snowflake Cortex LLM function “Complete”; for ML, using Snowpark ML to create an XGBoost model and make predictions about a food truck’s location; and for apps, running a Streamlit app that shows us Tasty Bytes’ daily revenue. They will then learn about the Snowflake Data Cloud.