MS SQL Server 2000: Design and Implementation Part 1: Introduction to SQL Server

Outline

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

Description

This course deals with transferring data, managing replication services, and maintaining high availability.

Audience

Candidates for this exam operate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. General categories include system administrators, database administrators, application developers, systems analysts, and software engineers. Students are expected to have an understanding of basic relational database concepts. Students should be familiar with basic transact-SQL syntax. (Microsoft Course 2071: Querying Microsoft SQL Server 2000).

Prerequisites

(Currently no course prerequisite information)

Objective

• Identify guidelines for importing and exporting data.
• Match SQL Server 2000 tools used to import and export data with their functions.
• Identify the features and functions of the Data Transformation Services (DTS) process.
• Identify the features of distributed data.
• Identify the different methods of distributing data.
• Identify the features of the publishersubscriber metaphor.
• Identify the features of the Database Maintenance Plan Wizard.
• Troubleshoot a database by using the Database Consistency Checker (DBCC).
• Identify the guidelines for performing a Database Consistency Checker (DBCC) SHOWCONTIG.

Topics Include

Unit 1: Transferring Data

• Identify tasks that can be defined within a Data Transformation Services (DTS) package.
• Identify guidelines for creating a Data Transformation Services (DTS) package.
• Import data into SQL Server 2000 by using the Bulk Insert Task.
• Import data from a Transact-SQL (T-SQL) Query.
• Modify a Data Transformation Services (DTS) package by using DTS Designer.
• Transfer SQL Server 2000 objects.
• Identify requirements for configuring linked servers.
• Identify the characteristics of XML support in Internet Information Services (IIS).
• Identify guidelines for importing and exporting data.
• Match SQL Server 2000 tools used to import and export data with their functions.
• Identify the features and functions of the Data Transformation Services (DTS) process.
• Identify the features and functions of Data Transformation Services (DTS) tools.
• Identify guidelines for managing data.
• Identify the functions of data transformation and mapping.

Unit 2: Replication Services

• Identify the features of distributed data.
• Identify the different methods of distributing data.
• Identify the features of the publisher-subscriber metaphor.
• Identify the characteristics of publications and articles.
• Match filtering methods with their functions.
• Identify the different ways of subscribing to a publication.
• Identify the features of the different replication agents.
• Match the replication types with their characteristics.
• Identify features of merge replication.
• Identify features of different physical replication models.
• Identify features of a Central Publisher/Remote Distributor model.
• Identify features of a Central Subscriber/Multiple Publishers model.
• Identify features of a Multiple Publishers/Multiple Subscribers model.
• Register a SQL Server.
• Create a publication.
• Create a subscription.
• Verify that a change to a published article has been updated on the subscriber.

Unit 3: Maintaining High Availability

• Identify the features of the Database Maintenance Plan Wizard.
• Troubleshoot a database by using the Database Consistency Checker (DBCC).
• Identify the guidelines for performing a Database Consistency Checker (DBCC) SHOWCONTIG.
• Identify the features of Windows clustering.
• Identify the features of SQL Server 2000 failover clustering.
• Identify the features of active/passive clustering.
• Identify the features of active/active clustering.
• Identify the considerations for failover clustering.
• Identify the features and functions of standby servers and log shipping.
• Sequence the steps to prepare the Primary and Standby servers.
• Identify the guidelines for configuring log shipping.
• Sequence the steps to configure the Primary server.
• View the log shipping pair properties.
• Identify the characteristics of the process for changing log shipping roles.
• Change the role of the Standby server.

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.

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

Media

© Copyright Serebra Learning Corp., 2002