Microsoft SQL Server 2016 – Administration

Microsoft SQL servers are used across many organizations to manage their database across the enterprise. Database administration and management are key in operational efficiency and optimization of resources in companies. A Microsoft SQL Server 2016 Certification can boost one’s career and improve the job opportunities offered in systems and database administration as well as infrastructure specialists. 

Enrolment validity: Lifetime

About This Course

Microsoft SQL Server will provide best practices for implementing database and programmability objects in SQL Server 2016.

Certification training includes under this:

  • MCSA SQL Database Administrator 2016 – This Course covers the tasks and tools involved in administering a SQL Server 2016 database infrastructure and also the objectives for exam 70-764: Administering a SQL Database Infrastructure.

Learning Objectives

Configure data access and auditing
Manage backup and restore of databases
Manage and monitor SQL Server instances
Manage high availability and disaster recovery

Target Audience

  • Web Developers
  • Software Developers
  • Programmers
  • Anyone who wants to pass Exam 70-764


74 Lessons30h


Encryption Features
Transparent Data Encryption
Using Transparent Data Encryption
Configuring Always Encrypted
Encryption with Azure SQL Database
Backup Encryption
Creating an Encrypted Backup
Cell-level Encryption
Configure Connection Encryption
Troubleshooting Encryption
Practical Exercise

Data Access and Permissions


Backing Up Databases

Restoring Databases

Managing Database Integrity

Monitoring Database Activity and Queries

SQL Server Instances

Indexes and Statistics

High Availability and Disaster Recovery



86% off
Duration 30 hours
74 lectures

Material Includes

  • Online, Self Paced Learning
  • Lifetime Access
  • Flexible Learning Program
  • Extensive Content for Self-Learning
  • Practice Quizzes
  • Course Completion Certificate