Advanced Oracle PL/SQL (and SQL) for Data Warehousing ETL
| Course Code: | OWHPSQ |
| Currency: | 10g & 11g |
| Duration: | 4 days (hands-on machine workshop) |
| Audience: | ETL developers, PL/SQL programmers and DW architects. |
| Prerequisites: | Completion of our course Data Warehouse Terms, Concepts & Architecture or equivalent knowledge. |
| Summary: | After reviewing data warehousing and extract, transform and
load (ETL) basics, the instructor presents the full range of
advanced PL/SQL and SQL features which may be incorporated
as part of the DW ETL application solution. Skills related to
these features are developed in the delegates through realworld
examples, hands-on labs, exercises, etc. Among the ETL topics explored are:
|
| Objectives: | Upon completion of this presentation, the delegates should be able to exploit the advanced features of PL/SQL and SQL when carrying out their data warehousing ETL requirements. And the delegate should be qualified to choose optimal PL/SQL and SQL when faced with competing alternatives. |
 Detailed Outline |
Course Outlines
Detailed course outlines are available in PDF format.
Download Adobe's Acrobat Reader free from:
www.adobe.com
