What content do I miss if I don't pay for the course?

You can access all course content without paying (all videos, hands-on assignments, readings, etc.), except for the knowledge check quizzes. You also cannot get a Coursera certificate of completion without paying.

Where can I learn more about Snowflake?

You can find developer resources at developers.snowflake.com, and our product documentation at docs.snowflake.com.

When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Certificate?

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Intro to Snowflake for Devs, Data Scientists, Data Engineers

Ends tomorrow! Save on skills that make you shine with 40% off 3 months of Coursera Plus. Save now

Intro to Snowflake for Devs, Data Scientists, Data Engineers

This course is part of multiple programs.

Instructor: Snowflake Northstar

30,216 already enrolled

Included with

Learn more

3 modules

Gain insight into a topic and learn the fundamentals.

224 reviews

Beginner level

Recommended experience

Flexible schedule

1 week at 10 hours a week

Learn at your own pace

92%

Most learners liked this course

3 modules

Gain insight into a topic and learn the fundamentals.

224 reviews

Beginner level

Recommended experience

Flexible schedule

1 week at 10 hours a week

Learn at your own pace

92%

Most learners liked this course

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

28 assignments

Taught in English

91%

of learners achieved a positive career outcome

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.

Module details

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 videos15 readings9 assignments

18 videosTotal 93 minutes

Intro and Course Overview6 minutes
Worksheets and a Simple Example - Part I5 minutes
Worksheets and a Simple Example - Part II4 minutes
Virtual Warehouses Overview5 minutes
Virtual Warehouses Scaling - Part I4 minutes
Virtual Warehouses Scaling - Part II5 minutes
Stages and Basic Ingestion - Part I4 minutes
Stages and Basic Ingestion - Part II5 minutes
Databases and Schemas - Part I5 minutes
Databases and Schemas - Part II6 minutes
Tables - Part I5 minutes
Tables - Part II5 minutes
Views - Part I6 minutes
Views - Part II4 minutes
Semi-Structured Data Types8 minutes
Semi-Structured Data Manipulation10 minutes
Snowflake Architecture Overview5 minutes
Wrap-up of Snowflake’s Core Objects and Architecture1 minute

15 readingsTotal 72 minutes

Course Components & Resources5 minutes
[Optional Reference] Worksheets and a Simple Example - Code1 minute
Code to Run Before Hands-on Assignment10 minutes
Virtual Warehouses Overview — What's Changed10 minutes
[Optional Reference] Virtual Warehouses - Code1 minute
Virtual Warehouses Scaling — What's Changed10 minutes
[Optional Reference] Stages and Basic Ingestion - Code1 minute
Stages and Basic Ingestion — What's Changed10 minutes
Code to Run Before Hands-on Assignment5 minutes
[Optional Reference] Databases and Schemas - Code1 minute
[Optional Reference] Tables - Code1 minute
Code to Run Before Hands-on Assignment5 minutes
[Optional Reference] Views - Code1 minute
[Optional Reference] Semi-Structured Data - Code1 minute
Snowflake Architecture Overview — What's Changed10 minutes

9 assignmentsTotal 115 minutes

Module 1 Assessment (Knowledge Check)15 minutes
Worksheets Hands-on Assignment6 minutes
Virtual Warehouses Hands-on Assignment12 minutes
Stages & Basic Ingestion Hands-on Assignment10 minutes
Databases & Schemas Hands-on Assignment12 minutes
Tables Hands-on Assignment8 minutes
Views Hands-on Assignment12 minutes
Semi-Structured Data Hands-on Assignment10 minutes
Collaborative Development and Data Clean Rooms Assessment30 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 videos12 readings9 assignments

18 videosTotal 93 minutes

Intro to Snowflake Feature Overview1 minute
Time Travel - Part I3 minutes
Time Travel - Part II8 minutes
Permanent, Transient, and Temporary Tables5 minutes
Cloning6 minutes
Resource Monitors7 minutes
User-Defined Functions (UDFs) - Part I4 minutes
User-Defined Functions (UDFs) - Part II5 minutes
User-Defined Table Functions (UDTFs)4 minutes
Stored Procedures - Part I4 minutes
Stored Procedures - Part II7 minutes
Role-based Access Control (RBAC) - Part I5 minutes
Role-based Access Control (RBAC) - Part II [Tether]4 minutes
VS Code Extension6 minutes
Snowpark DataFrames - Part I8 minutes
Snowpark DataFrames - Part II6 minutes
Snowflake CLI6 minutes
Wrap-up of Snowflake Feature Overview2 minutes

12 readingsTotal 32 minutes

[Optional Reference] Time Travel - Code1 minute
Code to Run Before Hands-on Assignment3 minutes
[Optional Reference] Permanent, Transient, and Temporary Tables - Code1 minute
[Optional Reference] Cloning - Code1 minute
Cloning — What's Changed10 minutes
[Optional Reference] Resource Monitors - Code1 minute
[Optional Reference] UDFs & UDTFs - Code1 minute
UDFs — What's Changed10 minutes
[Optional Reference] Stored Procedures - Code1 minute
[Optional Reference] Role-based Access Control - Code1 minute
[Optional Reference] Snowpark DataFrames - Code1 minute
[Optional Reference] Snowpark CLI - Code1 minute

9 assignmentsTotal 107 minutes

Module 2 Assessment (Knowledge Check)15 minutes
Time Travel Hands-on Assignment12 minutes
Table Types Knowledge Check Quiz8 minutes
Cloning Hands-on Assignment10 minutes
Resource Monitors Hands-on Assignment8 minutes
UDFs & UDTFs Hands-on Assignment12 minutes
Stored Procedures Hands-on Assignment15 minutes
RBAC Hands-on Assignment12 minutes
Snowpark DataFrames Hands-on Assignment15 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.