About The Administering a SQL Server Database Infrastructure 2016 (70-764) Exam
During this exam, you should be knowledgeable in the following areas:
- Configure data access and auditing (20–25%)
- Manage backup and restore of databases (20–25%)
- Manage and monitor SQL Server instances (35–40%)
- Manage high availability and disaster recovery (20–25%)
Microsoft currently charges $165 for this exam. Check the Microsoft site for confirmation and if any, updated information.
SQL Server 2016 – Module 1: Configure Encryption
- Introduction
- Exam Objectives and Lab Setup
- Restoring Adventure Works 2016 Database Lab Part 1
- Restoring Adventure Works 2016 Database Lab Part 2
- Restoring Adventure Works 2016 Database Lab Part 3
- Configure Encryption
- Cell-Level Encryption Part 1
- Cell-Level Encryption Part 2
- Cell-Level Encryption Lab Part 1
- Cell-Level Encryption Lab Part 2
- Transparent Data Encryption
- Transparent Data Encryption Lab
- Always Encrypted
- Always Encrypted Lab
- Backup Encryption
- Backup Encryption Lab
- Connection Encryption
- Encryption Troubleshooting
SQL Server 2016 – Module 2: Configure Data Access and Permissions
- Create and Maintain Users
- Create and Maintain Users Lab Part 1
- Create and Maintain Users Lab Part 2
- Configure and Maintain Custom Roles
- Configure and Maintain Custom Roles Lab
- Manage Database Object Permissions Part 1
- Manage Database Object Permissions Part 2
- Manage Database Object Permissions Lab Part 1
- Manage Database Object Permissions Lab Part 2
- Configure User Options for Azure SQL Database
- Configure Row-Level Security
- Configure Dynamic Data Masking
- Configure Dynamic Data Masking Lab
SQL Server 2016 – Module 3: Configure Auditing
- Manage a SQL Server Audit
- Manage a SQL Server Audit Lab
- Query the SQL Server Audit Log
- Manage an Azure SQL Server Audit
SQL Server 2016 – Module 4: Develop a Backup Strategy
- Backup Types Part 1
- Backup Types Part 2
- Manage, Backup, and Restore Databases Lab Part 1
- Manage, Backup, and Restore Databases Lab Part 2
- Backup Very Large Databases Part 1
- Backup Very Large Databases Part 2
- Backup Very Large Databases Part 3
- Backup Very Large Databases Part 4
- 4.9 Managing Very Large Databases Lab Part 1
- 4.10 Managing Very Large Databases Lab Part 2
- 4.11 Managing Very Large Databases Lab Part 3
- Configure Alerting for Failed Backups
- Configure Alerting for Failed Backups Lab Part 1
- Configure Alerting for Failed Backups Lab Part 2
- Back up Databases to Azure
- Manage Transaction Log Backups
- Configure Database Recovery Models
- Set Database Recovery Model Lab
- Configure Backup Automation
- Configure Backup Automation Lab
SQL Server 2016 – Module 5: Restore Databases
- Perform Piecemeal Restores
- Restore Databases Lab Part 1
- Restore Databases Lab Part 2
- Restore Databases Lab Part 3
- Perform Page Recovery
- Perform Point-in-Time Recovery
- Perform Point-in-Time Recovery Lab
- Restore File Groups
- Develop a Plan to Automate and Test Restores
SQL Server 2016 – Module 6: Manage Database Integrity
- Implement Database Consistency Checks
- Implement Database Consistency Checks Lab
- Identify Database Corruption
- Recover From Database Corruption
SQL Server 2016 – Module 7: Monitor Database Activity
- Monitor Current Sessions
- Monitor Current Sessions Lab
- Identify Sessions that Cause Blocking Activity
- Identify Sessions that Consume temp db Resources
- Configure the Data Collector
SQL Server 2016 – Module 8: Monitor Queries’
- Manage the Query Store
- Manage the Query Store Lab
- Configure Extended Events and Trace Events
- Identify Problematic Execution Plans
SQL Server – Module 9: Manage Indexes
- Identify and Repair Index Fragmentation
- Identify and Create Missing Indexes
- Identify and Drop Underutilized Indexes
- Manage Existing Column store Indexes Part 1
- Manage Existing Column store Indexes Part 2
- Partitioned Tables
SQL Server 2016 – Module 10: Monitor SQL Server Instances
- Create and Manage Operators
- Create and Manage SQL Agent Alerts
- Configure Policy Based Management
- Configure Policy Based Management Lab
- Identify Available Space on Data Volumes
- Identify the Cause of- Manage Performance Degradation
- Identify the Cause of- Manage Performance Degradation Lab Part 1-Part 2
SQL Server 2016 – Module 11: Implement Log Shipping
- Configure and Monitor Log Shipping
- Configure and Monitor Log Shipping Lab Part 1-Part 2
SQL Server 2016 – Module 12: Implement Failover Cluster Instances
- Windows Server Failover Cluster
- Manage Shared Disks
- Configure Cluster Shared Volumes
- Configuring WSFC Lab
SQL Server 2016 – Module 13: Implement Always On Availability Groups
- Database Mirroring
- Create an Availability Group
- Manage Failover
- Configure Read Only Routing
- Create Distributed Availability Groups
- Configuring Always On Availability Group Lab Part 1-Part 2
- Conclusion
