Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

DataCamp

Introduction to Snowflake SQL

via DataCamp

Overview

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.

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 SQLThe 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!

Syllabus

  • Snowflake SQL and key concepts
    • 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.
  • 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.

Taught by

Palak Raina

Reviews

4.8 rating at DataCamp based on 5969 ratings

Start your review of Introduction to Snowflake SQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.