コース説明

前提条件

Joining Data in SQL Introduction to Snowflake

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.

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

チャプターを開始

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.

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