Online Course: Introduction to SQL Server Replication

All 12 Sessions - On Demand

Nov. 1, 2010 through Nov. 30, 2010

Course Overview

When working with SQL Server, as with any relational database, data is king. But data becomes less useful if you can’t gain access to it in a timely fashion. With so much data, being able to spread information across multiple servers allows for backup and quicker access. Replication is a technology available in SQL Server that facilitates the copying of data from one database to another in order to spread out load or provide redundant copies of data for high availability solutions.

This Virtual Class, delivered by Microsoft SQL Server MVP Eric Johnson, will guide you into the world of SQL Server Replication. The class will start at the very basics of what replication is and the different types and topologies of replication that are common in today’s environments. It will then progress to more advanced topics such as Merge Replication and using Transactional Replication as a High Availability solution. The goal of the course is to take you from never having used Replication to being competent with the technology, and provide you with a solid base of knowledge on which to implement these solutions.

You'll learn what Replication is and how Replication can be used to create reporting and highly available environments. We will cover all types of replication and ensure that you know when each type is appropriate to implement.

The class will also explore more advanced aspects of Replication such as peer-to-peer and updating subscriber replications. We will also look at troubleshooting and optimizing replication. By the end of the class you should be able to select, build, and maintain a replication environment and have a solid foundation of knowledge to draw on when things don’t go as planned.

Eric has worked with all types of Replication since SQL Server 6.5. He is bringing his experiences and frustrations to you so that you can learn Replication quickly and correctly.

Course Structure/Cost

The course will be available on demand, beginning Nov. 1, 2010. The 12 classes will be available on demand for 30 days only.

Upon registration and payment, you will receive an email with instructions on how to test your system in order to view the classes, as well as a link that will remain active for the 30 day on demand period. 

The course cost is $199, and the cost of the DVD with purchase of the course is an additional $199. The cost of the DVD without the purchase of the course is $399. Course downloads, office hours and the ability to email questions to the instructor are included with course purchase only.

Once you have completed the course, you will have the opportunity to take a course quiz and receive a course certificate. After passing the quiz, please allow up to five business days to receive a printed certificate (.PDF via e-mail).


    Eric Johnson

    Eric is the co-founder of Consortio Services, and the primary Database Technologies Consultant.

    His background in Information Tec...


  • Session 1: Replication Overview

    In this opening session, we will look at the structure of the class and what to expect for the next twelve sessions. We begin our tour with an overvie...

  • Session 2: Replication Topologies and Configuration

    This session will provide you with an overview of the various topologies and configurations in replication. We will look at some of the more common to...

  • Session 3: Snapshot Replication

    In session 3, we will look at the simplest type of replication, Snapshot Replication. We will discuss basic configuration, the file locations used by ...

  • Session 4: Transactional Replication

    In this session, we look at the most common replication type, transactional replication. We will look at how you set up a transactional replication fr...

  • Session 5: Merge Replication

    This session covers Merge Replication in all its glory. We look at the configuration and initial sync in addition to peaking under the covers at how m...