Finding Duplicates: SQL for Real-World Data | EdLight Code

SQL for Real-World DataFinding Duplicates

8 / 10In progressIn progress

0/10

SQL for Real-World Data

Course Progress0/10

1

String Cleaning Basics

Trimming Whitespace
Case Standardization

2

Handling NULL Values

Understanding NULLs

3

String Manipulation

SUBSTR and String Extraction
REPLACE for Data Cleanup

4

Data Validation

Pattern Matching with LIKE
CASE for Data Classification

5

Deduplication

Finding Duplicates
Selecting Best Record

6

Capstone Project

Capstone: CRM Data Cleanup

Loading lesson…

Loading lesson…