Microsoft SQL Server 7.0: Designing and Implementing Data Warehouses - Part 5

Course Code NGE72774

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

This is the final 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 features of the components of Microsoft Repository; perform the tasks related to managing a Microsoft SQL Server 7.0 data warehouse; and perform the tasks related to database maintenance in Microsoft SQL Server 7.0.

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 four courses in this series.

Prerequisites

(Currently no course prerequisite information)

Objective

• Identify the features of the components of Microsoft Repository.
• Perform the tasks related to managing a Microsoft SQL Server 7.0 data warehouse.
• Perform the tasks related to database maintenance in Microsoft SQL Server 7.0.

Topics Include

Unit 1: Microsoft Repository

• Match the components of Microsoft Repository architecture with their functions.
• Identify the benefits of Microsoft Repository.
• Save a DTS Package in Microsoft Repository.
• Identify the benefits of metadata.
• Identify the characteristics of the types of metadata.
• Import metadata from a Microsoft Access database into Microsoft Repository by using Enterprise Manager.
• Display data lineage by using the metadata browser.
• Identify the benefits of Type Information Model.
• Identify the benefits of Open Information Model.
• Identify the benefits of Unified Modeling Language Model.
• Identify the benefits of Database Model.
• Identify the benefits of Data Type Model.
• Identify the benefits of SQL Server model.
• Identify the benefits of Database Transformation Model.
• Identify the benefits of OLAP Model.

Unit 2: Data Warehouse Management

• Identify the features of dynamic resource management in Microsoft SQL Server 7.0.
• Set the parameters to optimize the memory used by Microsoft SQL Server 7.0.
• Match the system databases with their features.
• Identify the server management features available in Microsoft SQL Server 7.0.
• Identify the features of multiserver administration in Microsoft SQL Server 7.0.
• Register a remote server by using the Register Server Wizard.
• Create a master server by using the Make Master Server Wizard.
• Create a target server by using the Make Target Server Wizard.
• Identify the authentication features in Microsoft SQL Server 7.0.
• Create a login by using the Create Login Wizard.
• Create roles in Microsoft SQL Server 7.0.
• Identify the encryption features of Microsoft SQL Server 7.0.
• Identify the security features available in Windows NT that can be used by Microsoft SQL Server 7.0.

Unit 3: Data Warehouse Maintenance

• Create a complete backup of a database in Microsoft SQL Server 7.0 by using the Backup Wizard.
• Restore a Microsoft SQL Server 7.0 database backup by using the shortcut menu.
• Identify the guidelines for implementing archiving procedures for a data warehouse.
• Sequence the steps for recovering a data warehouse from a disaster.
• Match the different maintenance wizards with their functions.
• Identify the functions of SQL Server Agent.
• Create a job that writes an error to Microsoft Windows NT Events Log by using the Create Job Wizard.
• Create an alert that starts a job by using the Create Alert Wizard.
• Schedule a DTS package by using the Schedule Package option.
• Schedule a backup event by using the Create Job Wizard.
• Sequence the steps for managing replication failures.
• Set up a database maintenance plan by using the Database Maintenance Plan Wizard.
• Match the performance factors with the methods to minimize their adverse impact on the performance of Microsoft SQL Server 7.0.
• Identify the server configuration settings for optimal server performance in a data warehouse environment.
• Check the database consistency of Microsoft SQL Server 7.0 components by using a Transact-SQL statement.
• Set up a trace to capture database events to a file by using SQL Server Profiler.
• Optimize the performance of indexes by using the Index Tuning Wizard.
• Generate a graphical showplan of a query by using the SQL Server Query Analyzer.
• Match the analysis reports on the query patterns of an OLAP cube with their descriptions.
• Optimize an OLAP cube by using the Usage-Based Optimizer Wizard.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently, only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media