SQL Server Administration Part 3
4.7 (90 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.
1,204 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Server Administration Part 3 to your Wishlist.

Add to Wishlist

SQL Server Administration Part 3

Learn High Availability Solutions like Log Shipping, Database Mirroring, Replication and Always On Availability Group
4.7 (90 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.
1,204 students enrolled
Created by Raphael Asghar
Last updated 3/2017
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 7.5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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.
View Curriculum
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.
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.

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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 33 Lectures Collapse All 33 Lectures 07:39:49
+
SQL Administration Part 3
33 Lectures 07:39:49


2. VMware Workstation 12 and Domain Controller Part 2
19:50

3. Server1 installation part 1
11:15

4. Server1 installation part 2
09:34

5. Server 2 installation part 1
13:35

6. Server 2 installation part 2
13:25

7. Server 2 installation part 3
15:00

8. Server 2 installation part 4
15:34

9. Log Shipping Part 1
15:33

10. Log Shipping Part 2
18:32

11. Log Shipping Part 3
17:06

12. Log shipping Manual Failover part 1
12:11

13. Log shipping Manual Failover part 2
10:48

14. Orphans
18:29

15. Monitoring Log Shipping
14:16

16. Database Mirroring
18:43

17. Database Mirroring using GUI part 1
12:31

18. Database Mirroring using GUI part 2
13:11

19. Database Mirroring Monitoring part 1
12:40

20. Database Mirroring Monitoring part 2
09:55

21. Replication
12:43

22. Transactional Replication part 1
11:15

23. Transactional Replication part 2
12:35

24. Peer to Peer Replication part 1
11:14

25. Peer to Peer Replication part 2
12:44

26. Always On
17:19

27. Always On Requisite part 1
09:53

28. Always On Requisite part 2
12:16

29. Always On Setup Cluster
14:40

30. Always On Demo part 1
14:50

31. Always On Demo part 2
18:15

32. Backup Replicas
13:23
About the Instructor
Raphael Asghar
4.6 Average rating
1,304 Reviews
16,140 Students
10 Courses
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.