Training Classes | Learning and Development Resources | Training Directory | New Training Seminars | New Training Providers | Site Map | Promote Training Seminars | Training Keywords | Training Seminars | Training Providers | Regions | Training Search | Advertise Training Seminars | Login
Provided by: 123-CBT Computer Based Training

SQL Server 7 0 Designing and Implementing Data Warehouses - Part 2

Click here for more information or to take this course
123-CBT Computer Based Training


Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by 123-CBT Computer Based Training

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)
Custom Search

Training Directory | New Training Seminars | New Training Providers | Search | Site Map | Promote Training | Login | Links


Connecting people who want to learn with people who love to teach
 Are you a Microsoft training provider?
You could be on this page today - for FREE!