Set up SQL Server replication with confidence
A self-paced video course from Steve Stedman: snapshot, transactional and merge replication, from the first publication through monitoring, reinitializing and troubleshooting. 58 lessons, 3.5+ hours of video, hands-on labs and a certificate of completion.
$449.99 with code REPLICATION10OFF (regularly $499.99). Unlimited access, never expires.
Not sure yet? Watch Steve’s free replication overview below.
Need replication set up or fixed for you? Book a free 30-minute consultation.
More courses from Stedman’s SQL School:
58
lessons in 7 sections
3.5+ hrs
of video, self-paced
4
hands-on labs
Certificate
of completion
Lifetime
access, future updates included
Who this course is for
DBAs who inherited replication
You keep it running but have never set it up from scratch, and every agent error is a mystery.
Architects planning data distribution
You need to choose between snapshot, transactional and merge replication for reporting, branch offices or disaster recovery.
Developers and IT pros
You support SQL Server and want to know what replication does to schemas, performance and deployments.
See how Steve teaches replication
This free overview from Steve’s YouTube channel covers what replication is for and how the three types differ, the same ground the course’s first module covers in depth before the labs begin.
The course page on Teachable lists every lesson and lets you enroll in a couple of minutes.
What you’ll be able to do
By the end of the course you will have set up, monitored, scripted and removed all three replication types in your own lab.
Choose the right replication type
Match snapshot, transactional and merge replication to real needs such as reporting, branch offices and disaster recovery, and know when not to use replication at all.
Build the topology
Configure the distributor, publisher and subscribers, and understand what each replication agent job does and where it runs.
Set up snapshot replication
Walk through the full configuration, then monitor, script, reinitialize and remove it cleanly.
Run transactional replication
Configure the Log Reader Agent, publish to multiple subscribers, filter published data and keep latency in check.
Handle merge replication conflicts
Configure merge replication for multiple subscribers and resolve conflicts without losing changes.
Monitor and troubleshoot
Read Replication Monitor, catch silent failures, and make schema changes on replicated tables the safe way.
Ready to stop guessing at replication? 58 lessons, 3.5+ hours, certificate included.
Why this course works
- Hands-on labs: four step-by-step labs, starting with a demo replication environment you build yourself.
- All three replication types: snapshot, transactional and merge, each taken from setup through monitoring, scripting, reinitializing and removal.
- Expert instruction: taught by Steve Stedman from replication projects on real client servers.
- Check your understanding: a quiz at the end of each module and a certificate when you finish.
Meet your instructor: Steve Stedman
Steve Stedman is the founder of Stedman Solutions and has worked with SQL Server since 1990. He created Database Health Monitor, hosts Stedman’s SQL Server Podcast, and wrote the Common Table Expressions book. Since 2015 his team has provided managed DBA services, performance tuning and corruption repair for companies across the US.
The course is built from client work: the replication setups Steve has designed, repaired and monitored in production are the ones you learn to build here. If you get stuck, email Steve with your course questions or use his mentoring program for one-on-one help.
Course curriculum
7 sections, 58 lessons, about 3.5 hours of video plus labs and quizzes. Every lesson unlocks the moment you enroll.
Course Introduction: 6 lessons, 21 min
- What is SQL Server Replication? (10:01)
- Overview of Replication Types: Merge, Transaction and Snapshot (4:36)
- Common Use Cases for each Type (5:29)
- How to get the most out of this course (0:32)
- Section Summary – Introduction
- Quiz – Introduction
Module 1: SQL Server Replication Basics: 11 lessons, 40 min
- 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: 11 lessons, 39 min
- 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: 12 lessons, 60 min
- 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: 12 lessons, 50 min
- 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: 4 lessons
- Setting up a demo replication environment
- Snapshot Replication Step-By-Step
- Transactional Replication Step-By-Step
- Merge Replication Step-By-Step
Review – Wrap Up: 2 lessons, 1 min
- Performance Monitoring Course
- Course Completion Certificate (1:23)
From the US-based SQL Server specialists behind Database Health Monitor and Stedman’s SQL Server Podcast, helping clients since 2015.
[Student quote about the replication course goes here]
[Name]
[Role, Company]
[Student quote about the replication course goes here]
[Name]
[Role, Company]
[Student quote about the replication course goes here]
[Name]
[Role, Company]
One price, unlimited access
$449.99
$499.99 regular price. Code REPLICATION10OFF is applied automatically when you click Enroll.
- All 7 sections and 58 lessons
- 3.5+ hours of video plus four hands-on labs and quizzes
- Unlimited access that never expires, future updates included
- Certificate of completion
- Email access to Steve Stedman for course questions
- Pay-over-time options are offered at checkout
Secure checkout on Teachable.
Questions before you enroll? Call (360) 610-7833 or book a free 30-minute consultation.
Frequently asked questions
Is this a live class or self-paced?
Self-paced. Every lesson is recorded video you can start the moment you enroll and rewatch any time.
Which versions of SQL Server does the course cover?
Replication has worked the same way since SQL Server 2008, so the lessons apply to every supported version of SQL Server, including SQL Server 2016 through 2022.
Does it cover Azure SQL Database or Managed Instance?
The labs use SQL Server instances you manage yourself, on-premises or in a virtual machine. The same concepts apply to Azure SQL Managed Instance, which can act as a publisher, distributor or subscriber. Azure SQL Database can only be a push subscriber.
What do I need before I start?
Basic SQL Server administration, such as creating databases and running T-SQL in Management Studio, and a test instance you can experiment on. The first lab walks through setting up a demo replication environment.
How long will it take?
About 3.5 hours of video plus the labs and quizzes, at whatever pace suits you.
How long do I have access?
Unlimited access that never expires, including future updates to the course.
Do I get a certificate?
Yes. A certificate of completion is issued when you finish the course.
Can my company pay, or can I pay in installments?
Yes. Teachable’s checkout accepts company cards and offers pay-over-time options, and you receive a receipt for expense claims. For team enrollments or an invoice, call (360) 610-7833.
What if I get stuck on a concept?
Email Steve with your course questions, or use Steve’s mentoring program for one-on-one help.
More from Stedman Solutions
Prefer we set it up for you?
Stedman Solutions designs, repairs and monitors SQL Server replication for clients as part of our managed services. If you would rather hand it off, start with a free consultation.
More courses from Stedman’s SQL School
Learn replication once, properly
Self-paced, 58 lessons, certificate included. $449.99 with code REPLICATION10OFF.
Would rather have us set up or repair replication for you? Book a free 30-minute consultation.