Intro to Snowflake for Devs, Data Scientists, Data Engineers

Course details

Ready to get started with Snowflake, the easy-to-use platform for building applications, data pipelines, AI models, and workflows? In this course, you’ll progress from zero all the way to creating user-defined functions, using a Snowflake Cortex LLM function, editing a Streamlit app, and more. Learn to use Snowflake’s core objects such as virtual warehouses, stages, and databases, before turning to more advanced objects and features such as time travel, cloning, and stored procedures. By the end of this course, you’ll be ready to start building with Snowflake and to take more advanced Snowflake courses, including courses in data engineering and generative AI.

Learning objectives
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, user-defined functions, stored procedures, and Snowpark DataFrames.
Describe the basics of Snowflake’s capabilities for data engineering, generative AI, machine learning, and app development.

Concepts

Introduction

Intro and course overview

Worksheets

Worksheets and a simple example - Part 1
Worksheets and a simple example - Part 2

Virtual Warehouses

Virtual warehouses overview
Virtual warehouses scaling - Part 1
Virtual warehouses scaling - Part 2

Stages and Basic Ingestion

Stages and basic ingestion - Part 1
Stages and basic ingestion - Part 2

Databases and Schemas

Databases and schemas - Part I
Databases and schemas - Part 2
Database explorer

Tables

Tables - Part 1
Tables - Part 2

Views

Views - Part 1
Views - Part 2

Semistructured Data

Semistructured data types
Semistructured data manipulation

Snowflake Architecture

Snowflake architecture overview
Wrap-up of Snowflake s core objects and architecture

Collaborative Development and Data Clean Rooms

Collaborative development

Time Travel

Intro to Snowflake feature overview
Time travel - Part 1
Time travel - Part 2

Table Types

Permanent, transient, and temporary tables

Cloning

Cloning

Resource Monitors

Resource monitors

User-Defined Functions (UDFs)

User-defined functions (UDFs) - Part 1
User-defined functions (UDFs) - Part 2
User-defined table functions (UDTFs)

Stored Procedures

Stored procedures - Part 1
Stored procedures - Part 2

Role-Based Access Control (RBAC)

Role-based access control (RBAC) - Part 1
Role-based access control (RBAC) - Part 2

Snowpark DataFrames and VS Code Extension

VS Code extension
Snowpark DataFrames - Part 1
Snowpark DataFrames - Part 2

Snowflake CLI

Snowflake CLI
Wrap-up of Snowflake feature overview

Data Engineering with Snowflake

Intro to overview of builder workloads
Snowflake data engineering overview - Part 1
Snowflake data engineering overview - Part 2

Ingesting Data with Snowpipe

Snowpipe - Part 1
Snowpipe - Part 2

GenAI with Snowflake

Snowflake genAI overview - Part 1
Snowflake genAI overview - Part 2
Cortex CLI

Snowflake Cortex LLM Functions

Snowflake Cortex LLM functions - Part 1
Snowflake Cortex LLM functions - Part 2

Machine Learning with Snowflake

Snowflake ML overview - Part 1
Snowflake ML overview - Part 2

Snowpark ML Modeling

Snowpark ML modeling - Part 1
Snowpark ML modeling - Part 2
Snowpark ML modeling - Part 3

Applications with Snowflake

Snowflake applications overview - Part 1
Snowflake applications overview - Part 2

Streamlit in Snowflake

Streamlit in Snowflake - Part 1
Streamlit in Snowflake - Part 2

The Data Cloud

The data cloud
Wrap-up of overview of builder workloads
Course conclusion