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 Implementing Data Warehouses - Part 1

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 first 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 characteristics of different decision support systems and components and tools used in data warehousing; identify the different techniques for gathering data; identify the basic requirements of the data warehouse; and identify the guidelines for determining various analysis requirements.

Learn To:

  • Identify the characteristics of different decision support systems and components and tools used in data warehousing.
  • Identify the different techniques for gathering data.
  • Identify the basic requirements of the data warehouse.
  • Identify the guidelines for determining various analysis requirements.

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.

Total Learning Time

6 - 8 Hour(s)

Course Contents

Unit 1: Data Warehousing: Basic Concepts

Duration: 2 - 3 Hour(s)
  • Sequence the phases in the evolution of DSSs.
  • Identify the benefits of online analytical processing (OLAP) technology.
  • Identify the characteristics of a data warehouse.
  • Identify the benefits of implementing a data mart.
  • Identify the business imperatives for implementing a data warehouse.
  • Identify the technical imperatives for implementing a data warehouse.
  • Match the categories under which data warehousing components can be placed with their uses.
  • Identify the source data systems in a given situation.
  • Identify the tasks performed in the data staging area.
  • Identify the features of a data warehouse database.
  • Identify the contents of metadata.
  • Match the access tools with their features.
  • Identify the features of Microsoft SQL Server 7.0 that help in data warehousing.
  • Match the Microsoft SQL Server 7.0 tools used for data warehousing with their functions.

Unit 2: Data Gathering

Duration: 2 - 3 Hour(s)
  • Identify the techniques used to gather data from users.
  • Identify the tasks involved in the shadowing technique to gather data.
  • Identify the tasks involved when interviewing users for the purpose of data collection.
  • Identify the tasks involved in gathering data during facilitated sessions.
  • Identify the tasks involved in interviewing focus groups to gather data.
  • Identify the benefits of user surveys when collecting data.
  • Identify the uses of collecting data from a help desk.
  • Identify the benefits of users teaching the project team about the various aspects of their roles during data collection.
  • Identify the guidelines for selecting interviewees who will help in gathering data warehouse requirements.
  • Identify the guidelines to conduct interviews for gathering data.

Unit 3: Analyzing Requirements

Duration: 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!