MCSA SQL 2016 Database Administration2019-01-18T16:15:30+01:00

MCSA SQL 2016 Database Administration

Courses / Data and Databases



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             

Aaron Sampson
Aaron Sampson
Aaron started in the industry in 1995 with a primary focus on certified technical training in network infrastructure and services. Most of Aaron’s experience has been in environments using Windows/Active Directory systems, SQL databases, and Exchange messaging environments. But with multiple certifications as a Microsoft Certified Professional, upgrades, new versions, and new technologies are continually pursued and new challenges are always undertaken.
Contact us

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

Contact Us

Trusted by…

Back to data and Databases

Request a Callback

First Name*
Last name*
Company Email*
Company name*
Your role

Contact Information

Phone: 01273 907 919