Implementing Replication Using Microsoft SQL Server 2000
Program Outline
Module 1: Exploring Replication
This module provides an overview of replication replication setup describes the function of replication agents and replication security.
Lessons
Understanding SQL Server ReplicationSetting up ReplicationUnderstanding Agents in ReplicationSecuring ReplicationAfter completing this module students will be able to:
Define replication.Set up replication.Describe the functions of replication agents.Security-enhanced replication.
Module 2: Implementing Replication
This module describes the SQL Server platform for replication and discusses how to replicate data and objects and design and troubleshoot a replication type.
Lessons
Understanding the SQL Server Platform for ReplicationReplicating Data and ObjectsReplicating and Executing ObjectsDesigning a Replication TopologyTroubleshooting a Replication ImplementationLab 2: Implementing Replication
Determining the Replication TypeImplementing Snapshot ReplicationImplementing Transactional ReplicationImplementing Merge ReplicationRemoving Subscriptions and PublicationsAfter completing this module students 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.
Module 3: Implementing Snapshot Replication
This module explains how to plan deploy administer and troubleshoot snapshot replication.
Lessons
Understanding Snapshot Replication ArchitectureReplicating Snapshot Publications EfficientlyTroubleshooting Snapshot ReplicationLab 3: Implementing Snapshot Replication
Using Snapshot Replication with Custom PropertiesAfter completing this module students will be able to:
Describe the architecture of snapshot replication.Replicate snapshot publications efficiently.Troubleshoot snapshot replication.
Module 4: Implementing Transactional Replication
This module explains how to plan deploy and troubleshoot and tune transactional replication.
Lessons
Understanding Transactional Replication ArchitectureReplicating with Transactional ReplicationImplementing Updatable Transactional ReplicationFacilitating Transactional Replication by Using Stored ProceduresTroubleshooting Transactional ReplicationTuning Transactional ReplicationLab 4: Implementing Transactional Replication
Designing a Transactional Replication SolutionAfter completing this module students 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.
Module 5: Implementing Merge Replication
This module explains how to plan deploy and troubleshoot and tune merge replication.
Lessons
Understanding Merge Replication ArchitectureImplementing Conflict ResolutionPlanning and Deploying Merge ReplicationTroubleshooting Merge ReplicationTuning Merge ReplicationLab 5A: Implementing Merge Replication
Using Dynamic and Join Filters with Merge ReplicationAfter completing this module students will be able to:
Describe the architecture of merge replication.Implement conflict resolution.Plan and deploy merge replication.Troubleshoot merge replication.Tune merge replication.
Module 6: Implementing SQL Server Replication in an Enterprise Environment
This module explains how to design replication for heterogeneous database systems and implement Enterprise replication scenarios including backing up and restoring database systems.
Lessons
Planning for Disaster Recovery in a Replicated EnvironmentUpgrading and Applying Service Packs in a Replicated EnvironmentUnderstanding Enterprise Options in a Replicated EnvironmentUnderstanding Replication with Heterogeneous Database SystemsAfter completing this module students will be able to:
Plan disaster recovery for replication.Upgrade and apply service packs in a replicated environment.Understand key options concerning replication in some enterprise environments.Understand replication with heterogeneous database systems.
Related Exams
There are no Microsoft Certified Professional Exams associated with this course.
Student Pre-Requisites
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
Student Materials
The student kit includes a comprehensive workbook and other necessary materials for this class.
Program Goals
After completing this course students will be able to:
Describe replication.Implement replication.Implement snapshot replication.Implement transactional replication.Implement merge replication.Implement replication in an Enterprise environment.
