Oracle Database 11g: Data Warehousing Fundamentals

Course details

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.

Objectives

• Define the terminology and explain the basic concepts of data warehousing
• 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
• Develop familiarity with some of the technologies required to implement a data warehouse

Course Outline:

• Introduction
• Data Warehousing, Business Intelligence, OLAP, and Data Mining
• Defining Data Warehouse Concepts and Terminology
• Business, Logical, Dimensional, and Physical Modeling
• Database Sizing, Storage, Performance, and Security Considerations
• The ETL Process: Extracting Data
• The ETL Process: Transforming Data
• The ETL Process: Loading Data
• Refreshing the Warehouse Data
• Materialized Views
• Leaving a Metadata Trail
• Data Warehouse Implementation Considerations