|
Provided by: 123-CBT Computer Based Training Introduction to Data Warehousing |
 |
Training
Provided by 123-CBT Computer Based Training
Course Overview
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.
Learn To:
- 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.
Content Emphasis
Skills-Based
Audience
Application developers, business analysts, database administrators, managers, project managers, and system analysts. Participants should have a business-level understanding of Oracle technology.
Total Learning Time
7 - 8 Hour(s)
Course Contents
Unit 1: Basic Concepts of Data Warehousing
Duration: 2 Hour(s)- 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
Duration: 2 Hour(s)- 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
Duration: 2 Hour(s)- 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
Duration: 1 - 2 Hour(s)- 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.
|
|
||||||||||
Introduction to Data Warehousing
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6.10
- Access 2003
- Acrobat 6.0
- ASP
- ASP.NET
- C
- Captivate 1.0
- Crystal Reports 8.5
- Crystal Reports v10
- Dreamweaver MX
-...
