SQL Server Administration Part 3

Learn High Availability Solutions like Log Shipping, Database Mirroring, Replication and Always On Availability Group
4.7 (60 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
986 students enrolled
Take This Course
  • Lectures 33
  • Length 7.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2016 English

Course Description

This SQL Server Administration Part 3 course is designed for the student who has already taken or is taking Part 1 and Part 2, which are prerequisite courses.  This course will cover High Availability solutions such as log shipping, database mirroring, replication, peer to peer replication and always on availability group technologies. Upon completing this course, the student will be well versed in configuring, managing, and monitoring virtually all tasks that a SQL SBA does in his daily, weekly and monthly duties.  The materials that the student will need such as documents and SQL scripts will be provided via a zip file that the student requests via email.  Upon completion of this course, the student will have the training, education and knowledge that a college provides in their courses about SQL Server Administration.

What are the 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.

What am I going to get from this course?

  • 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.

Who is the 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: SQL Administration Part 3
Getting A SQL DBA Job
1. VMware Workstation 12 and Domain Controller Part 1
2. VMware Workstation 12 and Domain Controller Part 2
3. Server1 installation part 1
4. Server1 installation part 2
5. Server 2 installation part 1
6. Server 2 installation part 2
7. Server 2 installation part 3
8. Server 2 installation part 4
9. Log Shipping Part 1
10. Log Shipping Part 2
11. Log Shipping Part 3
12. Log shipping Manual Failover part 1
13. Log shipping Manual Failover part 2
14. Orphans
15. Monitoring Log Shipping
16. Database Mirroring
17. Database Mirroring using GUI part 1
18. Database Mirroring using GUI part 2
19. Database Mirroring Monitoring part 1
20. Database Mirroring Monitoring part 2
21. Replication
22. Transactional Replication part 1
23. Transactional Replication part 2
24. Peer to Peer Replication part 1
25. Peer to Peer Replication part 2
26. Always On
27. Always On Requisite part 1
28. Always On Requisite part 2
29. Always On Setup Cluster
30. Always On Demo part 1
31. Always On Demo part 2
32. Backup Replicas

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Raphael Asghar, Production SQL Database Administrator

Worked as a Production SQL Database Administrator for over 10 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Created five courses for those students who want a simple path to becoming a SQL DBA.I love SQL Administration and all that is involved in managing and creating a stable SQL architecture enviroement. I want to pass that experience and information to my students.

Ready to start learning?
Take This Course