|
Provided by: Serebra Learning Corporation Introduction to Data WarehousingUnfiled |
 |
Training
Provided by Serebra Learning Corporation
This course presents an introduction to Data Warehousing. Beginning with the basic concepts of data warehousing this course helps you understand the processes involved in and the architecture of data warehousing. The tools involved in analyzing the warehouse data will also be covered. Finally you'll learn about the Oracle data warehouse.
|
|
||||||||||
Introduction to Data Warehousing
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
Audience
Application developers business analysts database administrators managers project managers and system analysts. Participants should have a business-level understanding of Oracle technology.
Objective
- Identify the basic concepts and terminology of data warehousing.
- Identify the different processes and tasks involved in an integrated warehouse environment.
- Identify the different data warehouse architectures.
- Identify the different data warehouse models.
- Identify the range of Oracle products that may be employed for a warehouse implementation.
Topics Include
Unit 1: Basic Concepts of Data Warehousing
- Identify the characteristics of a data warehouse.
- Identify the activities that users of a given database environment can perform.
- Identify the features of an operational data store (ODS). Identify the benefits of a data mart.
- Identify the business imperatives for implementing a data warehouse.
- Identify the technological imperative for implementing a data warehouse.
Unit 2: Data Warehousing Operations
- Identify the functions of the data warehouse processes.
- Identify the methods for managing the extraction process.
- Identify the tasks involved in the transformation process.
- Identify the prerequisites for the transportation of data into the warehouse.
- Identify the types of Metadata.
- Identify the factors impacting the refresh time period of the data warehouse.
- Identify the methods for capturing the changed data.
- Identify the benefits of replication for refreshing the data in the warehouse.
- Identify the storage requirements of a warehouse database.
- Identify the requirements to manage a query process in a data warehouse.
- Identify the features of Simple and Complex query types.
- Identify the functions of data mining.
Unit 3: Warehouse Architecture and Models
- Identify the features of the different data warehouse architectures: Enterprise data warehouse and Data mart.
- Identify the features of independent and dependent data marts.
- Identify the need to analyze data requirements for the warehouse.
- Identify the features of fact data.
- Identify the features of dimension data.
- Identify the features of reference data.
- Identify the features of summary data.
- Identify the features of Metadata.
- Identify the reasons for employing an enterprise model.
- Identify the features of the corporate data model.
- Sequence the steps involved in converting a corporate model to a warehouse model.
- Identify the benefits of a star schema.
- Identify the advantages of a snowflake schema.
Unit 4: Oracle Warehouse
- Match the types of computer architecture with their features.
- Match the parallel processing features with their benefits.
- Identify the features of Data Warehouse Method.
- Identify the features of Oracle7 Server that are relevant to a data warehouse environment.
- Identify the features of Express Server that are relevant to a data warehouse environment.
- Identify the benefits of the ROLAP option in a warehouse environment.
- Identify the components of the Data Mart suite.
- Match the SQL*Loader mechanisms with their functions.
- Identify the features of Gateways.
- Match the modules of Designer/2000 with their functions.
- Match the types of query techniques with their features.
- Identify the features of the Discoverer query and reporting tool.
- Match the Express Analyzer tools with their features.
- Identify the guidelines that should be followed for ensuring a successful data warehouse implementation.
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
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1, 825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
