SQL Server Data Validation Examples: Row Counts, Duplicates, and Foreign Key Orphans
Channel: DataResearchLabs
Date: 2021-08-15

This video walks you through 7 sample data validation test cases. These table-level tests cover four flavors of row count, and three different unique and foreign key checks.
You can refactor and use in your projects.  The scripts in the demo are all out on Github along with 66 total sample validation tests along with a basic and an advanced script for automating the tests.  


------- Chapter Timestamps (click to jump forward): -----------------------------
 0:00 - Intro
 0:12 - Introducing Rule Set #1 - Row Counts
 3:39 - Introducing Rule Set #2 - Foreign & Unique Keys
 7:16 - How to Download SQL Scripts in this Video
 8:49 - The End


Downloads:
- Rule Set #1: https://raw.githubusercontent.com/DataResearchLabs/sql_scripts/main/mssql/data_validation/rule_set_01__row_counts.md
- Rule Set #2: https://raw.githubusercontent.com/DataResearchLabs/sql_scripts/main/mssql/data_validation/rule_set_02__keys.md
- Multi-Platform Data Validation Scripts: https://github.com/DataResearchLabs/sql_scripts/blob/main/data_validation_scripts.md

Watch related playlist videos: 
- https://www.youtube.com/playlist?list=PLVHoUDdbskUSlZTVZmllGTdSuvyI4LBiE


Connect with me on social media:
- LinkedIn:  https://www.linkedin.com/in/mpiercead576/
- YouTube:  https://www.youtube.com/channel/UCQciXv3xaBykeUFc04GxSXA
- GitHub:  https://github.com/DataResearchLabs


Subscribe to my YouTube Channel:
- https://www.youtube.com/channel/UCQciXv3xaBykeUFc04GxSXA?sub_confirmation=1


#MSSQL #automation #datavalidation