Ga naar hoofdinhoud
HomeSnowflake

Cursus

Data Manipulation in Snowflake

BasisVaardigheidsniveau
Bijgewerkt 01-2026
Master data manipulation and analysis techniques such as CASE statements, subqueries, and CTEs in Snowflake.
Start Cursus Kosteloos
SnowflakeData Manipulation2 u7 videos25 Opdrachten2,150 XP4,546Prestatieverklaring

Maak je gratis account aan

of

Door verder te gaan accepteer je onze Gebruiksvoorwaarden, ons Privacybeleid en dat je gegevens worden opgeslagen in de VS.

Geliefd bij leerlingen van duizenden bedrijven

Group

Wil je 2 of meer mensen trainen?

Probeer DataCamp for Business

Cursusbeschrijving

Transform and categorize data

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.

Build subqueries and Common Table Expressions (CTEs)

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.

Vereisten

Introduction to Snowflake SQL
1

Conditional Logic

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.
Hoofdstuk Beginnen
2

Manipulating Data with Subqueries and Common Table Expressions

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.
Hoofdstuk Beginnen
Data Manipulation in Snowflake
Cursus
voltooid

Verdien een prestatieverklaring

Voeg deze referentie toe aan je LinkedIn-profiel, cv of curriculum vitae
Deel het op sociale media en in je functioneringsgesprekSchrijf Je Nu in

Sluit je aan bij meer dan 19 miljoen leerlingen en start vandaag nog met Data Manipulation in Snowflake!

Maak je gratis account aan

of

Door verder te gaan accepteer je onze Gebruiksvoorwaarden, ons Privacybeleid en dat je gegevens worden opgeslagen in de VS.

Ontwikkel je datavaardigheden met DataCamp voor Mobiel

Maak vooruitgang onderweg met onze mobiele cursussen en dagelijkse 5-minuten programmeeruitdagingen.