EXTREME-Performance PL/SQL Data Validation Package

Understand the Data Validation package logic and coding, Download and Customize to YOUR Requirements

What you'll learn
Dowload 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 Oracle Data Migration
Requirements
A need or desire to validate data as part of a Data Migration
For Functional Resources, no prior experience required - PL/SQL concepts will be explained.
For Technical Resources, programming knowledge and concepts, in at least one language, are expected - PL/SQL syntax and coding "Gotchya's" will be explained
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 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 (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 this course is for:
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


More Info