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