Oracle - Course Details

OraDADW11g Oracle Database 11g: Administer a Data Warehouse

Oracle Course Description:
You will learn about Oracle’s Database partitioning architecture. You'll learn how to identify the benefits of partitioning, in addition to using parallel operations to reduce response time for data-intensive operations.

Learn To:

  • Implement partitioning.
  • Use parallel operations to reduce response time.
  • Extract, transform and load data.
  • Create, use and refresh materialized views to improve 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 rewrites.

Optimize the Entire Workload

This course will also teach you how to use SQL Access Advisor to optimize the entire workload. You'll also explore using the compression and resumable sessions features.

Extract, Transform & Load Data

Expert Oracle University instructors will also teach you how to extract, transform and load data into an Oracle database warehouse. You'll use materialized views to improve data warehouse performance and learn how query rewrites can improve performance.
Oracle Course Duration:
4 Days Training
Oracle Course Target Audience:
Application Developers, Data Warehouse Administrator, Data Warehouse Developer, Database Administrators, Support Engineer, Technical Consultant
Oracle Course Prerequisite:
Ability to read and understand execution plans, Good working knowledge of SQL and in data warehouse design and implementation, Data Warehouse design, implementation, and maintenance exp
Course Content:
  • Data Warehouse Design: Overview

  • Data Warehouse Tuning Considerations

  • 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