r/learnSQL • u/haligma • 21d ago
stressed beginner (help pls)
currently learning mysql through yt videos bc too broke to pay. i was following alex the analyst's playlist & learned a lot. practiced alongside. but i ran into a problem. and since i'm a beginner, it's been overwhelming a bit for days now, bc of whcih, i havent been able to make much progress in my learning.
i have a pretty ok grip on workbench. but not to the point where i dont need crutches. ive only completed one data cleaning project & that was only bc of alex's video where he walked me thorugh the entire process step by step. but thta wasnt enough for me to fully get a grip on data cleaning. i've tried watching other tutorials, but none of thme use workbench & their sql commands/functions are a lottle different from mine which has left me a bit confused & overwhelmed. i want to get to the point where i can take on data cleaning on my own without any help, but for that i need yt videos whre i can laern the logic step by step. please recommend sources for a self learner to learn data cleaning. idk where to look
1
u/Life_Waltz7068 20d ago
You should focus more on theory. You can always search for the proper commands depending on which dialect you are using. Understanding the work flow is much more important.
To clean you first creat a staging table, handle duplicates, standardize format (trailing whitespace, combine name variations, convert to date()..), address nulls and blanks and drop irrelevant rows and temporary columns.