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.
Author Name: Allen O’Neill
Author Description:
Allen is a consulting engineer with a background in enterprise systems. He runs his own company specializing in systems architecture, optimisation and scaling. He is also involved in a number of start-ups. Allen is a chartered engineer, a Fellow of the British Computing Society, a Microsoft MVP and insider, and both a CodeProject and C-SharpCorner MVP. He is a regular speaker at events both locally and internationally. His core technology interests are Big Data, Data Science and Machine Learning… more