Simple play icon Course
Skills

Advanced Data Cleansing in SQL Server: Techniques and Strategies

by Allen O'Neill

This course will teach you how to use Regular Expressions in SQL Server to both identify data issues, and clean them up to ensure your data is fit for purpose. This is a critical part of ensuring your data is fit for the purpose intended.

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.

About the author

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

Ready to upskill? Get started