SQL Server Replication in the Real World

A Practical Approach to Using SQL Server Replication

4.15 (122 reviews)
Udemy
platform
English
language
Other
category
instructor
SQL Server Replication in the Real World
523
students
1.5 hours
content
Jan 2017
last update
$44.99
regular price

What you will learn

You'll understand the architecture behind SQL Server replication.

You'll be able to make decisions on which replication topology is right for any scenario your in.

You'll be able to set up all three flavors of SQL Server Replication.

Description

Review from similar course: 

"The trainer has a nice clear voice and the most important is that he does not rush through the subject, which is the problem with many instructors. By speaking slowly and displaying every step, it saves us time by not having to replay every section over and over, thanks for this." - Andres

Welcome to SQL Server Replication in the Real World.

In this course, you’ll learn how to correctly configure the three replication topologies specific to SQL Server.

Replication is a way of distributing data automatically from a source database to one or more destination databases.

In this course, we are going to cover three core topologies.

They are, Snapshot Replication, Transactional Replication and Merge Replication.

It has also been used to for high availability solution but that’s not recommend.

Replication is for continuous data transfer and is not used for simply copying data.

The two most common real world applications for replication are reporting and data warehousing.

I’ve also seen it used for off-loading nightly batch processing tasks.

Replication uses a Magazine Publishing vocabulary. Anything from an article to an entire database can be replicated.

In the course, we are going to cover all the nomenclature, architecture and real world tips and tricks you’ll need to keep replication functioning without issue.

Thanks for your interest in SQL Server Replication in the Real World.  We will see you in the course!!!

Content

Understanding SQL Server Replication

Course Introduction
Why Use Replication?
What Topology Should I Use?
The Replication Architecture model - Part 1
The Replication Architecture model - Part 2
The Replication Agents
Installing and Adding Replication to Existing Instance
Rep Speak
Course Downloads
Summary
Quiz

The Big 3 - Setting up all the Types of Replcation

Snapshot Replcation
Demo - Scripting Out Replication
Demo - Setting Up Snapshot Replcation
The Jobs - Snapshot Replication
The Distributor
Transactional Replcation
Demo - Setting up Transactional Replication
Merge Replcation
Demo - Setting Up Merge Replcation
The Jobs - Transactional Replication
Testing Merge Replication
Quick Overview of Replication Monitor
Summary
Quiz

Additional Replication Features and Fixes

Removing Replication and Cleaning Up Jobs
Replication Row Filtering
Replcation Column Filters
Shrink Very Large Distribution Database
Correct Immediate Sync Issue
Summary
Quiz

Reviews

Max
September 18, 2023
I didn't get the impression that the author has a deep understanding of these topics. These are more like basics that you can easily learn on your own without buying this course. Unfortunately, I can't recommend it unless someone is an absolute beginner
Tolga
October 6, 2022
The content is well summarised. Especially, video capturing scale and emphasizing via focusing and red arrows and circles is good. It was rather. Speed and sound is good.
Laura
November 17, 2021
There was one module where the lecture was giving a different information than what it was being written on the whiteboard, so it was hard to read and listen to different things. The selection of some optios with the mouse is being done too fast, without giving the change to read what it was selected.
imtiaz
August 2, 2018
I attended the course to understand the vocabulary of Replication in SQL server. I am very happy that the course exactly delivered what i wanted to learn and i applied it in my real world scenario looking forward to take SQL mirroring with certificate having mirroring on public ips
Sunil
July 24, 2018
Have understood the types of replication and its creation and operational components, the course is short and sweet to glance over the concept it is very good. Would like few other issues those experienced after the set-up is complete .

Charts

Price

SQL Server Replication in the Real World - Price chart

Rating

SQL Server Replication in the Real World - Ratings chart

Enrollment distribution

SQL Server Replication in the Real World - Distribution chart

Related Topics

1059782
udemy ID
1/3/2017
course created date
11/20/2019
course indexed date
Bot
course submited by