Oracle Data Validation Examples: Row Counts, Duplicates, and Foreign Key Orphans
Channel: DataResearchLabs
Date: 2021-06-29

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:13 - Introducing Rule Set #1 - Row Counts
 0:35 - Demo: T001 - "Full" Row Count
 1:02 - Demo: T002 - "Partial" Row Count
 1:24 - Demo: T003 - "Relative" Row Count
 2:44 - Demo: T004 - "Recent" Row Count
 3:32 - Introducing Rule Set #2 - Foreign & Unique Keys
 4:09 - Demo: T005 - Unique Key Has No Duplicates
 5:43 - Demo: T006 - Foreign Key Children Are Not Orphans
 6:52 - Demo: T007 - Foreign Key Parents Aer Not Childless
 8:01 - How to Download SQL Scripts in this Video
 9:22 - The End


Downloads:
- Rule Set #1: https://raw.githubusercontent.com/DataResearchLabs/sql_scripts/main/oracle/data_validation/rule_set_01__row_counts.md
- Rule Set #2: https://raw.githubusercontent.com/DataResearchLabs/sql_scripts/main/oracle/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=PLVHoUDdbskURXEfHF6s8vZo9oSx4JPkcF


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


Background Music (via YouTube "always free" Audio):
- "Rewind" by Ofshane:  https://www.youtube.com/channel/UC34Wh4ysdP50H-ThbZFFfsA


#Oracle #automation #datavalidation