Congratulations!

Cleaning Data in SQL Server Databases

Miriam Antona

Software Engineer

Chapter 1

• Why cleaning data is important
• Removing blank spaces at the beginning and end of a string
• Filling numbers with leading zeros
• Unifying strings
• Similarity between strings

Chapter 2

• Deal with missing data
• Avoid duplicate data
• Work with different formats of dates

Chapter 3

• Deal with out of range values and inaccurate data
• Converting data with different types
• Matching patterns

Chapter 4

• Combine data of some columns into one
• Split data of one column into more columns
• Transform rows into columns and vice versa

Thank you!

Cleaning Data in SQL Server Databases