Build your data manipulation skills with the basics of conditional logic. Implement if-then logic data using `CASE` statements,  catch edge cases using `ELSE`, and transform results using tools like aggregation functions.

Data manipulation in Snowflake

Explore the Store data

Is this a premium song?

Conditional logic with CASE statements

Inferring purchase quantity

Is this a long song?

Determining buyer intent

Applying conditional logic in Snowflake

Comparing invoice totals

Validating data quality

How many protected files?

Conditional Logic

Don’t just use one query when you can use two (or three)! Unlock the power of subqueries and common table expressions to write cleaner, more modular Snowflake queries. Simplify complex logic, reuse results, and level up your data manipulation capabilities in Snowflake.

Subqueries

Subquery Syntax

Building subqueries

Are jazz songs long?

Identifying large transactions

Common Table Expressions

Analyzing track length

Finding the most efficient composer

Where are customers buying?

Advanced Common Table Expressions

Building a detailed invoice

Finding the most popular artists

Wrapping up!

Albums driving sales

Hot genres

Manipulating Data with Subqueries and Common Table Expressions

To handle data big and small, clean or dirty, structured or unstructured, thousands of data teams turn to Snowflake. In this course, you’ll master the skills you need to manipulate and transform data in Snowflake.

First, you’ll explore how to implement if-then logic using CASE statements in Snowflake. Using CASE statements, you’ll learn to evaluate different conditions in order to do things like categorize values in a table. And often is won’t be just one condition you’re evaluating; you’ll also get your hands dirty building CASE statements with multiple, complex conditional statements.

Once you’re confident with CASE statements, you’ll dive head-first into using writing subqueries. Subqueries will give you the power to combine the results on another query in the one that you’re building. You’ll also come to find how common table expressions allow for you to do something quite similar, but this time, it a bit of a more organized way.

By the end of this course, you’ll have the tools you need for manipulating and transforming data in Snowflake, and leveling-up your career as a data professional.

<h2>Transform and categorize data</h2><p>To handle data big and small, clean or dirty, structured or unstructured, thousands of data teams turn to Snowflake. In this course, you’ll master the skills you need to manipulate and transform data in Snowflake. First, you’ll explore how to implement if-then logic using CASE statements in Snowflake. Using CASE statements, you’ll learn to evaluate different conditions in order to do things like categorize values in a table. And often is won’t be just one condition you’re evaluating; you’ll also get your hands dirty building CASE statements with multiple, complex conditional statements.</p><h2>Build subqueries and Common Table Expressions (CTEs)</h2><p>Once you’re confident with CASE statements, you’ll dive head-first into using writing subqueries. Subqueries will give you the power to combine the results on another query in the one that you’re building. You’ll also come to find how common table expressions allow for you to do something quite similar, but this time, it a bit of a more organized way.<br><br>By the end of this course, you’ll have the tools you need for manipulating and transforming data in Snowflake, and leveling-up your career as a data professional.</p>

Introduction to Snowflake SQL

Master data manipulation and analysis techniques such as CASE statements, subqueries, and CTEs in Snowflake.

Data Manipulation in Snowflake

Engenheiro de Dados Associado no Snowflake

Field Data Engineer

What are subqueries?

Subqueries and FROM

Before a subquery

After a subquery

WHERE ... IN ( ... )

WHERE ... IN( ... )

Let's practice!

https://s3.amazonaws.com/assets.datacamp.com/production/course_40931/subtitles/course_40931_4a08b8a15ee5108be67289b816fd747b.vtt

Manipulating Data with Subqueries and Common Table Expressions - Subqueries

Subqueries

Create Your Free Account