Target Audience

This course is aimed at database administrators, data architects, and IT professionals involved in managing and maintaining SQL Server databases who wish to gain a comprehensive understanding of replication techniques to ensure data consistency and availability across different servers or locations.

Course Description


This course is designed to provide an in-depth understanding of SQL Server Replication, a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency.

Using practical examples and interactive exercises, students will explore the key concepts, configurations, and management techniques involved in implementing and maintaining replication in SQL Server environments. The course will cover all three primary replication types: Transactional Replication, Merge Replication, and Snapshot Replication, each addressing different requirements for data distribution and synchronization.

Snapshot Replication


Includes everything you need to setup, monitor and use snapshot replication in your enviroment.

Merge Replication


Learn the benefits and reason to use merge replication versus the other replication types. How to set it up, and monitoring it over time.

Transactional Rep.


Everything you need to get transactional replication going in your enviornment. Setup, monitoring and reinitialization.

Example Curriculum

  Course Introduction
Available in days
days after you enroll
  Module 1: SQL Server Replication Basics
Available in days
days after you enroll
  Module 2: Snapshot Replication
Available in days
days after you enroll
  Module 3: Transactional Replication
Available in days
days after you enroll
  Module 4: Merge Replication
Available in days
days after you enroll
  Additional Labs
Available in days
days after you enroll
  Review - Wrap Up
Available in days
days after you enroll

Choose a Pricing Option