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

6 modules

Trimming Whitespace

Remove leading and trailing whitespace from data.

2 exercises10m

Case Standardization

Standardize text case for consistent data.

2 exercises12m

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

6 modules

Trimming Whitespace

Remove leading and trailing whitespace from data.

2 exercises10m

Case Standardization

Standardize text case for consistent data.

2 exercises12m

SQL for Real-World Data

Recommended prerequisites

Course modules

String Cleaning Basics

Trimming Whitespace

Case Standardization

Handling NULL Values

String Manipulation

Data Validation

Deduplication

Capstone Project

SQL for Real-World Data

Recommended prerequisites

Course modules

String Cleaning Basics

Trimming Whitespace

Case Standardization

Handling NULL Values

String Manipulation

Data Validation

Deduplication

Capstone Project