MCSA SQL Server 2016 Administrator Training Bundle

Course code: LE037

Prepare for the Microsoft certification exams with this MCSA SQL Server 2016 Administrator training bundle!

  • Learn more about how to configure data access and permissions, including managing database object permissions.
  • Understand how to develop a backup strategy and configure alerts for failed backups.
  • Study how to restore databases and perform point-in-time recoveries.
  • Explore how to implement database consistency checks and identify any database corruption.
This course is only available to study online.
Course overview

If you are IT professional responsible for installing and maintaining a Microsoft SQL server, or want to develop your knowledge within this field, this is the course for you.

Home learning is simple and stress free, so why not enrol today and join the 90,000 students who have chosen Open Study College to improve their career prospects.

Course Duration

Up to two years

Course Outcome

You will receive a Certification of Completion

Entry Requirements

There are no specific entry requirements for this course


To achieve the full Microsoft qualification, you will need to sit the 70-740, 70-741 and 70-742 examinations.

Course content
  • Module 1 - Installing Windows Server 2016 in Host and Compute Environments
  • Module 2 - Configuring Active Directory Networks for Host and Compute Environments
  • Module 3 - Implementing Local and Enterprise Storage Solutions
  • Module 4 - Implementing Hyper-V Virtualization and Containers
  • Module 5 - Implementing High Availability
  • Module 6 - Maintaining and Monitoring Windows Server 2016
  • Module 1 - Plan and Implement IPv4 and IPv6 Networks
  • Module 2 - Installing and Configuring DHCP
  • Module 3 - Installing and Configuring DNS
  • Module 4 - Implementing and Managing IP Address Management
  • Module 5 - Implementing Remote Access
  • Module 6 - Installing and Configuring Branch Office Networking
  • Module 7 - Implementing Advanced Networking Features
  • Module 8 - Securing the Network Infrastructure
  • Module 1 - Installing and Configuring Domain Controllers
  • Module 2 - Managing AD DS Objects
  • Module 3 - Securing Active Directory Domain Services
  • Module 4 - Working with Complex AD Infrastructures
  • Module 5 - Implementing Group Policy
  • Module 6 - Understanding Microsoft Azure AD and Directory Synchronization
  • Module 7 - Monitoring and Recovering AD DS
  • Module 8 - Implementing Active Directory Certificate Services
  • Module 9 - Implementing Active Directory Federation Services
  • Module 10 - Implementing Active Directory Rights Management Services
Extra info

Course Duration

You will have up to 24 months (two years) to complete the course. This is more than enough time necessary to complete the course at your own pace. With this flexible home learning course, you can fast-forward, rewind or repeat all the online classes with no strict deadlines

Study Method

You will study this course through distance learning. This course will allow you to work at home or at work. Once you have enrolled, you will receive your materials via email for you to study online, whenever and wherever you choose.
Throughout this course, you will have access to online classes and tutorials that are taught by professional instructors, as well as additional visual demonstrations, multimedia presentations, quizzes, exams, flash cards and games to help you through your studies and prepare you for the examinations.

Course Outcome

Upon successful completion of this course, you will receive a Certification of completion so you can showcase your achievement to future employers.
Please note in order to achieve the official qualification you will have to successfully complete the Microsoft 70-740, 70-741 and 70-742 Certification examinations, which are available once you have completed the course.
It is your own responsibility to enquire and book these exams.


No previous knowledge is required to enrol onto this course. However, it is recommended you have a basic knowledge of IT.

In order to achieve the full Microsoft qualification, you will need to sit the relevant 70-764 and 70-765 examinations. It is your own responsibility to enquire and book these examinations.

Everything you need to complete this course will be provided; however, you will need to pay additional fees to sit your necessary examinations in order to achieve the actual certification.

That's not a problem. We want to make sure you’re 100% confident about enrolling on the course and starting your study. So, just give our Student Adviser Team a call on 03300 563 100 and they’ll do their best to help.

You may also like

Creative Digital Design

Single course

or from £329 in full

Video Game Design

Single course

or from £329 in full

or from £329 in full

Enrol now

If you are interested in and you’re looking for a more flexible approach to learning that fits around your life - this is the ideal course for you. Enrol online today by clicking below or speak to one of our advisers for more information.

Enrol on this course