MS 20764C:Administering a SQL Database Infrastructure Training Course

Module 1: SQL Server Security for Government

Authenticating Connections to SQL Server

Authorizing Logins to Connect to Databases

Authorization Across Servers

Partially Contained Databases

Create Logins

Create Database Users

Correct Application Login Issues for Government

Configure Security for Restored Databases for Government

Module 2: Assigning Server and Database Roles for Government

Working with Server Roles for Government

Working with Fixed Database Roles for Government

Assigning User-Defined Database Roles for Government

Assigning Server Roles for Government

Assigning Fixed Database Roles for Government

Assigning User-Defined Database Roles for Government

Verifying Security for Government

Module 3: Authorizing Users to Access Resources for Government

Authorizing User Access to Objects for Government

Authorizing Users to Execute Code for Government

Configuring Permissions at the Schema Level for Government

Granting, Denying, and Revoking Permissions on Objects for Government

Granting EXECUTE Permissions on Code for Government

Granting Permissions at the Schema Level for Government

Module 4: Protecting Data with Encryption and Auditing for Government

Options for Auditing Data Access in SQL Server for Government

Implementing SQL Server Audit for Government

Managing SQL Server Audit for Government

Protecting Data with Encryption for Government

Working with SQL Server Audit for Government

Encrypt a Column as Always Encrypted for Government

Encrypt a Database Using TDE for Government

Module 5: Recovery Models and Backup Strategies for Government

Understanding Backup Strategies for Government

SQL Server Transaction Logs for Government

Planning Backup Strategies for Government

Plan a Backup Strategy for Government

Configure Database Recovery Models for Government

Module 6: Backing Up SQL Server Databases for Government

Backing Up Databases and Transaction Logs for Government

Managing Database Backups for Government

Advanced Database Options for Government

Backing Up Databases for Government

Performing Database, Differential, and Transaction Log Backups for Government

Performing a Partial Backup for Government

Module 7: Restoring SQL Server 2016 Databases for Government

Understanding the Restore Process for Government

Restoring Databases for Government

Advanced Restore Scenarios for Government

Point-in-Time Recovery for Government

Restoring a Database Backup for Government

Restring Database, Differential, and Transaction Log Backups for Government

Performing a Piecemeal Restore for Government

Module 8: Automating SQL Server Management for Government

Automating SQL Server Management for Government

Working with SQL Server Agent for Government

Managing SQL Server Agent Jobs for Government

Multi-Server Management for Government

Create a SQL Server Agent Job for Government

Test a Job for Government

Schedule a Job for Government

Configure Master and Target Servers for Government

Module 9: Configuring Security for SQL Server Agent for Government

Understanding SQL Server Agent Security for Government

Configuring Credentials for Government

Configuring Proxy Accounts for Government

Analyzing Problems in SQL Server Agent for Government

Configuring a Credential for Government

Configuring a Proxy Account for Government

Configuring and Testing the Security Context of a Job for Government

Module 10: Monitoring SQL Server with Alerts and Notifications for Government

Monitoring SQL Server Errors for Government

Configuring Database Mail for Government

Operators, Alerts, and Notifications for Government

Alerts in Azure SQL Database for Government

Configuring Database Mail for Government

Configuring Operators for Government

Configuring Alerts and Notifications for Government

Testing Alerts and Notifications for Government

Module 11: Introduction to Managing SQL Server Using PowerShell for Government

Getting Started with Windows PowerShell for Government

Configure SQL Server Using PowerShell for Government

Administer and Maintain SQL Server with PowerShell for Government

Managing Azure SQL Databases Using PowerShell for Government

Getting Started with PowerShell for Government

Using PowerShell to Change SQL Server Settings for Government

Module 12: Tracing Access to SQL Server with Extended Events for Government

Extended Events Core Concepts for Government

Working with Extended Events for Government

Using the System_Health Extended Events Session for Government

Tracking Page Splits Using Extended Events for Government

Module 13: Monitoring SQL Server for Government

Monitoring Activity for Government

Capturing and Managing Performance Data for Government

Analyzing Collected Performance Data for Government

SQL Server Utility for Government

Module 14: Troubleshooting SQL Server for Government

A Troubleshooting Methodology for SQL Server for Government

Resolving Service-Related Issues for Government

Resolving Connectivity and Login Issues for Government

Troubleshoot and Resolve an SQL Login Issue for Government

Troubleshoot and Resolve a Service Issue for Government

Troubleshoot and Resolve a Windows Login Issue for Government

Troubleshoot and Resolve a Job Execution Issue for Government

Troubleshoot and Resolve a Performance Issue for Government

Module 15: Importing and Exporting Data for Government

Transferring Data to and from SQL Server for Government

Importing and Exporting Table Data for Government

Using bcp and BULK INSERT to Import Data for Government

Deploying and Upgrading Data-Tier Applications for Government

Import Excel Data Using the Import Wizard for Government

Import a Delimited Text File Using bcp for Government

Import a Delimited Text File Using BULK INSERT for Government

Create and Test an SSIS Package to Extract Data for Government

Deploy a Data-Tier Application for Government