|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 Designing and Implementing Data Warehouses - Part 2 |
 |
Course Overview
This is the second course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. At the completion of this course, students will learn to identify the design characteristics of OLAP systems and Aggregate schemas; identify the data warehouse models; identify the Data Transformation Services (DTS) components and the components of the DTS object model; identify the methods of distributing data; and identify the replication types and techniques.
Learn To:
- Identify the design characteristics of OLAP systems and Aggregate schemas.
- Identify the data warehouse models.
- Identify the Data Transformation Services (DTS) components and the components of the DTS object model.
- Identify the methods of distributing data.
- Identify the replication types and techniques.
Content Emphasis
Skills-Based
Audience
This course series is designed for IT professionals responsible for planning, implementing, and maintaining a data warehouse using Microsoft SQL Server client/server database management system version 7.0. This series will help students prepare for the Microsoft Certified Professional exam 70-019, Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0. It is recommended that participants take NETg course series 72470-72474, Microsoft SQL Server 7.0: System Administration and course series 72475-72479, Microsoft SQL Server 7.0: Implementing a Database or have equivalent knowledge and have completed the first course in this series.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: OLAP Systems
Duration: 1 - 2 Hour(s)- Identify the reasons why OLTP systems are inadequate for decision support.
- Identify the OLAP Services features.
- Identify the features of the OLAP Services architecture.
- Match the activities in building an OLAP Data Warehouse with the tasks involved in the activities.
- Identify the advantages of aggregation.
- Select the most appropriate table to answer a given user query.
- Identify the design issues that are relevant for the design of cubes, base tables, fact tables and dimension tables.
Unit 2: The Data Warehousing Process
Duration: 1 - 2 Hour(s)- Identify the features of an enterprise data warehouse.
- Identify the situations in which you will use a data mart.
- Identify the features of an operational data store.
- Identify the features of a combination model.
- Match the logical components in a data warehouse framework with their function.
- Identify the design considerations for a data warehouse.
- Identify the activities in designing a data warehouse.
- Identify the factors that determine the frequency with which a data warehouse is refreshed.
- Identify the factors that determine the frequency with which a data warehouse is archived.
- Identify the factors that need to be considered to filter data in a data warehouse.
- Identify the features of the architectural approaches for data warehouse design.
- Identify the solution that meets the design requirements of a data warehouse for a given scenario.
- Identify the factors that determine the feasibility of implementing data warehouse architecture.
- Identify the reason based on which you will decide to use relational or multidimensional storage for a data warehouse.
- Match the approaches to data warehouse storage design with their descriptions.
- Identify the features of the elements in a star schema design.
- Identify the features of the dimensional models in dimensional modeling.
- Match e
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information Training Presented in: English
