|
|
|
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.
Top |
|
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
- 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.
Top |
|
|
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.
Top |
|
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.
Top |
|
|
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.
Top |
|
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
Top |
|
|
|
Exams:
-
There are no exams directly associated with this course
|
|
Price Options ex VAT:
Classroom Training
? |
Distance Learning
? |
eLearning Options
? |
Book Learning
? |
£
1050
(€1491)
|
£
674.00
(€957)
|
- |
No Books Supported for Course at present
|
|
|
Call Free on 0800 169 1890
Print 2 Page Flyer
Last Modified 01 May 2008
|
|
