Implementing Replication Using Microsoft SQL Server 2000 training seminars presented by Netcom Learning register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

Implementing Replication Using Microsoft SQL Server 2000  

 Email information about this seminar Implementing Replication Using Microsoft SQL Server 2000 by Netcom Learning to yourself your manager or associates Email this event... View and register for other training seminars like Implementing Replication Using Microsoft SQL Server 2000 by Netcom Learning on FindaSeminar.com Find similar training.. Find and register for other training seminars by Netcom Learning on FindaSeminar.com Other seminars from Netcom Learning

By:

Netcom Learning   

For:

This course is intended for experienced database administrators and system architects who want to improve their skills and the replication capabilities of their systems.

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

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. (see full course description)

 

 Seminar / Training class dates & locations

 

No seminar dates for this event are currently scheduled.  Please use the seminars search box above or choose one of the following additional training search options to find similar training.

replication+database+microsoft+sql+server+topologies training seminars workshops conferences online training

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search

NEW  Don't miss training you want to attend

Receive a personal Training Alert when training you want to attend comes to your area. Create a personal Training Alert now  it's Free and only takes a minute!


 

 

 

share this page 

print the agenda print agenda for the Implementing Replication Using Microsoft SQL Server 2000 seminar

 

 

Training Course Syllabus:


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.


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

Before attending this course, students must have knowledge of Microsoft Windows® 2000 basics and Windows networking fundamentals.


 
Course Objectives
  • Describe replication.
  • Implement replication.
  • Implement snapshot replication.
  • Implement transactional replication.
  • Implement merge replication.
  • Implement replication in an Enterprise environment.

 
Recommended Prerequisites
  • 2071: Querying Microsoft SQL Server 2000 with Transact-SQL
  • 2072: Microsoft SQL Server 2000 System Administration
  • 2073: Microsoft SQL Server 2000 Database Design and Implementation

 
Course Outline
  1. Exploring Replication n
    1. Understanding SQL Server Replication
    2. Setting up Replication
    3. Understanding Agents in Replication
    4. Securing Replication
  2. Implementing Replication
    1. Understanding the SQL Server Platform for Replication
    2. Replicating Data and Objects
    3. Replicating and Executing Objects
    4. Designing a Replication Topology
    5. Troubleshooting a Replication Implementation
  3. Implementing Replication
    1. Determining the Replication Type
    2. Implementing Snapshot Replication
    3. Implementing Transactional Replication
    4. Implementing Merge Replication
    5. Removing Subscriptions and Publications
  4. Implementing Snapshot Replication
    1. Understanding Snapshot Replication Architecture
    2. Replicating Snapshot Publications Efficiently
    3. Troubleshooting Snapshot Replication
  5. Implementing Transactional Replication
    1. Understanding Transactional Replication Architecture
    2. Replicating with Transactional Replication
    3. Implementing Updatable Transactional Replication
    4. Facilitating Transactional Replication by Using Stored Procedures
    5. Troubleshooting Transactional Replication
    6. Tuning Transactional Replication
  6. Implementing Merge Replication
    1. Understanding Merge Replication Architecture
    2. Implementing Conflict Resolution
    3. Planning and Deploying Merge Replication
    4. Troubleshooting Merge Replication
    5. Tuning Merge Replication
  7. Implementing SQL Server Replication in an Enterprise Environment
    1. Planning for Disaster Recovery in a Replicated Environment
    2. Upgrading and Applying Service Packs in a Replicated Environment
    3. Understanding Enterprise Options in a Replicated Environment
    4. Understanding Replication with Heterogeneous Database Systems

Seminar Summary:

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. (see full course description)

print this agenda print agenda for the Implementing Replication Using Microsoft SQL Server 2000 training seminar

 view dates and locations for this seminar

 

 

 

Custom Search