• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   Microsoft SQL Server Training Courses

M2591: Implementing Replication Using Microsoft SQL Server 2000

View course dates

Course Duration: 3 days

Course Code: M2591

Course Description:

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

Prerequisite courses:

M2071: Querying MS SQL 2000 with Transact SQL

M2072: Microsoft SQL Server 2000 Database Administration

M2073: Microsoft SQL Server 2000 Database Programming

This course includes the following modules:

Exploring Replication

• Understanding SQL Server Replication
• Setting up Replication
• Understanding Agents in Replication
• Securing 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

Implementing Snapshot Replication

• Understanding Snapshot Replication Architecture
• Replicating Snapshot Publications Efficiently
• Troubleshooting 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

Implementing Merge Replication

• Understanding Merge Replication Architecture
• Implementing Conflict Resolution
• Planning and Deploying Merge Replication
• Troubleshooting Merge Replication
• Tuning 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

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course