Skip to main content
Vibe Harboe Christensen avatar

Vibe Harboe Christensen has completed

Introduction to Snowflake SQL

Start course For Free
2 hr
1,800 XP
Statement of Accomplishment Badge

Loved by learners at thousands of companies

Course Description

Dive into Snowflake's universe!


This course will teach you the fundamentals of Snowflake SQL - the unique SQL flavor used to interact with Snowflake data warehouses. You'll see how Snowflake SQL compares and contrasts with PostgreSQL and learn about data types and functions.

Unlock the power of Snowflake SQL


The course will introduce you to various approaches for building complex SQL queries, including natural and lateral joins, sub-querying, and common table expressions. Conclude by examining techniques for optimizing your queries and discover how to effectively store and query semi-structured data!
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.
DataCamp for BusinessFor a bespoke solution book a demo.
  1. 1

    Snowflake SQL and key concepts

    Free

    In this chapter, you're diving into Snowflake SQL. You'll start by discovering how Snowflake SQL compares and contrasts with other SQL flavors such as PostgreSQL. You'll use essential Snowflake SQL commands to interact with your data and broaden your understanding of Snowflake data types, learning to convert them. Finally, we'll get into functions, sorting, and grouping.

    Play Chapter Now
    Introduction to Snowflake SQL
    50 xp
    Querying using Snowflake SQL
    100 xp
    Filtering in Snowflake SQL
    100 xp
    Snowflake data types
    50 xp
    Checking data types
    100 xp
    Data type conversion
    100 xp
    Functions, sorting, and grouping
    50 xp
    String functions
    100 xp
    DATE & TIME
    100 xp
    Functions & Grouping
    100 xp
  2. 2

    Advanced Snowflake SQL Concepts

    Time to advance your skills in Snowflake SQL. You'll begin by exploring diverse join methods and building complex queries with subqueries and CTEs. We'll emphasize query optimization, showing you ways to enhance the speed and efficiency of your SQL tasks. At the end, we'll delve into handling semi-structured data like JSON.

    Play Chapter Now
    Joining in Snowflake
    50 xp
    NATURAL JOIN
    100 xp
    The world of JOINS
    100 xp
    Subquerying and Common Table Expressions
    50 xp
    Subqueries
    100 xp
    Common Table Expressions
    100 xp
    Snowflake Query Optimization
    50 xp
    Early filtering
    100 xp
    Handling semi-structured data
    50 xp
    Querying JSON data
    100 xp
    JSONified
    100 xp
    Wrap-up
    50 xp
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.

collaborators

Collaborator's avatar
George Boorman
Collaborator's avatar
Arne Warnke
Collaborator's avatar
Palak Raina
Collaborator's avatar
Anastasia Dvoryanchikova

prerequisites

Joining Data in SQLIntroduction to Snowflake
George Boorman HeadshotGeorge Boorman

Senior Curriculum Manager, DataCamp

George is a Curriculum Manager at DataCamp. He holds a PGDip in Exercise for Health and BSc (Hons) in Sports Science and has experience in project management across public health, applied research, and not-for-profit sectors. George is passionate about sports, tech for good, and all things data science.
See More

Join over 18 million learners and start Introduction to Snowflake SQL today!

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.