|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 Designing Implementing Data Warehouses - Part 1 |
 |
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)- Identify the guidelines to finalize the scope of a data warehouse project.
- Identify the business drivers that necessita
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
