This course is designed for experts, who would like to get deeper into technical details on specific platform areas and SQL Server components, like replication or log shiping solutions.
The course goal is to dive into Replication in order for the attendees to understand and get familiar with the SQL Server platform for distributing data. The course consists of primarily lectures. Practical exercises take approx. 30% of the course time. There are recommendations and tasks that are given to attendees for offsite work.

This course is designed for experts, who would like to get deeper into technical details on specific platform areas and SQL Server components, like replication or log shiping solutions.

• Decide what type and which replication topology to implement
• Understand how the specific replication solution work
• Implement a replication solution
• Manage, maintain and troubleshoot replication configuration
• Monitor and take actions to optimize the replication performance

Module 1: SQL Server replication overview

Module 2: Transactional replication

Module 3: Merge replication

Module 4: Peer to peer replication

Module 5: Replication topologies

Module 6: Replication HA and DR