SQL Server Administration Part 3
4.5 (801 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,471 students enrolled

SQL Server Administration Part 3

Learn High Availability Solutions like Log Shipping, Database Mirroring, Replication and Always On Availability Group
4.5 (801 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,471 students enrolled
Created by Raphael Asghar
Last updated 4/2020
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8.5 hours on-demand video
  • 10 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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.
Course content
Expand 39 lectures 08:34:30
+ SQL Administration Part 3
39 lectures 08:34:30
POST ADDENDUM
08:11
APPS NEEDED
07:34
CREATE VM
18:22
INSTALL SQL SERVER 2017
09:43
ADVENTUREWORKS 2017 DB
08:13
COMPARISON SQL 2014 VS 2017
02:38
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
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 this course is for:
  • 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.