Learn

Platform

For Business

Pricing

Resources

FREE Course

/

/

Intro to Snowflake

Self-paced course

Self-paced course

Intro to Snowflake

Intro to Snowflake

COMING SOON

COMING SOON

COMING SOON

COMING SOON

Course Description

This course is designed to get you up and running with Snowflake, one of the most popular cloud data warehouses used by modern data teams today.

We'll kick things off with a Snowflake overview — what it is, how it differs from traditional on-premise databases, and how it fits into the modern data stack alongside tools like dbt, Fivetran, and Airflow. You'll also write your very first SQL query in Snowflake early on, so you get hands-on practice right away.

From there, we'll dig into Snowflake's architecture. You'll learn how it's built across three layers — storage, compute, and services — and cover key concepts like micro-partitioning and virtual warehouses that explain why Snowflake is able to run so efficiently at scale.

Next, we'll get into SQL in Snowflake. We'll walk through how to set the context, create a virtual warehouse, upload data, and navigate the UI. We'll also cover Snowflake-specific functions like MAX_BY and QUALIFY, and how to work with semi-structured JSON data using the VARIANT type.

To round things out, we'll cover some of Snowflake's most useful features — Time Travel, Zero-Copy Cloning, Secure Data Sharing, and query optimization using the built-in query profile. We'll finish with an intro to Cortex AI and Cortex Code, Snowflake's built-in tools for running AI models and working with a GenAI assistant directly in the UI.

Whether you're a data analyst adding Snowflake to your toolkit or coming from a SQL background and exploring cloud data warehousing for the first time, this is the course for you.

Course Content

4 course hours

3 assignments & solutions

4 quizzes

Who should take this course

Aspiring analytics engineers looking to transition or break into the field

Data professionals who want a better understanding of modern data warehousing

Anyone who wants to get hands-on practice using Snowflake

Meet your instructors

Alice Zhao

Lead Data Science Instructor

Alice Zhao is a seasoned data scientist and author of the book, SQL Pocket Guide, 4th Edition (O'Reilly). She's an adjunct lecturer for Northwestern University's Machine Learning and Data Science program, where she teaches Python, SQL, R, data warehousing and data visualization.

Featured review

Included learning paths

Course credential

You’ll earn the course certification by completing this course and passing the assessment requirements

Intro to Snowflake

CPE Accreditation

CPE Credits:

0

Field of Study:

Information Technology

Delivery Method:

QAS Self Study

Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.

Course Description

This course is designed to get you up and running with Snowflake, one of the most popular cloud data warehouses used by modern data teams today.

We'll kick things off with a Snowflake overview — what it is, how it differs from traditional on-premise databases, and how it fits into the modern data stack alongside tools like dbt, Fivetran, and Airflow. You'll also write your very first SQL query in Snowflake early on, so you get hands-on practice right away.

From there, we'll dig into Snowflake's architecture. You'll learn how it's built across three layers — storage, compute, and services — and cover key concepts like micro-partitioning and virtual warehouses that explain why Snowflake is able to run so efficiently at scale.

Next, we'll get into SQL in Snowflake. We'll walk through how to set the context, create a virtual warehouse, upload data, and navigate the UI. We'll also cover Snowflake-specific functions like MAX_BY and QUALIFY, and how to work with semi-structured JSON data using the VARIANT type.

To round things out, we'll cover some of Snowflake's most useful features — Time Travel, Zero-Copy Cloning, Secure Data Sharing, and query optimization using the built-in query profile. We'll finish with an intro to Cortex AI and Cortex Code, Snowflake's built-in tools for running AI models and working with a GenAI assistant directly in the UI.

Whether you're a data analyst adding Snowflake to your toolkit or coming from a SQL background and exploring cloud data warehousing for the first time, this is the course for you.

Curriculum

Meet your instructors

Alice Zhao

Lead Data Science Instructor

Alice Zhao is a seasoned data scientist and author of the book, SQL Pocket Guide, 4th Edition (O'Reilly). She's an adjunct lecturer for Northwestern University's Machine Learning and Data Science program, where she teaches Python, SQL, R, data warehousing and data visualization.

Student reviews

Included learning paths

Course credential

You’ll earn the course certification by completing this course and passing the assessment requirements

Intro to Snowflake

Intro to Snowflake

CPE Accreditation

CPE Credits:

0

Field of Study:

Information Technology

Delivery Method:

QAS Self Study

Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.

More courses you may like

FOR INDIVIDUALS

Master data & AI skills

Build data & AI skills to launch or accelerate your career (start for free, no credit card required).

FOR COMPANIES & TEAMS

Transform your workforce

Assess your team’s data & AI skills and follow personalized learning plans to close the gaps.

FOR INDIVIDUALS

Master data & AI skills

Build data & AI skills to launch or accelerate your career (start for free, no credit card required).

FOR COMPANIES & TEAMS

Transform your workforce

Assess your team’s data & AI skills and follow personalized learning plans to close the gaps.

FOR INDIVIDUALS

Master data & AI skills

Build data & AI skills to launch or accelerate your career (start for free, no credit card required).

FOR COMPANIES & TEAMS

Transform your workforce

Assess your team’s data & AI skills and follow personalized learning plans to close the gaps.