1Course Overview

MCSA SQL Server 2016 Administrator Training Bundle

Course code: LE037

Pay up front:


Save £100 by
paying up front

Free UK delivery

Additional Discounts Available on selected courses until 28th May

  • Days
  • Hours
  • Mins
  • Secs

Prepare for the Microsoft Certification exams with this Administrator Training Bundle!

If you are IT professonal responsible for installing and maintaining a Microsoft SQL Server environment, or want to develop within this career, this is the course for you. 

This bundle course contains 2 different courses and will allow you to:

  • Prepare for both the 70-7064 and 70-765 examinations
  • Learn from training professionals 
  • Administer a Microsoft SQL 2016 Server
  • Boost your CV with vital Microsoft knowledge and skills that employers look for

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

Discounts on selected courses - Until 28th May
2Course Content

MS 70-764: Administering a SQL 2016 Database Infrastructure

Module 1: Encryption
  • Introduction
  • Exam Objectives and Lab Setup
  • Restoring AdventureWorks 2016 Database Lab Part 1, 2 and 3
  • Configure Encryption
  • Cell-Level Encryption Part 1 and 2
  • Cell-Level Encryption Lab Part 1 and 2
  • Transparent Data Encryption
  • Transparent Data Encryption Lab
  • Always Encrypted
  • Always Encrypted Lab
  • Backup Encryption
  • Backup Encryption Lab
  • Connection Encryption
  • Encryption Troubleshooting
Module 2: Configure Data Access and Permissions
  • Create and Maintain Users
  • Create and Maintain Users Lab Part 1 and 2
  • Configure and Maintain Custom Roles
  • Configure and Maintain Custom Roles Lab
  • Manage Database Object Permissions Part 1 and 2
  • Manage Database Object Permissions Lab Part 1 and 2
  • Manage Database Object Permissions Lab Part 2
  • Configure User Options for Azure SQL Database
  • Configure Row-Level Security
  • Configure Dynamic Data Masking
  • Configure Dynamic Data Masking Lab
Module 3. Configure Auditing
  • 3.1 Manage a SQL Server Audit
  • 3.2 Manage a SQL Server Audit Lab
  • 3.3 Query the SQL Server Audit Log
  • 3.4 Manage an Azure SQL Server Audit
Module 4: Develop a Backup Strategy
  • Backup Types Part 1 and 2
  • Manage, Backup, and Restore Databases Lab Part 1 and 2
  • Backup Very Large Databases Part 1, 2, 3 and 4
  • Managing Very Large Databases Lab Part 1, 2 and 3
  • Configure Alerting for Failed Backups
  • Configure Alerting for Failed Backups Lab Part 1 and 2
  • Back up Databases to Azure
  • Manage Transaction Log Backups
  • Configure Database Recovery Models
  • Set Database Recovery Model Lab
  • Configure Backup Automation
  • Configure Backup Automation Lab
Module 5: Restore Databases
  • Perform Piecemeal Restores
  • Restore Databases Lab Part 1, 2 and 3
  • Perform Page Recovery
  • Perform Point-in-Time Recovery
  • Perform Point-in-Time Recovery Lab
  • Restore File Groups
  • Develop a Plan to Automate and Test Restores
Module 6: Manage Database Integrity
  • Implement Database Consistency Checks
  • Implement Database Consistency Checks Lab
  • Identify Database Corruption
  • Recover From Database Corruption


MS 70-765: Provisioning SQL Databases 

Module 1: Deploy a Microsoft Azure SQL Database
  • Introduction
  • Introducing the Azure SQL Database Part 1 and 2
  • Setting Up Azure Lab
  • Chose a Service Tier Part 1 and 2
  • Create Servers and Databases Part 1, 2 and 3
  • Creating a Azure SQL Server and Database Lab
  • Connecting SSMS to Azure SQL Lab Part 1 and 2
  • Create a Sysadmin Account
  • Creating Azure SQL Logins and Users Lab
  • Configure Elastic Pools
  • Creating and Configuring an Elastic Pool Lab
Module 2: Plan for SQL Server Installation
  • Plan for an IaaS or On-Premises Deployment Part 1 and 2
  • Select the Appropriate Size for a Virtual Machine
  • Plan Storage Pools Based on Performance Requirements Part 1 and 2
  • Evaluate Best Practices for Installation
  • Design a Storage Layout for a SQL Server Virtual Machine
Module 3: Deploy SQL Server Instances
  • Deploy a SQL Server Instance in IaaS and On-Premises
  • Restoring AdventureWorks 2016 Database Lab
  • Provision an Azure Virtual Machine to Host a SQL Server Instance
  • Provisioning an Azure Virtual Machine to Host a SQL Server Lab
  • Manually Install SQL Server on an Azure Virtual Machine
  • Installing SQL 2016 Lab Part 1 and 2
  • Automate the Deployment of SQL Server Databases
  • Exploring Azure SQL Database Automation Lab
  • Deploy SQL Server by Using Templates
  • Managing JSON Templates Lab
Module 4: Deploy SQL Server Databases to Azure Virtual Machines
  • Migrate an On-Premises SQL Server Database to an Azure Virtual Machine
  • Migrate an On-Premises SQL Server Database to an Azure Virtual Machine Lab Part 1, 2, 3 and 4
  • Generate Benchmark Data for Performance Needs
  • Generating Benchmark Data Lab Part 1 and 2
  • Perform Performance Tuning on Azure IaaS
  • Perform Performance Tuning on Azure IaaS Lab Part 1 and 2
  • Support Availability Sets in Azure Part 1 and 2
  • Manage High Availability Lab Part 1, 2, 3, 4 and 5
Module 5: Configure Secure Access to Microsoft Azure SQL Databases
  • Configure Firewall Rules
  • Creating Firewall Rules Lab
  • Configure Always Encrypted for Azure SQL Database
  • Implementing Always Encrypted Lab
  • Configure Cell-Level Encryption
  • Cell-Level Encryption Lab
  • Configure Dynamic Data Masking
  • Dynamic Data Masking Lab
  • Configure Transparent Data Encryption (TDE)
  • Transparent Data Encryption (TDE) Lab
3Other Information
Course Duration

You will have 24 months (2 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 Outcomes

Upon successful completion of this course, you will receive a Learning247 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-764 and 70-765 Certification examinations, which are available once you have completed the course.  

It is your own responsibility to enquire and book these exams. 


Your Questions Answered

What skills are needed to enrol onto this course?

No previous knowledge is required to enrol onto this course. However you will need a basic knowledge of I.T.

Do I need to sit an exam?

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.

Are there any additional costs?

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. 

What if I still have questions?

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 Support Team a call on 03300 563 100 and they’ll do their best to help.

Finance options

Provided by
Length Of Your Repayment
Your Deposit
Monthly payment:

Deposit to pay:

  • Cash Price:
  • Loan Amount:
  • Loan Repayments:
  • Cost of Loan:
  • Number of Monthly Payments:
  • Total Amount Payable:

The total course fee includes a loan arrangement fee. Your initial deposit payment will be used towards this fee, any remaining fee balance will be added the loan amount.

Provided by

Our finance option is provided in partnership with AffordItNow.
For your finance application to be considered you must meet the following criteria:

  • Be over 18 years old
  • Be employed for at least 16 hours a week or retired and in receipt of a private or company pension. Certain state benefit schemes may also be considered.
  • Be a permanent UK resident with a 3 year address history
  • Have a good credit history with no late payments, debt relief orders or bankruptcies
  • Have a valid email address and can access it

Please note that meeting the above criteria does not guarantee finance acceptance.

Open Study College, 6140 Knights Court, Birmingham Business Park, Birmingham B37 7WY is a licensed credit broker, authorised and regulated by The Financial Conduct Authority (licence number 724179 with FCA).