OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course image
Udemy logo

SQL Server Administration Part 3

4.6 Filled star Filled star Filled star Filled star Half star
Based on 2,714 ratings
see reviews
Raphael Asghar

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.

Enroll now

Here's a deal for you

Save money when you learn with a deal that may be relevant to this course.
All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.
Only 11 hours left!
24-Hour Flash Sale
Close your skills gaps with online courses and save big for a limited time.
Up to
85%
off
Get offer

What's inside

Learning objective

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.

Syllabus

This final SQL Administration Part 3 course is designed so that the student can learn high availability solutions such as log shipping, database mirroring, replication and always on group technologies
Read more

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Teaches various high availability (HA) solutions such as log shipping, database mirroring, replication, and always on availability group technologies
Develops professional skills or deep expertise in SQL Server Administration
Provides scaffolding through prerequisite courses
Requires students to come in with extensive background knowledge
Uses VMware Workstation 12 and requires learners to create virtual machines

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Practical sql server high availability deep dive

According to learners, this course provides a highly relevant and practical deep dive into SQL Server High Availability solutions essential for DBA roles. Students frequently praise the hands-on labs and demonstrations, especially for complex topics like Always On. While considered largely positive and taught by a knowledgeable instructor, some reviewers noted minor issues like the outdated process for accessing course materials and occasional unevenness in video/audio quality or explanation clarity. Taking prerequisite courses is highlighted as crucial.
Requires prior knowledge from Parts 1 & 2.
"Highly recommended if you have the Part 1 and 2 foundations."
"Make sure you are comfortable with Parts 1 and 2 before diving into this one."
"Prerequisites are non-negotiable."
"Definitely need to take Parts 1 and 2 first before attempting this course."
Directly applicable to DBA roles.
"This course is a gem for anyone serious about becoming a SQL Server DBA."
"Content is solid, very relevant to real-world DBA tasks. Definitely builds well on the previous parts."
"Highly recommend for anyone serious about SQL Server administration."
"Valuable content for a DBA. The hands-on parts are key."
Covers essential HA technologies thoroughly.
"Good coverage of high availability features like log shipping and database mirroring."
"Excellent course focusing on the critical HA solutions. The Always On section alone is worth the price."
"Covers the topics well, especially replication and always on."
"Solid coverage of Log Shipping, Mirroring, and Always On. The practical exercises are the highlight..."
Hands-on demos greatly enhance learning.
"The practical labs for Always On were incredibly helpful and demystified the complex setup process."
"The hands-on demos are the strongest point. ... Content is solid, very relevant to real-world DBA tasks."
"The practical parts are crucial for understanding. Make sure you are comfortable with Parts 1 and 2..."
"Learning by doing in the practical sessions made a big difference in grasping the concepts."
Process for getting materials is clunky.
"...getting the course materials; having to email for a zip file felt a bit old-school."
"Accessing the supplementary files was also a bit of a hassle."
"The material access method is a downside."
"The process for getting materials was not smooth and caused delays."
Some explanations or audio/video could improve.
"...although some parts required rewatching."
"Some explanations were a little rushed, and I had to supplement with documentation..."
"The quality of the video and audio could be better in places."
"Some parts were hard to understand... It's functional but not the most polished course..."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in SQL Server Administration Part 3 with these activities:
Review T-SQL for Database Management
Refresh T-SQL skills to confidently manage and query databases.
Browse courses on T-SQL
Show steps
  • Review T-SQL syntax and commands
  • Practice writing queries
  • Complete online exercises or tutorials
Review Database Administration Fundamentals
Review the core concepts and principles of database administration to strengthen foundational understanding.
View Database Systems: The Complete Book on Amazon
Show steps
  • Read chapters 1-4
  • Take notes on key concepts
  • Complete end-of-chapter exercises
Participate in SQL Server Administration Study Group
Engage with peers to discuss concepts, share experiences, and reinforce understanding of SQL Server administration.
Show steps
  • Join a study group or forum
  • Participate in discussions and share insights
  • Collaborate on projects or case studies
Four other activities
Expand to see all activities and additional details
Show all seven activities
Follow SQL Server Administration Tutorial Series
Enhance practical skills by following a comprehensive tutorial series on SQL Server administration and high availability solutions.
Show steps
  • Identify relevant tutorials on YouTube or online platforms
  • Follow the tutorials step-by-step
  • Take notes and practice configurations
Configure and Manage Log Shipping
Strengthen understanding of log shipping by configuring and managing it in a test environment.
Browse courses on Log Shipping
Show steps
  • Set up two SQL Server instances
  • Configure log shipping
  • Test failover and recovery scenarios
Create a Whitepaper on High Availability in SQL Server
Deepen understanding by researching, writing, and sharing a whitepaper on high availability in SQL Server.
Browse courses on High Availability
Show steps
  • Research and gather information
  • Outline the whitepaper structure
  • Write and edit the content
Participate in SQL Server Administration Hackathon
Test skills and knowledge by participating in a hackathon focused on SQL Server administration and high availability solutions.
Show steps
  • Register for the hackathon
  • Form a team or work independently
  • Develop a solution to a specific challenge

Career center

Learners who complete SQL Server Administration Part 3 will develop knowledge and skills that may be useful to these careers:
SQL Server Database Administrator
A SQL Server Database Administrator ensures that a company's SQL databases are running smoothly and efficiently. This course provides hands-on training in configuring, managing, and monitoring a variety of SQL Server high availability solutions. By learning how to prevent data loss and improve performance, you will become a more effective SQL Server Database Administrator.
See salaries and explore the career path for SQL Server Database Administrator
Database Architect
A Database Architect designs and implements database solutions that meet the needs of an organization. This course helps build a foundation in high availability solutions for SQL Server, which is a valuable skill for a Database Architect to have. By understanding how to prevent data loss and improve performance, you will be able to design and implement more effective database solutions.
See salaries and explore the career path for Database Architect
Data Engineer
A Data Engineer designs, builds, and maintains data pipelines that move data between different systems. This course provides training in high availability solutions for SQL Server, which is a valuable skill for a Data Engineer to have. By understanding how to prevent data loss and improve performance, you will be able to design and implement more effective data pipelines.
See salaries and explore the career path for Data Engineer
Business Intelligence Analyst
A Business Intelligence Analyst helps businesses to make better decisions by providing them with data and insights. This course provides training in high availability solutions for SQL Server, which is a valuable skill for a Business Intelligence Analyst to have. By understanding how to prevent data loss and improve performance, you will be able to provide more accurate and timely insights to your organization.
See salaries and explore the career path for Business Intelligence Analyst
Data Scientist
A Data Scientist develops and implements machine learning and artificial intelligence models to solve business problems. This course may be useful for a Data Scientist who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to develop and implement more effective machine learning and artificial intelligence models.
See salaries and explore the career path for Data Scientist
Software Developer
A Software Developer designs, develops, and maintains software applications. This course may be useful for a Software Developer who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to develop and implement more reliable and efficient software applications.
See salaries and explore the career path for Software Developer
Systems Administrator
A Systems Administrator maintains and supports computer systems and networks. This course provides training in high availability solutions for SQL Server, which is a valuable skill for a Systems Administrator to have. By understanding how to prevent data loss and improve performance, you will be able to keep your organization's computer systems and networks running smoothly and efficiently.
See salaries and explore the career path for Systems Administrator
Network Administrator
A Network Administrator maintains and supports computer networks. This course may be useful for a Network Administrator who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to keep your organization's computer networks running smoothly and efficiently.
See salaries and explore the career path for Network Administrator
IT Manager
An IT Manager is responsible for the overall management of an organization's information technology systems and resources. This course provides training in high availability solutions for SQL Server, which is a valuable skill for an IT Manager to have. By understanding how to prevent data loss and improve performance, you will be able to make better decisions about how to allocate your organization's IT resources.
See salaries and explore the career path for IT Manager
Project Manager
A Project Manager plans, executes, and closes projects. This course may be useful for a Project Manager who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to manage IT projects more effectively.
See salaries and explore the career path for Project Manager
Business Analyst
A Business Analyst helps businesses to identify and solve problems. This course may be useful for a Business Analyst who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to provide more valuable insights to your organization.
See salaries and explore the career path for Business Analyst
Quality Assurance Analyst
A Quality Assurance Analyst tests software applications to ensure that they meet quality standards. This course may be useful for a Quality Assurance Analyst who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to test software applications more effectively.
See salaries and explore the career path for Quality Assurance Analyst
Technical Writer
A Technical Writer creates and maintains technical documentation. This course may be useful for a Technical Writer who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to create and maintain more accurate and helpful technical documentation.
See salaries and explore the career path for Technical Writer
Sales Engineer
A Sales Engineer helps customers to evaluate and purchase software and hardware solutions. This course may be useful for a Sales Engineer who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to better understand the needs of your customers and how SQL Server can help them.
See salaries and explore the career path for Sales Engineer
Customer Support Engineer
A Customer Support Engineer provides technical support to customers. This course may be useful for a Customer Support Engineer who wants to learn more about high availability solutions for SQL Server. By understanding how to prevent data loss and improve performance, you will be able to provide better support to your customers.
See salaries and explore the career path for Customer Support Engineer

Reading list

We've selected seven books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in SQL Server Administration Part 3.
Cover image
Microsoft SQL Server 2008 Internals
Save
Provides comprehensive coverage of Always On Availability Groups, including configuration, management, and troubleshooting.
Microsoft SQL Server 2008 Internals (Pro -...
Unknown Binding
$$$$
Cover image
SQL Server 2005 Bible
Save
Provides step-by-step instructions for implementing and managing different types of SQL Server replication, including transactional and merge replication.
SQL Server 2005 Bible
Paperback
Check
SQL Server 2005 Bible
Kindle Edition
Check
Cover image
High Performance MySQL
Save
Supplement to the course. Provides in-depth information on MySQL performance and optimization.
High Performance MySQL: Optimization, Backups,...
Paperback
$$
Cover image
Secret Colors
Save
Provides concepts in designing and implementing data-intensive applications, which are useful for high availability systems.
Secret Colors
Paperback
Check
Secret Colors
Kindle Edition
Check
Cover image
Pro SQL Server 2012 Practices
Save
Provides a general overview of SQL Server database administration, useful for understanding high availability in SQL Server.
Pro SQL Server 2012 Practices (Expert's Voice in...
Paperback
$$
Cover image
PostgreSQL 16 Administration Cookbook
Save
Provides background on PostgreSQL, a popular open-source database with high availability features.
PostgreSQL 16 Administration Cookbook: Solve real...
Kindle Edition
$$
Cover image
High Performance MySQL
Save
Provides good background on high performance database design, tuning, and optimization.
High Performance MySQL: Optimization, Backups, and...
Paperback
$$
High Performance MySQL: Optimization, Backups,...
Paperback
$$
(中文) High Performance MySQL ( 3rd Edition ) (MySQL...
Paperback
$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to SQL Server Administration Part 3.
Amazon Neptune Service Primer
Most relevant
Choose Azure SQL Database Service Tier that Suits Your...
Most relevant
PostgreSQL Fundamentals: Architecture
Most relevant
Using Memorystore for Redis Read Replicas to Improve Read...
Most relevant
Database Clients
Most relevant
Exam Prep DP-300: Azure Database Administrator Associate
Most relevant
Build and Execute MySQL, PostgreSQL, and SQLServer to...
Most relevant
Workload Manager Validation for SQL Server
Most relevant
SQL for Security Specialist
Most relevant

Udemy Buyer Protection & Guarantee

Verified partner policies & purchase protections

Global Marketplace Leader
Free Trial & Audit

Free Lecture Previews

Free preview video lectures available for all courses; optional 7-day free trial on Personal Plan subscriptions (cancel before trial ends to avoid conversion).

Return & Refund Policy

30-Day Money-Back Guarantee

30-day money-back guarantee on all eligible individual course purchases (provided course content has not been substantially consumed or downloaded). Subscription fees are non-refundable once billed.

Buyer Protections

Verified Academic & Industry Partner

Lifetime access to purchased individual courses and future updates, verifiable certificate of completion, and direct student Q&A forums.

Key Purchase Protections
30-day 100% money-back guarantee on course purchases
Lifetime access on web, mobile, and offline
Certificate of completion included with purchase
Direct instructor Q&A and active student community
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Rating
4.6 Filled star Filled star Filled star Filled star Half star
Effort
8.5 total hours
Via
Udemy
Instructor
Raphael Asghar
Language
English
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
Teaches various high availability (HA) solutions such as log shipping, database mirroring, replication, and always on availability group technologies
Develops professional skills or deep expertise in SQL Server Administration
Provides scaffolding through prerequisite courses
Requires students to come in with extensive background knowledge
Uses VMware Workstation 12 and requires learners to create virtual machines
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
Enroll now to gain full access to SQL Server Administration Part 3.
Enroll now
Save for later
Add this course to your list. Find it anytime.
Save
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser