Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Exam material for the Microsoft 70-764, Administering a SQL Database Infrastructure

By:   |   Read Comments   |   Related Tips: More > Professional Development Certifications

Attend this free live MSSQLTips webcast

Tips and Tricks to Growing Your SQL Server Estate from SMB to Enterprise Scale
Thursday, June 28, 2018 - click here to learn more


I am going to take the Microsoft exam 70-764, Administering a SQL Database Infrastructure. I would like to know what materials I can use to study and help pass this exam.


In this article, we will talk about materials that can be used to help study for this exam.

What is the 70-764 certification exam?

This is oriented for DBAs and covers security, backups, monitoring and high availability solutions.

Is it an exam for database developers?

This exam is for DBAs, but database developers can find some of the topics useful.

Is it an exam oriented to SQL Server 2016?

Yes, this is an exam is oriented to SQL Server 2016 and Azure SQL.

Which SQL Server 2012/2014 exam is similar to this one?

The 70-462 is similar to this new exam, but some topics were changed. This exam contains more Azure SQL related topics and a lot of topics were removed in this exam like installation, maintenance, replication and import/export data.

Is this exam difficult?

We believe that these new exams are less extensive than the older ones and it should take less time to study.

Are there some virtual labs?

Yes, there are some virtual labs. They are very useful to save time and contain some practice labs:

Some of the labs like the AlwaysOn labs are in SQL 2014, but they are still recommended for this exam.

Which books would you recommend for this exam?

There is no Training Kit book yet, but older books for old exams may help for this one. Here are some:

  1. Training Kit (Exam 70-462) Administering Microsoft SQL Server 2012 Databases (MCSA) (Microsoft Press Training Kit)
  2. Professional Microsoft SQL Server 2014 Administration
  3. Microsoft Azure SQL Database Step by Step (Step by Step Developer)
  4. Pro SQL Server on Microsoft Azure (specially chapter 8-10)

Which courses would you recommend for this exam?

The official Microsoft course is the 20764B, Administering a SQL Database Infrastructure.

There will be a specific MVA course in the future, but not for now. Other courses provided by are:

What links do you recommend reading for this exam?

Here are some useful links:

Configure data access and auditing

Manage backup and restore of databases

Manage and monitor SQL Server instances

Next Steps

Here are more links that will be useful:

Last Update:

next webcast button

next tip button

About the author
MSSQLTips author Daniel Calbimonte Daniel Calbimonte is a Microsoft SQL Server MVP, Microsoft Certified Trainer and Microsoft Certified IT Professional.

View all my tips
Related Resources

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Learn more about SQL Server tools