Skip to content
CBT Nuggets

Microsoft MCSA: SQL 2016 Database Administration (70-764 & 70-765)

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.

Updated March 2019

16Skills
151Videos
21Virtual Labs
17h 40mTotal
151 videos21 labs17h 40m

Who This Course Is For

This MCSA: SQL 2016 Database Administrator training is considered associate-level Microsoft training, and 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 databases, and experienced database administrators looking to validate their Microsoft skills.

Skills Your Team Will Gain

  • 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 Instances management: database creation, file management, system database files
  • Storage management: overview, SMB file shares, service tiers, storage pools, storage recovery

Course Curriculum

  • Premium skill.Microsoft MCSA SQL Server 2016 (70-764): Overview14m
  • Premium skill.Microsoft MCSA SQL Server 2016 (70-764): Configure Encryption1h 8m + 1 lab
  • Premium skill.Microsoft MCSA SQL Server 2016 (70-764): Configure Data Access and Permissions1h 13m + 1 lab
  • Premium skill.Microsoft MCSA SQL Server 2016 (70-764): Configure Auditing57m + 1 lab
  • Premium skill.Microsoft MCSA SQL Server 2016 (70-764): Develop a Backup Strategy1h 15m + 1 lab
  • Premium skill.Microsoft MCSA SQL Server 2016 (70-764): Restore Databases57m + 1 lab
  • Premium skill.Microsoft MCSA SQL Server 2016 (70-764): Manage Database Integrity37m + 1 lab
  • Premium skill.Microsoft MCSA SQL Server 2016 (70-764): Monitor Database Activity40m + 1 lab
  • Premium skill.Microsoft MCSA SQL Server 2016 (70-764): Monitor Queries46m + 1 lab
  • Premium skill.Microsoft MCSA SQL Server 2016 (70-764): Manage Indexes39m + 1 lab
  • Premium skill.Microsoft MCSA SQL Server 2016 (70-764): Manage Statistics36m + 1 lab
  • Premium skill.Microsoft MCSA SQL Server 2016 (70-764): Monitor SQL Server Instances53m + 1 lab
  • Premium skill.Microsoft MCSA SQL Server 2016 (70-764): Implement Log Shipping34m + 1 lab
  • Premium skill.Microsoft MCSA SQL Server 2016 (70-764): Implement Always On Availability Groups54m + 1 lab
  • Premium skill.Microsoft MCSA SQL Server 2016 (70-764): Implement Failover Cluster Instances34m + 1 lab
  • Premium skill.Microsoft MCSA SQL Server 2016 (70-765)5h 42m + 7 labs

Readiness check

Confirm prerequisite knowledge before training begins

A short placement assessment on the CBT Nuggets assessments platform measures whether a learner already has the foundation this course assumes. IT Directors use it to put the right people in the right training — and any learner can take it right now to make sure they'll get full value from day one.

  • Questions generated from this course's own lesson transcripts — what gets measured is exactly what gets taught
  • Instant, per-learner results that show whether the prerequisite foundation is in place
  • Results roll up into team readiness reporting, so training hours go where they change outcomes

Runs on assessments.cbtnuggets.com — sign in with an Adept account so results roll up into team readiness reporting. Need one? Create an Adept account.

This course is included with every subscription

Get your team access to all 559 courses, virtual labs, and practice exams.

Most Popular

Team

$749per seat / year

5+ learner seats

Get Started

Enterprise

Customannual contracts

Any size

Contact Enterprise Sales

Just need this course?

Single-course enrollment — $99 for 1 year of access to SQL 2016 Database Administration.

Enroll in This Course
Calculate the ROI of training your team

Trusted by 23,000+ organizations

Frequently Asked Questions

Ready to upskill your team?

Talk to our sales team to find the right plan for your organization.