Data Manipulation in Snowflake

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.