MCSA: SQL 2016 (Administration)

  • Course level: Intermediate
  • Total Enrolled 0
  • Last Update February 26, 2021


The massive growth in data collection of businesses and also the increased need for database security measures pave the way for demand of database administrators. Modern businesses look for database administration sources and professionals for driving critical business decisions.

The Microsoft MCSA covers all of those necessary skills required to administer and provide an SQL database within a business environment.

MCSA: SQL 2016 Database Administration certification will qualify you as an infrastructure specialist or database administrator. You have to pass required exams of Exam 70-764/Course 20764: Administering a SQL Database Infrastructure.

This course aims to nurture the skills of database professionals who can perform installation, maintenance, and configuration tasks. The additional responsibilities include setting up database systems, ensuring optimal system efficiency, and regularly storing of data and back up, and securing data from unauthorized access.

Exam 70-765/Course 20765: Provisioning SQL Databases

This exam is best fit for architects, infrastructure specialists, senior developers, and development leads.

Candidates with working knowledge on various cloud service models and service model architectures, data synchronization techniques and data storage options. Candidates with knowledge on upgrading and migrating databases, deployment models and services and applications, and integrating Azure applications with external resources are well suited for the course.

Prerequisites: With a professional experience, students who wish to attend this training should have the following technical knowledge:

  • Basic knowledge on Microsoft Windows operating system and its core functionality.
  • Transact-SQL working knowledge
  • Working knowledge of relational databases.
  • Basic knowledge on database design.


Topics for this course

25 Lessons

Exam 70-764/Course 20764: Administering a SQL Database Infrastructure

Module 1: SQL Server Security00:00:00
Module 2: Assigning Server and Database Roles
Module 3: Authorizing Users to Access Resources
Module 4: Protecting Data with Encryption and Auditing
Module 5: Recovery Models and Backup Strategies
Module 6: Backing Up SQL Server Databases
Module 7: Restoring SQL Server 2016 Databases
Module 8: Automating SQL Server Management
Module 9: Configuring Security for SQL Server Agent
Module 10: Monitoring SQL Server with Alerts and Notifications
Module 11: Introduction to Managing SQL Server by using PowerShell
Module 12: Tracing Access to SQL Server with Extended events
Module 13: Monitoring SQL Server
Module 14: Troubleshooting SQL Server
Module 15: Importing and Exporting Data

Exam 70-765/Course 20765: Provisioning SQL Databases