Data Manipulation in Snowflake

Start Free Preview

Buying via our links supports this free directory · Affiliate disclosure.
Course facts
  • Payment: Free Preview (Paid Upgrade)
  • Learning style: Self-paced, start anytime
  • Format: Text & Interactive
  • Video access: Streaming Only
  • Before you start: Introduction to Snowflake SQL
DataCamp details
  • Chapters: 2
Created byDataCamp
Available onDataCamp

Course Details
Learning Style

Start Anytime

Level

Beginner

Study Mode

100% Online

Duration

Short (< 10 Hours)

Languages
Audio Language

English

Outcomes
Certificate

Certificate of Completion

Price & Terms
Pricing Model

Free Preview (Paid Upgrade)

Technical
Content Medium

Text & Interactive

Video Access

Streaming Only

Specification
Access

Subscription

SKU: data-manipulation-snowflake Category: Tags: , , , Brand:

Learn to categorize Snowflake data with CASE statements and structure multi-step queries with subqueries and common table expressions.

At a glance
Duration2 hrs
LevelBeginner
CertificateCertificate of Completion
LanguageEnglish
Taught byJake Roach
AccessSubscription
Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare

Transforming data in Snowflake here means three SQL techniques. CASE statements apply if-then logic to categorize values, with several conditions at once and an ELSE branch for edge cases. Subqueries combine the result of one query with the one you are building, and common table expressions do the same in a more organized way, keeping complex logic modular and readable. Exercises put each to work on songs, purchases and invoices.

What You Will Achieve

  • Sort table values into categories with if-then rules, including a fallback for edge cases
  • Build CASE statements with multiple conditions to label records such as premium or long songs
  • Filter a query by a result computed in a nested subquery
  • Split long, multi-step logic into named common table expressions that are easier to read and reuse


Program Overview

Conditional Logic with CASE in Snowflake

Introduces if-then logic in Snowflake SQL and applies it to songs, purchases and invoices, with results summarized through aggregation functions.

  • Exploring the store tables
  • CASE statements with one or several conditions
  • ELSE as a catch-all branch
  • Invoice comparisons and data quality checks

Subqueries and Common Table Expressions

Turns to queries built on the output of other queries, comparing nested subqueries with named CTEs that keep complex logic modular.

  • Building and nesting subqueries
  • CTEs for track length and composer analysis
  • Advanced CTEs for a detailed invoice
  • Sales by artist, album and genre

Certificate Awarded (Paid)


Job Outlook

Data analysts, data engineers and developers who work in Snowflake use these query patterns to categorize records, check data quality and build sales and customer reports.


Our take

Good for: Anyone working with data in Snowflake who wants to categorize records by rule and turn tangled multi-step queries into readable ones.

Keep in mind: The exercises use store data on tracks, invoices and customers, so the examples center on song and sales questions rather than other kinds of data.

Bottom line: A focused two-chapter course that puts CASE statements, subqueries and CTEs to work on concrete sales questions inside Snowflake.

Frequently Asked Questions

What dataset do the exercises use?

The exercises draw on a store dataset with songs, composers, artists, albums and genres alongside invoices and customers, so each technique is practiced on questions about track length, purchases and sales.

How do subqueries and common table expressions differ in this course?

Both let one query use the result of another. Subqueries place that result inside the query being written, while common table expressions name each step up front, which keeps longer logic more organized and easier to reuse.

Is data quality part of the CASE chapter?

Yes. The first chapter includes a lesson on validating data quality with conditional logic, next to exercises that compare invoice totals, infer purchase quantities and count protected files.

User Reviews

0.0 out of 5
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0

No reviews yet. Be the first to review this course.

There are no reviews yet.

Write your review

Reviews can only be posted by registered learners. Log in, then you will return here to post.

×

    Report this page
    Data Manipulation in Snowflake
    Data Manipulation in Snowflake
    LiveTalent
    Logo
    Compare items
    • Total (0)
    Compare
    0