When working with SQL Server, as with any relational database, data is king. But data becomes less useful if you can’t gain access to it in a timely fashion. With so much data, being able to spread information across multiple servers allows for backup and quicker access. Replication is a technology available in SQL Server that facilitates the copying of data from one database to another in order to spread out load or provide redundant copies of data for high availability solutions.
This Virtual Class, delivered by Microsoft SQL Server MVP Eric Johnson, will guide you into the world of SQL Server Replication. The class will start at the very basics of what replication is and the different types and topologies of replication that are common in today’s environments. It will then progress to more advanced topics such as Merge Replication and using Transactional Replication as a High Availability solution. The goal of the course is to take you from never having used Replication to being competent with the technology, and provide you with a solid base of knowledge on which to implement these solutions.
You'll learn what Replication is and how Replication can be used to create reporting and highly available environments. We will cover all types of replication and ensure that you know when each type is appropriate to implement.
The class will also explore more advanced aspects of Replication such as peer-to-peer and updating subscriber replications. We will also look at troubleshooting and optimizing replication. By the end of the class you should be able to select, build, and maintain a replication environment and have a solid foundation of knowledge to draw on when things don’t go as planned.
Eric has worked with all types of Replication since SQL Server 6.5. He is bringing his experiences and frustrations to you so that you can learn Replication quickly and correctly.
Once registered, you'll have instant access to all 12 sessions for a full 30 days. Watch as often as you like, re-watch sessions, download supporting materials, ask questions of the instructor... you'll have full access during the course!
The course cost is $169 for full SSWUG.ORG members and $199 for non-members. The cost of the DVD with purchase of the course is an additional $199. The DVD costs $399 if you do not purchase a course seat. Course downloads, and the ability to email questions to the instructor are included with course purchase only. If you are unable to view all the sessions in the alotted time, we can offer you a 30 day course extension for only $79.00.
Once you have completed the course, you will have the opportunity to take a quiz and receive a course certificate. After passing the quiz, please allow five business days to receive the certificate via e-mail download link.
Group discounts are also available to companies and organizations. To start the group registration process,
Download group registration/discount form