Public concerné

Application Developers, Data Warehouse Administrator, Data Warehouse, Developer, Database Administrators, Support Engineer, Technical Consultant

Objectifs pédagogiques

- Review the basic Oracle data warehousing concepts - Use parallel operations to reduce response time for data-intensive operations - Extract, Transform, and Load data in the data warehouse - Create, use, and refresh materialized views to improve the data warehouse performance - Use Query rewrite to quickly answer business queries using materialized views - Use SQL Access Advisor and PL/SQL procedures to tune materialized views for fast refresh and query rewrite - Use the features of compression and resumable sessions

Pré-requis

- Oracle Database 11g: Administration Workshop I - Good working knowledge of data warehouse design - Ability to read and understand execution plans - Good working knowledge of SQL and in data warehouse design and implementation