Tracks/SQL Track/SQL for Real-World Data
Intermediate

SQL for Real-World Data

Handle messy, inconsistent real-world data with SQL string functions, NULL handling, and data cleaning techniques.

6
Modules
10
Lessons
24
Exercises
~10h
Duration
String cleaning (TRIM, UPPER, LOWER)NULL handling (COALESCE, NULLIF)String manipulation (SUBSTR, REPLACE)Pattern matching (LIKE)Deduplication techniques
Start Course

Recommended Prerequisites

sql for analysis
1

Trimming Whitespace

Remove leading and trailing whitespace from data.

210m
2

Case Standardization

Standardize text case for consistent data.

212m