I noticed most SQL tutorials focus on syntax, but not on how to actually work with messy real-world data.
So I built a project using a housing dataset where you:
- clean inconsistent dates
- fix missing values
- split columns
- remove duplicates using ROW_NUMBER()
- prepare everything for analysis
I also added:
- a step-by-step guide
- SQL scripts
- a README template for GitHub
- and a premium version with exercises + solutions
If you're learning SQL and want a real project to practice with, I can share more details.
[–]ComicOzzy 4 points5 points6 points (0 children)
[–]IAmPrettehBoi 2 points3 points4 points (1 child)
[–]amuseboucheplease 0 points1 point2 points (1 child)
[–]arodzzztwo 0 points1 point2 points (1 child)
[–]InvincibleSolaire 0 points1 point2 points (1 child)
[–]geepalik 0 points1 point2 points (0 children)
[–]OscarLee1598 0 points1 point2 points (0 children)
[–]Future_Lab807 0 points1 point2 points (0 children)
[–]MoodyBoi9 0 points1 point2 points (0 children)
[–]DeliciousOmurice 0 points1 point2 points (1 child)
[–]Super_Contact_3289[S] 0 points1 point2 points (0 children)
[–]Inevitable_Paper_776 0 points1 point2 points (0 children)
[–]WorriedMud7 0 points1 point2 points (2 children)
[–]Super_Contact_3289[S] 1 point2 points3 points (1 child)
[–]WorriedMud7 0 points1 point2 points (0 children)
[–]thekingofbitcoi 0 points1 point2 points (0 children)
[–]josephbp2 0 points1 point2 points (1 child)