-
Course
- Data
Automating Data Cleansing in SQL Server
SQL Server offers powerful native tools for data cleansing. Without using a third-party solution for data cleansing, you can enhance data quality with TSQL. This course will teach you solutions and best practices for data cleaning in SQL Server.
What you'll learn
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.
Table of contents
About the author
Ian is a database enthusiast with particular expertise in the Microsoft data stack. Other technologies that Ian has expert level experience with include ETL, Python development, cloud architecture and systems automation. Ian holds the Microsoft Certified Solutions Expert (MCSE) for data management and analytics as well as the AWS Solution Architect associate certifications. Ian also writes for multiple technical blogs including SuperFunSQL.com which he founded in 2019.
More Courses by Ian