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) - Identify the guidelines to finalize the scope of a data warehouse project.
- Identify the business drivers that necessita
Training Avaliability and Delivery
| 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 |
|
Related Keywords:
microsoft
sql
server
7.0
designing
implementing
data
warehouses
part
Training Program Details
--
About 123-CBT Computer Based Training - Training Provider
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
-...
More Microsoft SQL Server 7 0 Training from 123-CBT Computer Based Training
Click here for more information or to take this course
| 
