SQL Server Administration Part 3

Learn High Availability Solutions like Log Shipping, Database Mirroring, Replication and Always On Availability Group

Created by: Raphael Asghar
Production SQL Database Administrator

What Will I Learn?

• At the end of the course, the student will be able to understand, configure and monitor various high availability (HA) solutions such as log shipping, database mirroring, replication, peer to peer replication, and the great always on availability group technology. This experience will help the student gain a better understanding of how and when to utilize each technology depending on the needs of the company. This knowledge will enhance the opportunity for each student to progress faster within a company and promote his skill set to a higher level.

Requirements

• It is strongly advised that students take SQL Administration Part 1 and SQL Administration Part 2 first before taking this course as this builds upon the concepts taught and discussed in those courses. Also, Learn T-SQL course is highly recommended. All the material and software that the students needs will be downloaded and the SQL scripts will be provided by me where applicable.

Target audience

• Students who are interested in learning more advanced technologies that SQL Server has to offer such as database mirroring, and always on; those who are accidental SQL DBAs and are in charge of deploying solutions for safe guarding databases throughout their environment. Students that have not taken SQL Administration Part 1 and SQL Administration Part 2 should not this course as those courses are prerequisites. This course build upon those tow previous courses.