SQLRepPracticeGuidesPlaygroundLearning path

Practice by topic · 10 drills

Data cleaning & changes

Data quality checks, deduplication, parsing messy text, UPDATE, DELETE and upserts. Ordered easiest first.

Start: Missing values per source 0/10 solved
  1. 1. Missing values per sourceCOUNT(*) - COUNT(col) · data quality · Database AnalystPro
  2. 2. Duplicates hiding behind case and spacesLOWER · TRIM · GROUP BY · HAVING · Database AnalystPro
  3. 3. Orphaned invoicesNOT EXISTS · orphan rows · NOT IN and NULL · Database AnalystPro
  4. 4. Payments that break the rulesValidation rules · OR · NULL-safe checks · Database AnalystPro
  5. 5. Parse a text-only importTRIM · NULLIF · regexp_replace · ::numeric · ::date · Database AnalystPro
  6. 6. Standardize country namesUPDATE · INITCAP · TRIM · Database AnalystPro
  7. 7. Delete duplicate registrationsDELETE … USING · keep the lowest id · Database AnalystPro
  8. 8. Upsert a supplier price feedINSERT … ON CONFLICT DO UPDATE · EXCLUDED · Database AnalystPro
  9. 9. Reconcile billing and CRMFULL OUTER JOIN · IS DISTINCT FROM · Database AnalystPro
  10. 10. Rows that would block a constraintUNIQUE · CHECK · NULL semantics · UNION · Database AnalystPro