Oracle9i: Data Warehouse Administration

What you will learn:

With the help of business intelligence, companies are learning more about their best customers, their supply chains and product life cycles--to the benefit of the bottom line. Accurate business intelligence can lead to competitive advantage, and people who know how to administer such a system play a critical role in its success.

This course is intended for database administrators, system administrators, and database application developers who design, maintain, and use data warehouses. The main topics are: Parallel execution, ETL (Extraction, Transformation, and Loading), materialized views, and star schema optimization. In order to attend this course, you need to be familiar with relational database concepts, basic data warehouse notions, Oracle9i server concepts including application and server tuning, and the operating system environment under which you are running Oracle. Note that this course does not cover Real Application Clusters; that is done in a separate course.

This course counts towards the Hands-on course requirement for the Oracle 9i Database Administrator and Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.