SQL Data Cleaning — Coffee and coffee Are Different Values (Data Engineering Study #1)
I started studying data engineering. Two days of notes on deliberately creating a dirty CSV to see how case sensitivity and empty values break aggregations, plus the principle of never touching raw data and cleaning it in staging instead, and learning UPPER, CASE, and COALESCE.