Oracle Database 11g: Data Warehousing Fundamentals

Product Description

In this course, students learn the basic concepts of a data warehouse & study the issues involved in planning, designing, building, populating, & maintaining a successful data warehouse. Students learn to improve performance or manageability in a data warehouse using various Oracle Database features.

Students also learn the basics about Oracle's Database partitioning architecture & identify the benefits of partitioning. Students review the benefits of parallel operations to reduce response time for data-intensive operations. Students learn about the extract, transform, & load of data phase (ETL) into an Oracle database warehouse. Students learn the basics about the benefits of using Oracle's materialized views to improve the data warehouse performance. Students also learn at a high level how query rewrite can improve a query's performance. Students review OLAP & Data Mining & identify some data warehouse implementations considerations.

Students briefly use some of the available data warehousing tools such as Oracle Warehouse Builder, Analytic Workspace Manager, & Oracle Application Express.

Learn To:

• Define the terminology & explain basic concepts of data warehousing
• Identify the technology & some of the tools from Oracle to implement a successful data warehouse
• Describe methods & tools for extracting, transforming, & loading data
• Identify some of the tools for accessing & analyzing warehouse data
• Describe the benefits of partitioning, parallel operations, materialized views, & query rewrite in a data warehouse
• Explain the implementation & organizational issues surrounding a data warehouse project

This training may be available onsite; please contact us if you are interested.