Back to Search Results

Training Course Summary:

Course Overview
This course provides course participants with the knowledge and skills to plan, deploy, administer, manage, and troubleshoot complex replication designs over a variety of communication topologies.
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.

What You Will Learn

After completing this course, course participants will be able to:

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



Pre-requisites



Before attending this course, course participants must have:

Querying Microsoft SQL Server 2000 with Transact-SQL or equivalent knowledge.
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 course participants have completed, or have equivalent knowledge of Programming a Microsoft SQL Server 2000 Database.



Follow-up Courses

None


Course Content

Exploring Replication

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

After completing this module, course participants will be able to:
Define replication.
Set up replication.
Describe the functions of replication agents.
Secure replication

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

After completing this module, course participants will be able to:
Describe the SQL Server platform for replication.
Replicate data and objects.
Replicate and execute objects.
Design the best replication type for a given business problem.
Monitor, troubleshoot, and tune replication.

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

After completing this module, course participants will be able to:
Describe the architecture of snapshot replication.
Replicate snapshot publications efficiently.
Troubleshoot snapshot replication.

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

After completing this module, course participants will be able to:
Describe transactional replication.
Replicate with transactional replication.
Implement updatable transactional replication.
Facilitate transactional replication using stored procedures.
Troubleshoot transactional replication.
Tune transactional replication.

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

After completing this module, course participants will be able to:
Describe the architecture of merge replication.
Implement conflict resolution.
Plan and deploy merge replication.
Troubleshoot merge replication.
Tune merge replication

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

After completing this module, course participants will be able to:
Plan disaste