Oracle Data Validation Best Practices

This video walks you through 6 data validation best practices with examples. One example shows you how to go beyondteh default status values of "Pass" and "Fail" to implement "Skip" and "Warn". The second example shows how and why to validation tests to just the recent data, not all data (no point in re-testing unchanged data over and over). The third example shows howto ignore known bad data to preclude fails. The fourth example shows how to bundle many field level tests into a single "table-scan" pass (rather than dozens of individual table scans) to improve performance. The fifth example shows how to use config tables to parameterize variables into your script. Finally, the sixth best practice has no code but rather a discussion about how best to layout your test cases.

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:08 - Rule Set #9 - Defect Regresion
0:35 - Overview of the Best Practices
1:05 - Demo: T062 - Warn and Skip
2:25 - Demo: T063 - Limit to Recent Data
3:26 - Demo: T064 - Ignore Bad Data
4:25 - Demo: T065 - Single Table Scan Pass
6:58 - Demo: T066 - Config Tables to Parameterize
8:52 - Demo: T067 - Suggested Layout
10:38 - How to Download SQL Scripts in this Video
11:50 - The End


Downloads:
- Rule Set #9: https://github.com/DataResearchLabs/sql_scripts/blob/main/oracle/data_validation/rule_set_09__defect_regression.md
- Best Practices: https://github.com/DataResearchLabs/sql_scripts/blob/main/oracle/data_validation/best_practices.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