Data Warehousing Fundamentals Part 2: Building and Deploying

Oracle Data Warehousing Fundamentals: Building and Deploying introduces the concepts and strategies necessary to build and deploy a data warehouse successfully across the enterprise. This CBT course provides students with an overview of fundamental data warehousing concepts in both business and technical terms. In addition this course examines a variety of data warehouse architectures building and deploying strategies and it describes why data warehousing is critical to many businesses and industries today.

This is primarily online training This is an online eLearning or CBT training program Contact Serebra Learning Corporation for more information

Duration: 8 hours Training Presented in: English

Audience

This data warehouse CBT course is ideal for Managers Database Administrators and Technical Staff who need an introduction to fundamental data warehousing concepts strategies and benefits.

Objective

• Define fundamental data warehouse concepts.
• Identify the data extraction data transformation and data transportation (ETT) process.
• Identify data loading and data refreshing strategies.
• Define fundamental Metadata concepts and strategies.
• Identify how to provide access to the data warehouse.
• Identify business intelligence decision support system and data mining techniques.
• Identify how to manage the data warehouse environment.

Topics Include

Unit 1: Building a Data Warehouse

• Defining data warehouse concepts.
• Extracting data from disparate data sources.
• Transforming data to a clean and consistent form.
• Transporting data to the data staging area and the data warehouse.

Unit 2: Loading and Refreshing Warehouse Data

• Loading data to the data warehouse.
• Refreshing warehouse data.
• Evaluating available tools used to refresh warehouse data.

Unit 3: Defining Metadata Fundamentals

• Defining Metadata concepts.
• Managing Metadata.

Unit 4: Providing Access to the Data Warehouse

• Deploying the data warehouse.
• Supporting the data warehouse users.

Unit 5: Managing the Data Warehouse

• Managing changes that occur in the data warehouse environment.
• Managing growth of the data warehouse.
• Managing a backup and recovery strategy.
• Managing and evaluating the performance of the data warehouse.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media

• Data Warehousing Fundamentals Part 1: Designing and Planning