EXTREME-Performance PL/SQL Data Validation Package
Understand the Data Validation package logic and coding. Download and Customize to YOUR Requirements.
Ratings 0.00 / 5.00
What You Will Learn!
- Download an EXTREME-Performance PL/SQL Data Validation package
- Learn how and what to do to mold the Data Validation package to YOUR requirements
- Learn PL/SQL concepts and coding through development of a PL/SQL Data Validation package
- Learn some super-effective Performance-Tuning techniques usable in any PL/SQL development
- Learn SQL reporting techniques that do not require a separate reporting tool and display all Data Validation results including Run-Time
- Understand Data Validation in the context of Data Migration
Description
The critical nature of fully Validated Data, as "The Last Line of Defense", in preventing a Data Migration Disaster, will be described.
While you will learn about Data Migration/Validation and a lot of PL/SQL (and SQL), during this course, this is NOT primarily an academic exercise - your understanding, the provided downloads and Customization Instructions can be combined to develop an efficient, high-performance Data Validation Package, honed by you to YOUR requirements.
You will be guided through the PL/SQL Data Validation package development process
You will understand where Data Validation fits into the Data Migration process
You will be introduced, in detail, to the Anatomy of a PL/SQL Package
Program concepts will be explained as we review the detailed package code
Logic and coding will be explained
You will be able to download:
Code for the Data Validation Package and for Summary and Detailed Data Validation Error Reports
Supporting objects (including Staging and ERROR_LOG tables)
Instructions for package customization
Instructions for EXTREME-Performance Tuning
References: additional information RE SQL, PL/SQL and Performance-Tuning
You will be able to provide feedback (Kudos, Gripes, Suggestions)
You will be able to request advice
And, of course, please accept My Thanks for allowing me present the "EXTREME-Performance PL/SQL Data Validation Package" to you.
Who Should Attend!
- This PL/SQL course targets Functional Resources who want an Overview of PL/SQL and exposure to PL/SQL concepts.
- Technical Resources who want to/need ot learn PL/SQL and need a flexible Data Validation package that they can tailor to their own requirements