One of the first tasks performed when doing data analytics or sciences is to clean the dataset you’re working with. The insights you draw from your data are only as good as the data itself, so it’s no surprise that an estimated 80% of the time spent by analytics professionals involves preparing data for use in analysis.

You’ll learn techniques on how to clean messy data in SQL, which is a must-have skill for any Data Analyst or Scientist moreover I will discuss and demo different functions commonly used to clean, transform, and remove duplicate data from query outputs that may not be in the form we would like.