- Getting A SQL DBA Job
- 1. VMware Workstation 12 and Domain Controller Part 1
- POST ADDENDUM
- APPS NEEDED
- CREATE VM
- INSTALL SQL SERVER 2017
- ADVENTUREWORKS 2017 DB
- COMPARISON SQL 2014 VS 2017
- 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
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.
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.
Students also bought
Información sobre el Instructor

- 4.43 Calificación
- 105265 Estudiantes
- 25 Cursos
Raphael Asghar
Production SQL Database Administrator
Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life 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 environment. I want to pass that experience and information to my students.
Student feedback
Course Rating
Reviews
meeting my expactations
It's good learning module, giving knowledge in DBA as well some level of infrastructure knowledge like domain controls and IP addresses etc.