Oracle Database 11g: Administer a Data Warehouse

Kursbeschreibung

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.

Kategorie

Oracle 11g Datenbank Advanced Administration

Sprache Unterlagen

English