Intro to Snowflake for Devs, Data Scientists, Data Engineers

Instructor: Snowflake Northstar

Sponsored by Louisiana Workforce Commission

7,232 already enrolled

3 modules

Gain insight into a topic and learn the fundamentals.

4.8

(47 reviews)

Beginner level

Recommended experience

10 hours to complete

3 weeks at 3 hours a week

Flexible schedule

Learn at your own pace

3 modules

Gain insight into a topic and learn the fundamentals.

4.8

(47 reviews)

Beginner level

Recommended experience

10 hours to complete

3 weeks at 3 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.

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

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

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 videosTotal 92 minutes

Intro and Course Overview5 minutesPreview module
Worksheets and a Simple Example - Part I5 minutes
Worksheets and a Simple Example - Part II3 minutes
Virtual Warehouses Overview5 minutes
Virtual Warehouses Scaling - Part I3 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 I4 minutes
Databases and Schemas - Part II5 minutes
Tables - Part I4 minutes
Tables - Part II4 minutes
Views - Part I5 minutes
Views - Part II4 minutes
Semi-Structured Data Types7 minutes
Semi-Structured Data Manipulation10 minutes
Snowflake Architecture Overview4 minutes
Wrap-up of Snowflake’s Core Objects and Architecture1 minute

11 readingsTotal 32 minutes

Course Components & Resources5 minutes
[Optional Reference] Worksheets and a Simple Example - Code1 minute
Code to Run Before Hands-on Assignment10 minutes
[Optional Reference] Virtual Warehouses - Code1 minute
[Optional Reference] Stages and Basic Ingestion - Code1 minute
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

8 assignmentsTotal 85 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

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 videosTotal 93 minutes

Intro to Snowflake Feature Overview1 minutePreview module
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 II4 minutes
User-Defined Table Functions (UDTFs)4 minutes
Stored Procedures - Part I3 minutes
Stored Procedures - Part II6 minutes
Role-based Access Control (RBAC) - Part I5 minutes
Role-based Access Control (RBAC) - Part II [Tether]3 minutes
VS Code Extension6 minutes
Snowpark DataFrames - Part I7 minutes
Snowpark DataFrames - Part II5 minutes
Snowflake CLI6 minutes
Wrap-up of Snowflake Feature Overview2 minutes

10 readingsTotal 12 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
[Optional Reference] Resource Monitors - Code1 minute
[Optional Reference] UDFs & UDTFs - Code1 minute
[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.