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

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 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)
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!