After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
Course Description
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.
Feels like what you want to learn?
Start Course for FreeWhat you'll learn
- Apply conditional logic to categorize and transform data within a query.
- Construct complex conditional expressions that handle multiple scenarios and edge cases.
- Analyze datasets by combining conditional logic with aggregation and multi-table joins.
- Use subqueries to filter and integrate data from multiple sources.
- Design modular, readable queries using Common Table Expressions.
Prerequisites
Curriculum
Course outline
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.
- Data manipulation in Snowflake50 XP
- Explore the Store data100 XP
- Is this a premium song?100 XP
- Conditional logic with CASE statements50 XP
- Inferring purchase quantity100 XP
- Is this a long song?100 XP
- Determining buyer intent100 XP
- Applying conditional logic in Snowflake50 XP
- Comparing invoice totals100 XP
- Validating data quality100 XP
- How many protected files?100 XP
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.
S
Data Manipulation in Snowflake
Course
Complete
