MCSA: SQL 2016 Database Administration – Exam:70-764: Administering a SQL Database Infrastructure

About this course:

This course is ideal for professionals in the database field who perform tasks of installation, maintenance and configuration. Other skills you will learn includes setting up database systems, ensuring that they operate efficiently, and storing, backing up and securing data from unauthorised access on a regular basis.

Study Mode:

Online Only. Instructor Led E- Learning

Course Fees:

To Enrol for this course or to find out more on pricing or payment methods, please contact our Learning Consultants. Click here –  Contact Us 

If you are looking at completing more than one Certification in the next 12 months, it might be worthwhile looking at our Course Subscription option. To find out more Click here – Subscription option. 


Administration provider and located in Australia. Powered by Skillsoft content

Career Opportunities:
  • Database Administrators
  • Database Engineers
  • SQL Administrators
  • SQL Engineers
  • SQL Coders
  • Web Developers
  • IT Programmers
  • Systems Engineers
  • Systems Administrators
  • App Developers

Global Recognition. Requires sitting for the Microsoft Certification exam: 98-361: Software Development Fundamentals

Pre Requisites:

None for the course.

Course location:

Online – 100% Flexible Self Study – You study at your own pace, at your own time. You have 24 hours access via your own private study portal.

Course Length:

30 hours – (depends on the learner, how quickly they pick the skills is up to the student) you have 6 months (180 days) months access to your course material. You have more than enough time to complete this short course.

** Part – time students dedicate on average 5 hours study time per week. This course would approximately take 6-8 weeks to complete at that pace of study.

Start date:

Within 3 working days payment confirmation and enrolment form completed or you can pick your own start date!

What will I Learn/ Extra Information:
  • Encryption
  • Data Access & Permissions
  • Data Security & Azure SQL Database Options
  • Auditing
  • Backup Management
  • Database Restoration
  • File & Piecemeal Restores
  • Managing Database Integrity
  • Monitoring Database Activity
  • Monitoring Queries
  • Database Mail & Alerts
  • Policy-based Management & Performance Monitoring
  • Index & Statistical Management
  • Log Shipping & High Availability
E Books  Included
Labs: Included

More Info on


Configure data access and auditing (20–25%)
  1. Configure encryption
  2. Implement cell-level encryption, implement Always Encrypted, implement backup encryption, configure transparent data encryption, configure encryption for connections, troubleshoot encryption errors
  3. Configure data access and permissions
  4. Manage database object permissions, create and maintain users, create and maintain custom roles, configure user options for Azure SQL Database, configure row-level security, configure dynamic data masking
  5. Configure auditing
  6. Configure an audit on SQL Server, query the SQL Server audit log, manage a SQL Server audit, configure an Azure SQL Database audit, analyze audit logs and reports from Azure SQL Database
Manage backup and restore of databases (20–25%)
  1. Develop a backup strategy
  2. Back up very large databases, configure alerting for failed backups, back up databases to Azure, manage transaction log backups, configure database recovery models, configure backup automation
  3. Restore databases
  4. Perform piecemeal restores, perform page recovery, perform point-in-time recovery, restore file groups, develop a plan to automate and test restores
  5. Manage database integrity
  6. Implement database consistency checks, identify database corruption, recover from database corruption
Manage and monitor SQL Server instances (35–40%)
  1. Monitor database activity
  2. Monitor current sessions, identify sessions that cause blocking activity, identify sessions that consume tempdb resources, configure the data collector
  3. Monitor queries
  4. Manage the Query Store, configure Extended Events and trace events, identify problematic execution plans, troubleshoot server health using Extended Events
  5. Manage indexes
  6. Identify and repair index fragmentation, identify and create missing indexes, identify and drop underutilized indexes, manage existing columnstore indexes
  7. Manage statistics
  8. Identify and correct outdated statistics, implement Auto Update Statistics, implement statistics for large tables
  9. Monitor SQL Server instances
  10. Create and manage operators, create and manage SQL Agent alerts, define custom alert actions, define failure actions, configure database mail, configure Policy-Based Management, identify available space on data volumes, identify the cause of performance degradation

Manage high availability and disaster recovery (20–25%)
  1. Implement log shipping
  2. Configure log shipping, monitor log shipping
  3. Implement AlwaysOn Availability Groups
  4. Configure Windows clustering, create an availability group, configure read-only routing, manage failover, create distributed availability groups
  5. Implement failover cluster instances
  6. Manage shared disks, configure cluster shared volumes
How to Enrol for this Course

For the Subscription option please click below on the Subscribe Here button.

For the Individual course, please contact us via live chat or click below on the Contact CertHub button.