SQL Server Replication in the Real World

SQL Server Replication in the Real World, available at $44.99, has an average rating of 4.45, with 29 lectures, 3 quizzes, based on 127 reviews, and has 538 subscribers.

You will learn about Youll understand the architecture behind SQL Server replication. Youll be able to make decisions on which replication topology is right for any scenario your in. Youll be able to set up all three flavors of SQL Server Replication. This course is ideal for individuals who are Anyone using SQL Server who needs to move data between two environments. It is particularly useful for Anyone using SQL Server who needs to move data between two environments. .

Enroll now: SQL Server Replication in the Real World

Summary

Title: SQL Server Replication in the Real World

Price: $44.99

Average Rating: 4.45

Number of Lectures: 29

Number of Quizzes: 3

Number of Published Lectures: 29

Number of Published Quizzes: 3

Number of Curriculum Items: 32

Number of Published Curriculum Objects: 32

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Youll understand the architecture behind SQL Server replication.

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

Youll be able to set up all three flavors of SQL Server Replication.

Who Should Attend

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

Target Audiences

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

Review from similar course:?

“The trainerhas 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 replayevery section over and over, thanks for this.” – Andres

Welcome to?SQL Server Replication in the Real World.

In this course, you’ll learn how tocorrectly configure thethreereplication topologies specific to SQL Server.

Replicationis a way of distributing data automaticallyfrom a sourcedatabase to one or more destinationdatabases.

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 Publishingvocabulary. 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!!!

Course Curriculum

Chapter 1: Understanding SQL Server Replication

Lecture 1: Course Introduction

Lecture 2: Why Use Replication?

Lecture 3: What Topology Should I Use?

Lecture 4: The Replication Architecture model – Part 1

Lecture 5: The Replication Architecture model – Part 2

Lecture 6: The Replication Agents

Lecture 7: Installing and Adding Replication to Existing Instance

Lecture 8: Rep Speak

Lecture 9: Course Downloads

Lecture 10: Summary

Chapter 2: The Big 3 – Setting up all the Types of Replcation

Lecture 1: Snapshot Replcation

Lecture 2: Demo – Scripting Out Replication

Lecture 3: Demo – Setting Up Snapshot Replcation

Lecture 4: The Jobs – Snapshot Replication

Lecture 5: The Distributor

Lecture 6: Transactional Replcation

Lecture 7: Demo – Setting up Transactional Replication

Lecture 8: Merge Replcation

Lecture 9: Demo – Setting Up Merge Replcation

Lecture 10: The Jobs – Transactional Replication

Lecture 11: Testing Merge Replication

Lecture 12: Quick Overview of Replication Monitor

Lecture 13: Summary

Chapter 3: Additional Replication Features and Fixes

Lecture 1: Removing Replication and Cleaning Up Jobs

Lecture 2: Replication Row Filtering

Lecture 3: Replcation Column Filters

Lecture 4: Shrink Very Large Distribution Database

Lecture 5: Correct Immediate Sync Issue

Lecture 6: Summary

Instructors

Mike West
Creator of LogikBot

Rating Distribution

1 stars: 4 votes

2 stars: 3 votes

3 stars: 16 votes

4 stars: 55 votes

5 stars: 49 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!