What you'll learn

Imagine a world where every time you go to your favorite restaurant they call you by a different name, or your bank routinely sends you incorrect account balances - welcome to the world problems that can occur due to bad quality data! In this course, Advanced Data Cleansing in SQL Server: Techniques and Strategies, you'll demonstrate problems that can occur when data is invalid, and how you can use both very simple and exceedingly powerful regular expressions to ensure your data is in the best shape it can be. First, you'll identify problematic data in your datasets. Next, you'll build tests to confirm your data quality identification hypothesis. Finally, you'll monitor and evaluate the performance of your implementation. When the course is complete, you'll understand best practices for data cleansing with regular expressions for SQL server and be able to create a comprehensive strategy to implement a robust data solution in your organization.