SQL Foundations: Data Transformation

Write smarter queries with CASE WHEN, calculated columns, NULL handling, and string/date functions.

~8h total

5 lessons

~2h content

Pro Access

⭐ Certificate of completion

No setup required · 100% browser-based

What You'll Learn

Use aliases to rename columns and tables

Create calculated columns with expressions

Apply CASE WHEN for conditional logic

Handle NULL values with COALESCE and IS NULL

Use basic string and date functions

5 lessons · ~145 minutes

Aliases & Calculated Columns

25 min

Code-Along

CASE WHEN Logic

35 min

Code-Along

NULL Values & COALESCE

25 min

Code-Along

String Functions

30 min

Code-Along

Date Functions

30 min

Code-Along

PostgreSQLBrowser SQL Editor

Continue Your Journey

Learn the core SQL skills needed to query, summarise, and combine relational data with confidence.