Microsoft 70-764 – SQL Server 2016 Administration

Note: Although the associated examination for this course has been retired, it is a good resource for online training.

About our training program

The Microsoft 70-764 SQL Server 2016 Administration course prepares students for the Microsoft Certification Exam 70-764. By the end of this course, students 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.

What will you learn:

This course includes 22 hours of training and 106 videos. In this Microsoft 70-764 SQL Server course, students will learn essential skills on how to configure Cell-level Encryption, Transparent Data Encryption, Always Encrypted, Backup Encryption, Connection Encryption, and Encryption Troubleshooting and end with creating an Availability Group, manage failover, configure read-only routing and create distributed availability groups. Other topics covered throughout the course include the following that students will learn:

Configure data access and auditing Manage backup and restore of databases Manage and monitor SQL Server instances Manage high availability and disaster recovery Database systems and Monitoring database activity Database administrators Database designs

What is the aim of the Microsoft 70-764 SQL Server 2016 Administration online course?

This IT training course is designed to equip you with all the skills and knowledge necessary to administer a complete Microsoft SQL 2016 server solution – from installation through maintenance tasks. It helps you prepare for the Microsoft Certification Exam 70-764​.

Who is the ideal candidate for this online course?

The course is intended for IT professionals responsible for installing, configuring, and maintaining a Microsoft SQL Server environment. Typically, students preparing for this course will have at least 2 years of experience working with SQL Server.

What will I learn during this course?

This course includes 22 hours of training and 106 videos. You’ll learn essential skills on how to configure Cell-level Encryption, Transparent Data Encryption, Always Encrypted, Backup Encryption, Connection Encryption, and Encryption Troubleshooting. You’ll also learn how to create an Availability Group, manage failover, configure read-only routing, and create distributed availability groups​.