How to Clean Messy Data in SQL (Without Breaking Your Data)
Learn how to clean messy, real-world data using SQL, without accidentally deleting your data.
In this end-to-end SQL data cleaning crash course, we walk through the exact steps data analysts use on the job.
LINKS:
Dataset (generated by ChatGPT): https://github.com/ds-with-uj/tutoria...
Code: https://github.com/ds-with-uj/tutoria...
SQL Cheatsheet: https://dataanalyticslabs.gumroad.com...
CHAPTERS:
00:00 Intro
00:12 Dataset Overview
2:03 Check Initial Counts
03:57 Standardize Text Case
04:57 Trimming Whitespace
06:31 Transactions
09:40 Case Statements
14:30 Changing Column Data Types
16:11 Splitting Text
19:09 COALESCE()
21:17 Removing Duplicates
26:17 ROW_NUMBER()
28:03 CTEs
28:40 Delete Duplicates
32:39 Final Validation Checks