Microsoft 70-764 : Administering a SQL Database Infrastructure 2016
About this course
The Microsoft 70-764 SQL Server 2016 Administration course prepares student for the Microsoft Certification Exam 70-764. By the end of this course, you will be able to administer a Microsoft SQL 2016 server.
This Microsoft 70-764 SQL Server 2016 Administration course is for students intended for IT professionals responsible for installing, configuring and maintaining a Microsoft SQL Server environment. Students preparing for the 70-764 exam will typically will have at least 2 years of experience working with SQL Server.
Microsoft recommends having experience setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. You will be able to engage these topics on multiple platforms, including SQL Server 2016, SQL Server v.Next on Linux, and Azure SQL Databases. Students studying for the Microsoft Administering a SQL Database Infrastructure exam are database professionals who perform installation, maintenance, and configuration tasks.
In this Microsoft 70-764 SQL Server course, you will learn are how to configure Cell-level Encryption, Transparent Data Encryption, Always Encrypted, Backup Encryption, Connection Encryption, and Encryption Troubleshooting and ending with creating an Availability Group, manage failover, configure read-only routing and create distributed availability groups. Examining topics through the lenses of various platforms, comparing what they look like in SQL Server 2016, SQL Server v.Next on Linux, and Azure SQL Databases.
Students taking this course do so to sit for Exam 70-764 and want to become proficient about using Microsoft SQL server.
Course Syllabus
1. Configure Encryption
• In this topic, you will configure Cell-level Encryption, Transparent Data Encryption, Always Encrypted, Backup Encryption, Connection Encryption, and Encryption Troubleshooting.
2. Configure Data Access and Permissions
• In this topic, you will create and maintain users, create and maintain custom roles, manage database object permissions, configure user options for Azure SQL database, configure row-level security, and configure dynamic data masking.
3. Configure Auditing
• In this topic, you will manage a SQL Server audit, query the SQL server audit log, and manage an Azure SQL database audit.
4. Develop a Backup Strategy
• In this topic, you will 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.
5. Restore Databases
• In this topic, you will perform piecemeal restores, perform page recovery, perform point-in-time recovery, restore file groups, and develop a plan to automate and test restores.
6. Manage Database Integrity
• In this topic, you will implement database consistency checks, identify database corruption, and recover from database corruption.
7. Monitor Database Activity
• In this topic, you will monitor current sessions, identify sessions that cause blocking activity, identify sessions that consume tempdb resources, and configure the data collector.
8. Monitor Queries
• In this topic, you will manage the query store, configure extended events and trace events, and identify problematic execution plans.
9. Manage Indexes
• In this topic, you will identify and repair index fragmentation, identify and create
missing indexes, identify and drop underutilized indexes, manage existing
columnstore indexes, and manage statistics.
10. Monitor SQL Server Instances
• In this topic, you will 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 and manage performance degradation.
11. Implement Log Shipping
• In this topic, you will implement log shipping, implement failover cluster instances, and implement Always On Availability Groups.
12. Implement Failover Cluster Instances
• In this topic, you will manage shared disks and configure cluster shared volumes.
13. Implement Always On Availability Groups
• In this topic, you will create an Availability Group, manage failover, configure read-only routing, create distributed availability groups