Implementing Replication Using Microsoft SQL Server 2000

London (EC3)

06/04/10

£

1,185

Somerset

Bath (BA1)

22/03/10

£

1,185

Bath (BA1)

28/04/10

£

1,185

Please click above and we will take care of the rest.

Please click above and we will be happy to discuss the benefits of onsite and bespoke courses with you.

If suitable dates or locations are not available, click this link and we will arrange one for you

Course Overview

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

Audience

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 the following pre-requisites:

• Course 2071, Querying Microsoft SQL Server 2000 with Transact-SQL, or equivalent knowledge.
• 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.

Course Outline

1. Exploring Replication
2. Implementing Replication
3. Implementing Snapshot Replication
4. Implementing Transactional Replication
5. Implementing Merge Replication Systems
6. Implementing SQL Server Replication in an Enterprise Environment

Module 1: Exploring Replication

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

Skills

• Define replication.
• Set up replication.
• Describe the functions of replication agents.
• Secure replication.

Module 2: Implementing Replication

• Understanding the SQL Server Platform for Replication
• Replicating Data and Objects
• Replicating and Executing Objects
• Designing a Replication ology
• Troubleshooting a Replication Implementation
• Lab:
• Implementing Replication

Skills

• 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

• Understanding Snapshot Replication Architecture
• Replicating Snapshot Publications Efficiently
• Troubleshooting Snapshot Replication
• Lab:
• Using Snapshot Replication with Custom Properties

Skills

• Describe the architecture of snapshot replication.
• Replicate snapshot publications efficiently.
• Troubleshoot 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
• Lab:
• Implementing Transactional Replication

Skills

• 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 Systems

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

Skills

• 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

• 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.

Skills

• 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