MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 16 Lectures ( 1h 43m ) | Size: 1.52 GB
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 processYou will understand where Data Validation fits into the Data Migration processYou will be introduced, in detail, to the Anatomy of a PL/SQL PackageProgram concepts will be explained as we review the detailed package codeLogic and coding will be explainedYou will be able to download:Code for the Data Validation Package and for Summary and Detailed Data Validation Error ReportsSupporting objects (Staging and ERROR_LOG tables)Instructions for package customizationInstructions for EXTREME-Performance TuningReferences: additional information RE SQL, PL/SQL and Performance-TuningYou will be able to provide feedback (Kudos, Gripes, Suggestions)You will be able to request adviceAnd, of course, please accept My Thanks for allowing me present the "EXTREME-Performance PL/SQL Data Validation Package" to you.
