Oracle Database 11g: Administer a Data Warehouse - Seminar / Kurs von PROTRANET GmbH

Students learn about Oracle’s Database partitioning architecture and identify the benefits of partitioning. Students also use parallel operations to reduce response time for data-intensive operations. Participants extract, transform, and load data into an Oracle database warehouse. Students also use materialized views to improve the data warehouse performance. Students also learn how query rewrite can improve a query’s performance. Students use the SQL Access Advisor to optimize the entire workload. Finally, students learn how to tune materialized views for fast refresh and query rewrite and how to use the compression and resumable sessions features.

- Introduction - Data Warehouse Design: Overview - Partitioning Basics - Parallelism Concepts - Parallel Operations in Data Warehouses - ETL: Extraction and Transportation - ETL: Loading - ETL: Transformation - Materialized Views - Refreshing Materialized Views - Working With Dimensions - Query Rewrite - Using the SQL Access Advisor, Compression, and Resumable Sessions