SQL Server Administration Part 3
SQL Server Administration Part 3, available at $74.99, has an average rating of 4.6, with 39 lectures, based on 2437 reviews, and has 13895 subscribers.
You will learn about 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. This course is ideal for individuals who are 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. It is particularly useful 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.
Enroll now: SQL Server Administration Part 3
Summary
Title: SQL Server Administration Part 3
Price: $74.99
Average Rating: 4.6
Number of Lectures: 39
Number of Published Lectures: 39
Number of Curriculum Items: 39
Number of Published Curriculum Objects: 39
Original Price: $19.99
Quality Status: approved
Status: Live
What You Will 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.
Who Should Attend
- 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.
Target Audiences
- 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.
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.
Course Curriculum
Chapter 1: SQL Administration Part 3
Lecture 1: Getting A SQL DBA Job
Lecture 2: 1. VMware Workstation 12 and Domain Controller Part 1
Lecture 3: POST ADDENDUM
Lecture 4: APPS NEEDED
Lecture 5: CREATE VM
Lecture 6: INSTALL SQL SERVER 2017
Lecture 7: ADVENTUREWORKS 2017 DB
Lecture 8: COMPARISON SQL 2014 VS 2017
Lecture 9: 2. VMware Workstation 12 and Domain Controller Part 2
Lecture 10: 3. Server1 installation part 1
Lecture 11: 4. Server1 installation part 2
Lecture 12: 5. Server 2 installation part 1
Lecture 13: 6. Server 2 installation part 2
Lecture 14: 7. Server 2 installation part 3
Lecture 15: 8. Server 2 installation part 4
Lecture 16: 9. Log Shipping Part 1
Lecture 17: 10. Log Shipping Part 2
Lecture 18: 11. Log Shipping Part 3
Lecture 19: 12. Log shipping Manual Failover part 1
Lecture 20: 13. Log shipping Manual Failover part 2
Lecture 21: 14. Orphans
Lecture 22: 15. Monitoring Log Shipping
Lecture 23: 16. Database Mirroring
Lecture 24: 17. Database Mirroring using GUI part 1
Lecture 25: 18. Database Mirroring using GUI part 2
Lecture 26: 19. Database Mirroring Monitoring part 1
Lecture 27: 20. Database Mirroring Monitoring part 2
Lecture 28: 21. Replication
Lecture 29: 22. Transactional Replication part 1
Lecture 30: 23. Transactional Replication part 2
Lecture 31: 24. Peer to Peer Replication part 1
Lecture 32: 25. Peer to Peer Replication part 2
Lecture 33: 26. Always On
Lecture 34: 27. Always On Requisite part 1
Lecture 35: 28. Always On Requisite part 2
Lecture 36: 29. Always On Setup Cluster
Lecture 37: 30. Always On Demo part 1
Lecture 38: 31. Always On Demo part 2
Lecture 39: 32. Backup Replicas
Instructors
-
Raphael Asghar
Production SQL Database Administrator
Rating Distribution
- 1 stars: 24 votes
- 2 stars: 32 votes
- 3 stars: 182 votes
- 4 stars: 839 votes
- 5 stars: 1361 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024