Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Advanced Data Cleansing in SQL Server: Techniques and Strategies

via Pluralsight

Overview

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.

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.

Syllabus

  • Course Overview 1min
  • Understanding Regular Expressions in SQL Server 17mins
  • Implementing Regular Expressions for Production in SQL Server 11mins

Taught by

Allen O'Neill

Reviews

Start your review of Advanced Data Cleansing in SQL Server: Techniques and Strategies

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.