- Home
- /
- Datenbanken
- /
- Oracle
- /
- Oracle Database 11g: Administer...
Oracle Database 11g: Administer a Data Warehouse
Schulungsinhalt
– 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
Zielgruppe
– Administrator
– Database Administrator
– Developer
– Implementer
Seminarziele
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.
Vorkenntnisse
Required Prerequisite
– Good working knowledge of SQL and in data warehouse design and implementation
– Data Warehouse design, implementation, and maintenance experience
– Ability to read and understand execution plans
Seminardauer
Preis
Präsenzseminar/FLEXINAR®:
LIVEINAR®:
Individual Training: Preis auf Anfrage
Inhouse Training: Preis auf Anfrage
Seminarnummer

Martin Heubeck
Group Leader Sales
- martin.heubeck@protranet.de
Beratungszentrale und Buchungshotline:
- 0800 3400311
- beratung@protranet.de
Kataloge
Formate