D56261 - Oracle Database 11g: Data Warehousing Fundamentals

Overview

Duration: 3 days

This Oracle Database 11g: Data Warehousing Fundamentals training will teach you about the basic concepts of a data warehouse. Explore the issues involved in planning, designing, building, populating and maintaining a successful data warehouse.

Learn To:

Define the terminology and explain basic concepts of data warehousing.
Identify the technology and some of the tools from Oracle to implement a successful data warehouse.
Describe methods and tools for extracting, transforming and loading data.
Identify some of the tools for accessing and analyzing warehouse data.
Describe the benefits of partitioning, parallel operations, materialized views and query rewrite in a data warehouse.
Explain the implementation and organizational issues surrounding a data warehouse project.
Improve performance or manageability in a data warehouse using various Oracle Database features.

Objectives

Upon completing this course, the learner will be able to meet these overall objectives:

Describe methods and tools for extracting, transforming, and loading data
Identify some of the tools for accessing and analyzing warehouse data
Identify the technology and some of the tools from Oracle to implement a successful data warehouse
Define the decision support purpose and end goal of a data warehouse
Describe the benefits of partitioning, parallel operations, materialized views, and query rewrite in a data warehouse
Explain the implementation and organizational issues surrounding a data warehouse project
Use materialized views and query rewrite to improve the data warehouse performance
Define the terminology and explain the basic concepts of data warehousing
Develop familiarity with some of the technologies required to implement a data warehouse

Audience

Application Developers
Project Manager
Developer
Support Engineer
Data Warehouse Analyst
Functional Implementer
Data Warehouse Developer
Data Warehouse Administrator

Content

Module 1: Introduction
Module 2: Data Warehousing, Business Intelligence, OLAP, and Data Mining
Module 3: Defining Data Warehouse Concepts and Terminology
Module 4: Business, Logical, Dimensional, and Physical Modeling
Module 5: Database Sizing, Storage, Performance, and Security Considerations
Module 6: The ETL Process: Extracting Data
Module 7: The ETL Process: Transforming Data
Module 8: The ETL Process: Loading Data
Module 9: Refreshing the Warehouse Data
Module 10: Materialized Views
Module 11: Leaving a Metadata Trail
Module 12: Data Warehouse Implementation Considerations

Prerequisites

Knowledge of general data warehousing concepts
Knowledge of client-server technology
Knowledge of relational server technology

Certification

This course is not associated with any Certification.

Schedule

Show Schedule for: