EXTREME-Performance PL/SQL Data Validation Package

Focused View

Alan Austin

1:43:15

6 View

1. Introduction

1.1 PREVIEW - EXTREME-Performance PLSQL Data Validation Package including COURSE URL.docx

1. Introduction.mp4

06:23

2. Required Resources

1.1 Required Resources.docx

1. LECTURE 2 - Required Resources.mp4

02:46

3. LECTURE 3 Data Migration Overview

1.1 Data Migration Overview.docx

1. LECTURE 3 Data Migration Overview.mp4

05:03

4. LECTURE 4 Anatomy of a PLSQL package

1.1 Anatomy of a PLSQL Package - Visio screenshot.docx

1.2 Quiz - Anatomy of a package.docx

1. LECTURE 4 Anatomy of a PLSQL package.mp4

13:05

5. LECTURE 5 Creation of Supporting Tables

1.1 customer addresses staging table creation script plus data.zip

1.2 data val report cols table creation script.zip

1.3 error log table creation script - no data.zip

1.4 LECTURE 5 - Creation of Supporting Tables - Data Loading.docx

1.5 Test Data for Validation.xlsx

1. LECTURE 5 Creation of Supporting Tables.mp4

14:39

6. LECTURE 6 Package Body Details - Description - Explanation - Coding

1.1 data validation package body v5.zip

1.2 data validation package spec v5.zip

1.3 Extreme Performance-Tuning TIPS.docx

1. LECTURE 6 Package Body Details - Description - Expalnation - Coding.mp4

18:22

2. SQL Quiz.html

3. PLSQL Quiz.html

7. LECTURE 7 Reporting

1.1 Data Validation Error Reports code.txt

1.2 LECTURE 7 Error Reporting.docx

1.3 The UNION statement.pdf

1. LECTURE 7 Reporting.mp4

04:22

8. LECTURE 8 Testing Considerations

1.1 LECTURE 8 -Testing Considerations.docx

1. LECTURE 8 Testing Considerations.mp4

05:48

9. LECTURE 9 Modification to Suit Your Requirements

1.1 LECTURE 9 - Modification to Suit your Requirements.docx

1. LECTURE 9 Modification to Suit Your Requirements.mp4

07:03

10. LECTURE 10 References

1.1 LECTURE 10 - References.docx

1. LECTURE 10 References.mp4

05:14

11. LECTURE 11 Conclusion

1.1 SMILE.docx

1. LECTURE 11 Conclusions, Usage and THANK YOU !!!!.mp4

06:45

12. LECTURE 11 Conclusion

1. TEMP FILLER - This section to be deleted or UNPUBLISHED after review.mp4

02:45

2. LECTURE 7 Reporting.mp4

02:45

3. LECTURE 7 Reporting.mp4

02:45

4. LECTURE 7 Reporting.mp4

02:45

5. LECTURE 7 Reporting.mp4

02:45

Description

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

What You'll 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

Who is this 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

What You Need to Know?

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

More details

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 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

User Reviews

Rating

average 0

Total votes0

Focused display

Pl/SQL

Alan Austin

Instructor's Courses

Hi !My name is Alan.I've been an Oracle Techno-Functional Consultant for about 20 years, specializing in Data Migration, Interfaces and Data Validation. I have enthusiastically served as a Technical or Data Validation Lead on seven Oracle Upgrade or Implementation projects managing and coordinating Technical and Functional resources, both On-Shore and Off-Shore, as well as performing Roll-Up-the-Sleeves SQL and PL/SQL package design, coding and performance-tuning using SQL Developer or TOAD.One of my passions is Performance-Tuning as you will discover in my "PL/SQL Data Validation" course in which the Data Validation demo processes six validations for each of 1000 records in less than one second.(And, I am going to show you how to do that).Projects have included the U.S. Marine Corps, U.S. Army, U.S. Air Force, Centers for Disease Control and Prevention and many large commercial clients.Business Process Analysis, detailed functional documentation and detailed Visio Professional Process Flows are all tightly integrated into these Data Migration efforts.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.