Save On Training Technical Help
 
866.762.3990
Certification
Server Technologies
Microsoft Server

MS SQL Server

SQL Server 2000
2030
2071
2072
2073
2074
2092
2093
2591
SQL Server 2005
2779
2780
2781
2782
2783
2784
2786
MS SQL Server Support

MS Sharepoint

Microsoft Exchange

Network Technologies
Accounting Software
Multimedia Software
Office Software
Save On Support
Accounting Software
2591 Implementing Replication Using Microsoft SQL Server 2000
Introduction



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

Course Description:

This three-day instructor-led course provides students with the knowledge and skills to plan, deploy, administer, manage, and troubleshoot complex replication designs over a variety of communication topologies. The course reviews SQL Server replication and then focuses in detail on snapshot, transactional, and merge replication as well as topics related to Enterprise-level replication

Objectives:

  • Describe replication
  • Implement replication
  • Implement snapshot replication
  • Implement transactional replication
  • Implement merge replication
  • Implement replication in an Enterprise environment
Live chat by SightMax
Additional Training Courses at SOT


Sharepoint 2007 Logo

Server 2003 Logo

Exchange Server


Why SOT?
Quality
Price
Service

Course Outline

Lesson 1: Exploring Replication

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

Lesson 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

Lesson 3: Implementing Snapshot Replication

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

Lesson 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

Lesson 5: Implementing Merge Replication

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

Lesson 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

Home | About Us | Privacy Policy | Resources | Contact | Resource Sites
| (866) 762-3990 |
Copyright © 2009 saveontraining.com™