|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 Designing and Implementing Data Warehouses - Part 5 |
 |
Course Overview
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.
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.
- Perform the tasks related to database maintenance in Microsoft SQL Server 7.0.
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 four courses in this series.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Microsoft Repository
Duration: 2 - 3 Hour(s)- 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
Duration: 2 - 3 Hour(s)- 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
Duration: 2 Hour(s)- 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 short
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
