Featured resource
pluralsight tech forecast
2025 Tech Forecast

Which technologies will dominate in 2025? And what skills do you need to keep up?

Check it out
Hamburger Icon
  • Course
    • Libraries: If you want this course, consider one of these libraries.
    • Data

Advanced Data Cleansing in SQL Server: Techniques and Strategies

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.

 Allen O'Neill - Pluralsight course - Advanced Data Cleansing in SQL Server: Techniques and Strategies
by Allen O'Neill

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.

Table of contents

About the author

 Allen O'Neill - Pluralsight course - Advanced Data Cleansing in SQL Server: Techniques and Strategies
Allen O'Neill

Allen is a chartered engineer with a background in enterprise systems. A Microsoft MVP, he writes for CodeProject, C-SharpCorner and DZone. Core technology interests are Big Data and Machine Learning, using these to create intelligent agents for the web. He is also a ball throwing slave to his family dogs.

More Courses by