Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL Server Replication in the Real World
Rating: 4.2 out of 5(139 ratings)
585 students

SQL Server Replication in the Real World

A Practical Approach to Using SQL Server Replication
Created byMike West
Last updated 1/2017
English

What you'll 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.

Course content

3 sections • 29 lectures • 1h 14m total length

  • Course Introduction1:26

    What are we going to learn in this course?

    This video outlines our course goals. 

  • Why Use Replication?1:50

    In this lecture let's talk about why you might want to use replication. 

    There are some very good use cases for SQL Server Replication.

  • What Topology Should I Use?0:20

    In this lesson let's learn how we decide which topology to use for any given business use case. 

  • The Replication Architecture model - Part 12:19

    In this lecture let's discuss the basics of the replication architecture model. 

  • The Replication Architecture model - Part 22:11

    The replication topology isn't complicated but it does have a lot of new vernacular if you're new to SQL Server. 

    In this lecture let's look at how the distributor and subscriber work. 

  • The Replication Agents2:35

    In this lecture  let's' the discuss the agents used in the replication process. 

  • Installing and Adding Replication to Existing Instance3:37

    In this lecture let's install an instance of SQL Server with replication. 

    We are also going to add replication to an existing instance that doesn't have it installed. 

  • Rep Speak1:47

    In this lecture let's learn the nomenclature behind replication. 

  • Course Downloads0:06

    This is where you'll download the code for the course. 

    There are only three code segments for this course. 

  • Summary1:17

    Let's go over the key ideas we learned in this section. 

    There were a lot of new terms so it might be a good idea to watch this section more than once.

  • Quiz

Requirements

  • You'll need a basic understanding of SQL Server.
  • This isn't an entry level course.
  • You'll need to have access to a SQL Server version that enterprise level. (Standard would be best)
  • Please download a copy of the Adventureworks database.
  • Additionally, you'll need two separate instances installed to test 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!!!

Who this course is for:

  • Anyone using SQL Server who needs to move data between two environments.

Report abuse