Have you ever wondered the quickest and lowest maintenance way to solve data quality issues in SQL Server? In this course, Automating Data Cleansing in SQL Server, you’ll gain the ability to automate stored procedures and write TSQL to help improve data quality for your SQL Server environment. First, you’ll explore stored procedures. You will learn how to create, alter, and delete stored procedures. Next, you’ll discover how to use the SQL Server agent to schedule your stored procedures and data cleansing jobs. Finally, you’ll learn how to set up SQL Server alerts to let you know when data anomalies have occurred and may need your attention. When you’re finished with this course, you’ll have the skills and knowledge of using native SQL Server solutions needed to design data cleaning solutions on the platform.
Author Name: Ian Fogelman
Author Description:
Ian is a passionate cloud data engineer specializing in data management and cloud solutions and architecture. Ian loves nearly all database technology but especially Snowflake, leveraging its capabilities for building efficient data pipelines and performing complex data operations. With strong coding skills in SQL and Python, Ian is proficient in developing automation workflows using multiple ETL frameworks such as Apache Airflow. His background also includes designing robust databases and optim… more

Table of Contents

• Course Overview
  1min
• Designing Stored Procedures for Data Cleaning
  16mins
• Automating Data Cleaning
  13mins