Main Office: | 800.631.0410 | |
---|---|---|
Sales Office: | 800.533.3893 |
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.
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.
ETL developers, PL/SQL programmers and DW architects
Completion of our course 'Data Warehouse Terms, Concepts & Architecture' (DWHTCA) or equivalent knowledge.
Code | Course Title | Duration | Level | |
---|---|---|---|---|
DWHTCA |
Data Warehousing Terms, Concepts and Architecture |
1 Day |
I |
Details |
DWHFUN |
Data Warehousing Fundamentals |
3 Days |
I |
Details |
ORPTDW |
Oracle 11g SQL Performance Tuning for Data Warehouses |
4 Days |
II |
Details |
DWHWPT |
DB2 Data Warehousing Performance And Tuning Workshop |
4 Days |
II |
Details |
ORDWA |
Oracle Database 11g: Administer a Data Warehouse |
5 Days |
II |
Details |
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.