Tracks/SQL Track/SQL for Real-World Data
Intermediate
6 modules · ~10h

SQL for Real-World Data

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

6 modules10 lessons24 exercises~10h
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
Content

Course modules

1

Trimming Whitespace

Remove leading and trailing whitespace from data.

2

Case Standardization

Standardize text case for consistent data.