MCSA SQL 2016 Database Administration
Overview

MCSA SQL 2016 Database Administration
With the MCSA SQL Database Administrator course, team members will learn to install, maintain, and configure data solutions onsite and in the cloud.
Study time: Full time – 2 weeks | Part time – 2 months
Vendor: Microsoft
Business support: Our customer success team measures and ensures engagement
Prerequisites: one year of experience administering Windows SQL Server would be beneficial
Assessment: Exam 70-764 + 70-765
Ideal for: Database architect, infrastructure specialist, senior developer, database professionals
Meet the trainer
“Amazon Web Services (AWS), Google and Microsoft will capture 76% of all cloud platform revenue in 2018, expanding to 80% by 2020.”
Content overview
70-764: Administering a SQL Database Infrastructure
- Encryption
- Data Access and Permissions
- Auditing
- Backing Up Databases
- Restoring Databases
- Managing Database Integrity
- Monitoring Database Activity and Queries
- Monitoring SQL Server Instances
- Managing Indexes and Statistics
- High Availability and Disaster Recovery
70-765: Provisioning SQL Databases
- Components of a SQL Server 2016 Installation
- Installing and Upgrading SQL Server 2016
- SQL Server Virtual Machines on Azure
- SQL Server Instances and Storage Considerations
- Azure SQL Database Encryption
- SQL Server Performance Settings
- Deploying Applications to Microsoft Azure SQL Databases
- Azure Virtual Machines
- Migrating Client Applications
Our Promise
Trusted by…