Course Introduction
Module 1: SQL Server Replication Basics
-
Welcome (1:23)
-
Understanding Replication Architecture (5:41)
-
Publisher, Subscriber, and Distributor (5:30)
-
Role of Agent Jobs (6:06)
-
Types of Replication: Snapshot Replication (3:52)
-
Types of Replication: Transactional Replication (5:01)
-
Types of Replication: Merge Replication (4:47)
-
Push versus Pull Replication (2:23)
-
Configuring the Distributor (5:32)
-
Section summary - Replication Basics
-
Quiz - Replication Basics
Module 2: Snapshot Replication
-
Welcome to Snapshot Replication (1:03)
-
Setup Snapshot Replication - Configuration Steps (27:46)
-
Setup Snapshot Replication - Recap (10:07)
-
Limitations of Snapshot Replication
-
Use Cases For Snapshot Replication
-
Monitoring Snapshot Replication
-
Scripting Snapshot Replication
-
Removing Snapshot Replication
-
Reinitializing Snapshot Replication
-
Section Summary - Snapshot Replication
-
Quiz - Snapshot Replication
Module 3: Transactional Replication
-
Welcome to Transactional Replication (1:21)
-
Introduction to Transactional Replication
-
Log Reader Agent
-
Setup Transactional Replication - Configuration Steps (14:36)
-
Setup Transaction Replication - Multiple Subscribers (26:09)
-
Setup Transactional Replication - Filtering Published Data
-
Monitoring Transactional Replication (5:21)
-
Reinitializing Transactional Replication (2:37)
-
Scripting Transactional Replication (4:09)
-
Removing Transactional Replication (5:43)
-
Section summary - Transactional Replication
-
Section Quiz - Transactional Replication
Module 4: Merge Replication
-
Welcome to Merge Replication (0:58)
-
Introduction to Merge Replication
-
Use Cases for Merge Replication
-
Setup Merge Replication - Configuration Steps (21:45)
-
Setup Merge Replication - Multiple Subscribers (7:13)
-
Monitoring Merge Replication (3:37)
-
Resolving Conflicts (9:10)
-
Reinitializing Merge Replication (3:33)
-
Scripting Merge Replication (1:58)
-
Removing Merge Replication (2:00)
-
Section Summary - Merge Replication
-
Section Quiz - Merge Replication
Additional Labs
Review - Wrap Up
