Microsoft 70-764 : Administering a SQL Database Infrastructure 2016



21 Hours 13 Minutes


106 Course Videos


250 Test Questions

  • Study Online
  • Pay by Debit/Credit
    cards & PayPal
  • Certified
SKU: ms-70-764 Categories: , , ,

The Microsoft 70-764 SQL Server 2016 Administration course prepares student for the Microsoft Certification Exam 70-764. By the end of this course, you will be able to administer a Microsoft SQL 2016 server.

This Microsoft 70-764 SQL Server 2016 Administration course is for students intended for IT professionals responsible for installing, configuring and maintaining a Microsoft SQL Server environment. Students preparing for the 70-764 exam will typically will have at least 2 years of experience working with SQL Server.

Microsoft recommends having experience setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. You will be able to engage these topics on multiple platforms, including SQL Server 2016, SQL Server v.Next on Linux, and Azure SQL Databases. Students studying for the Microsoft Administering a SQL Database Infrastructure exam are database professionals who perform installation, maintenance, and configuration tasks.

In this Microsoft 70-764 SQL Server course, you will learn are how to configure Cell-level Encryption, Transparent Data Encryption, Always Encrypted, Backup Encryption, Connection Encryption, and Encryption Troubleshooting and ending with creating an Availability Group, manage failover, configure read-only routing and create distributed availability groups. Examining topics through the lenses of various platforms, comparing what they look like in SQL Server 2016, SQL Server v.Next on Linux, and Azure SQL Databases.

Students taking this course do so to sit for Exam 70-764 and want to become proficient about using Microsoft SQL server.

Course Lesson Preview Video

Take this opportunity to view a lesson included in this course.

About The Administering a SQL Server Database Infrastructure 2016 (70-764) Exam

During this exam, you should be knowledgeable in the following areas:

  • Configure data access and auditing (20-25%)
  • Manage backup and restore of databases (20-25%)
  • Manage and monitor SQL Server instances (35-40%)
  • Manage high availability and disaster recovery (20-25%)

Microsoft currently charges $165 for this exam. Check the Microsoft site for confirmation and if any, updated information.

To see more Microsoft related training, click here.

You may also like…