How to Use an Advanced Data Validation Script in SQL Server скачать в хорошем качестве

How to Use an Advanced Data Validation Script in SQL Server

This video walks you through how to use the advanced data validation script in SQL Server. It includes 66 sample test cases demonstrating one of each type of data validation check, from table level row counts, key checks, data mismatches, and heuristics to field level numeric-, date-, and text-specific checks. All the SQL validation test cases run sequentially in Oracle SQL Developer, returning the test id, the test status (pass or fail), the test description, rejection details on fail, the test execution time, the expected and actual results, and the lookup SQL necessary to view the underlying data behind the fail. Only one row is returned per validation test on success, and 1 to "n" rows are returned on fail (showing each failure up to your configured max). Results are captured in "temp" tables with a single "report" (query resultset) returned at the end. You can refactor and re-use the samples 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:07 - Overview: The Advanced Data Validation Script 0:54 - Step 1 - Download & Install Oracle SQL Developer 2:02 - Step 2 - Download & Deploy Demo Data 3:03 - Step 3 - Download & Configure Advanced Data Validation Script 3:59 - Step 4 - Review Advanced Validation Script 6:48 - Step 5 - Execute Advanced Data Validation Script 9:20 - The End Downloads: Advanced Script: https://raw.githubusercontent.com/Dat... Multi-Platform Data Validation Scripts: https://github.com/DataResearchLabs/s... Watch related playlist videos:    • SQL Server Scripts for Data Analysts   Connect with me on social media: LinkedIn:   / mpiercead576   YouTube:    / @dataresearchlabs   GitHub: https://github.com/DataResearchLabs Subscribe to my YouTube Channel:    / @dataresearchlabs   Background Music (via YouTube "always free" Audio): "Rewind" by Ofshane:    / @ofshane   #MSSQL #automation #datavalidation