Advanced PL/SQL (and SQL) for Data Warehousing ETL
Duration: 4 Days
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 real-world examples, hands-on labs, exercises, etc.Among the ETL 9i and 10g topics explored are:
Finally, ETL PL/SQL (and SQL) applications performance and best practices are discussed in detail, using Oracle's performance measurement tools.
The course is applicable to both Oracle 9i and Oracle 10g.
Topics Covered In This Course
ORACLE'S ETL CONSIDERATIONS
PL/SQL ADVANCED TOPICS + LAB
ORACLE WAREHOUSE BUILDER (OWB) VS. PURE PL/SQL
ETL: EXTRACTION OPTIONS + LAB
ETL: TRANSFORMATION OPTIONS + LAB
ETL: DW LOAD OPTIONS + LAB
DW INDEX DESIGN OPTIONS + LAB
PL/SQL & SQL TUNING AND BEST PRACTICES + LAB
PL/SQL & SQL TUNING TOOLS + LAB
What You Can Expect
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.
Who Should Take This Course
ETL developers, PL/SQL programmers and DW architects
Completion of our course 'Data Warehouse Terms, Concepts & Architecture' (DWHTCA) or equivalent knowledge.
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]