On-line training course catalogue

Implementing Replication Using Microsoft SQL Server 2000

Type of course: Classroom

Course details

Fee	£1025
Days	3
Course code	MS2591

We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.

Print this page | Download as Word document |

Overview

Please note this course is only available as a closed event.

This three-day instructor-led course provides students with the knowledge and skills to plan, deploy, administer, manage, and troubleshoot complex replication designs over a variety of communication topologies. The course reviews SQL Server replication and then focuses in detail on snapshot, transactional, and merge replication as well as topics related to Enterprise-level replication.

Who should attend

This course is intended for experienced database administrators and system architects who want to improve their skills and the replication capabilities of their systems. Students should be proficient in the design and administration of SQL Server 2000 systems.

Prerequisites

Before attending this course, students must have:

• Completed Course 2071?Querying Microsoft SQL Server 2000 with Transact-SQL, or equivalent knowledge.
• Completed Course 2072?Administering a Microsoft SQL Server 2000 Database, or equivalent knowledge.
• Knowledge of Microsoft Windows® 2000 basics.
• Knowledge of Windows networking fundamentals.

In addition, it is recommended, but not required, that students have completed, or have equivalent knowledge of:

• Course 2073?Programming a Microsoft SQL Server 2000 Database

Delegates will learn how to

• Describe replication.
• Implement merge replication.
• Implement replication in an Enterprise environment.
• Implement replication.
• Implement transactional replication.
• Implement snapshot replication.

Outline

Module 1: Exploring Replication

• Understanding SQL Server Replication
• Setting up Replication
• Understanding Agents in Replication
• Securing Replication

Module 2: Implementing Replication

• Understanding the SQL Server Platform for Replication
• Replicating Data and Objects
• Replicating and Executing Objects
• Designing a Replication Topology
• Troubleshooting a Replication Implementation

Module 3: Implementing Snapshot Replication

• Understanding Snapshot Replication Architecture
• Replicating Snapshot Publications Efficiently
• Troubleshooting Snapshot Replication

Module 4: Implementing Transactional Replication

• Understanding Transactional Replication Architecture
• Replicating with Transactional Replication
• Implementing Updatable Transactional Replication
• Facilitating Transactional Replication by Using Stored Procedures
• Troubleshooting Transactional Replication
• Tuning Transactional Replication

Module 5: Implementing Merge Replication

• Understanding Merge Replication Architecture
• Implementing Conflict Resolution
• Planning and Deploying Merge Replication
• Troubleshooting Merge Replication
• Tuning Merge Replication

Module 6: Implementing SQL Server Replication in an Enterprise Environment

• Planning for Disaster Recovery in a Replicated Environment
• Upgrading and Applying Service Packs in a Replicated Environment
• Understanding Enterprise Options in a Replicated Environment
• Understanding Replication with Heterogeneous Database Systems