MCSA: SQL 2016 Database Administration Online Training

Note: The exams associated with this course have been retired. However, this course still retains value as a training resource.

Taught by

Garth Schulte

UPDATED: March 15, 2019

Intermediate

Virtual Labs

Enhance your database administration skills with this MCSA: SQL 2016 Database Development training. Learn to deploy, configure, and manage SQL databases using both Azure SQL and SQL Server. Master key areas like security, performance optimization, data access, and storage management to improve your SQL administration expertise. Ideal for database admins looking to deepen their practical skills and advance their careers.

Start a free week

Subscription options

$59.00

Access all premium content with a free week!

Quizzes
CyberVista® IT practice exams
Coaching
IT learner community

Start a free week

See training reviews

What you'll learn

Microsoft Azure SQL database deployment: service tiers, creation of servers and databases, sysadmin account, elastic pools
SQL Server Installation: IaaS vs. on-premises, storage design, performance requirements
SQL Server instances deployment: templates, automation, VM provisioning, migration
Secure access configuration: firewall rules, encryption, dynamic data masking
SQL Server Performance Settings: configuration; operators and alerts
SQL Server Instances management: database creation, file management, system database files
Storage management: overview, SMB file shares, service tiers, storage pools, storage recovery
Data Access and Permissions: create and maintain user and roles

FAQs

What's the underlying technology on the MCSA: SQL 2016 Database Administration?

The underlying technology on the MCSA: SQL 2016 Database Administration was administering and provisioning entire SQL database infrastructures. The two certifying exams for the MCSA: SQL 2016 Database Administration were 70-764 and 70-765, they covered basic SQL administration knowledge like setting up database systems and securing them, as well as advanced knowledge in deployment models, migrating databases and integrating Azure applications with external resources.

Are the MCSA: SQL 2016 Database Administration exams 70-764 and 70-765 retired?

Yes, both certifying exams for the MCSA: SQL 2016 Database Administration are retired. Microsoft retired both 70-764: Administering a SQL Database Infrastructure and 70-765: Provisioning SQL Databases on January 31, 2021. Microsoft didn't just retire exams 70-764 and 70-765, but they also retired the entire series of MCSA and MCSE certifications at the same time. It's no longer possible to take 70-764 or 70-765, and they won't be getting replaced.

What happened to the MCSA: SQL 2016 Database Administration certification?

The MCSA: SQL 2016 Database Administration is retired and won't be getting replaced. Microsoft retired the entire series of MCSA and MCSE certifications, and the MCSA: SQL 2016 Database Administration was included in the certs that got retired without replacement. The certification didn't get revoked, so if you earned it already, it'll remain on your transcript. But it's no longer possible to take 70-764 and 70-765 or earn the MCSA.

What certification should I take instead of MCSA: SQL 2016 Database Administration?

You should consider the Microsoft Certified: Azure Database Administrator Associate if you want to earn a certification like the MCSA: SQL 2016 Database Administrator. When Microsoft retired the MCSA: SQL 2016 Database Administration and its two exams (70-764 and 70-765), they didn't set up a replacement. Instead, they've transitioned to role-based exams like the Azure Database Administrator Associate or the easier Microsoft Certified: Azure Data Fundamentals.

Is this MCSA: SQL 2016 Database Administration (70-764 & 70-765) still valuable?

Yes, this MCSA: SQL 2016 Database Administration is definitely still valuable. Training in SQL administration is still valuable because Microsoft didn't withdraw support for SQL Server or any other database administration software, they just changed their certification requirements. So although this training was designed to help you pass 70-764 and 70-765, taking it can still provide you with deep familiarity with administering and provisioning databases with SQL Server 2016.

Who is this for?

This MCSA: SQL 2016 Database Administrator training is considered associate-level Microsoft training, which means it was designed for database administrators. This MCSA: SQL 2016 Database Administrator course is valuable for new IT professionals with at least a year of experience with SQL database and experienced database administrators looking to validate their Microsoft skills.

What our learners say

It feels like the best and the brightest people are training with you — and they are just hanging out with you and showing you the ropes.
John McCann | IT manager and CBT Nuggets learner
CBT Nuggets is exactly what I needed.
Thomas S. | Systems Engineer & Consultant
I didn't ever think I'd have the position I have now.
Jenna B. | Service Operations Manager

Study plan

Download the free MCSA: SQL 2016 Database Administration Online Training study plan to complete this course in about 12 hours.

Download study plan