MOC 20764-ADMINISTERING A SQL DATABASE INFRASTRUCTURE

SQL Server Security

- Authenticating Connections to SQL Server

- Authorizing Logins to Connect to databases

- Authorization Across Servers

- Partially Contained Databases

Assigning Server and Database Roles

- Working with server roles

- Working with Fixed Database Roles

- Assigning User-Defined Database Roles

Authorizing Users to Access Resources

- Authorizing User Access to Objects

- Authorizing Users to Execute Code

- Configuring Permissions at the Schema Level

Protecting Data with Encryption and Auditing

- Options for auditing data access in SQL Server

- Implementing SQL Server Audit

- Managing SQL Server Audit

- Protecting Data with Encryption

Recovery Models and Backup Strategies

- Understanding Backup Strategies

- SQL Server Transaction Logs

- Planning Backup Strategies

Backing Up SQL Server Databases

- Backing Up Databases and Transaction Logs

- Managing Database Backups

- Advanced Database Options

Restoring SQL Server 2016 Databases

- Understanding the Restore Process

- Restoring Databases

- Advanced Restore Scenarios

- Point-in-Time Recovery

Automating SQL Server Management

- Automating SQL Server management

- Working with SQL Server Agent

- Managing SQL Server Agent Jobs

- Multi-server Management

Configuring Security for SQL Server Agent

- Understanding SQL Server Agent Security

- Configuring Credentials

- Configuring Proxy Accounts

Monitoring SQL Server with Alerts and Notifications

- Monitoring SQL Server Errors

- Configuring Database Mail

- Operators, Alerts, and Notifications

- Alerts in Azure SQL Database

Introduction to Managing SQL Server by using PowerShell

- Getting Started with Windows PowerShell

- Configure SQL Server using PowerShell

- Administer and Maintain SQL Server with PowerShell

- Managing Azure SQL Databases using PowerShell

Tracing Access to SQL Server with Extended events

- Extended Events Core Concepts

- Working with Extended Events

Monitoring SQL Server

- Monitoring activity

- Capturing and Managing Performance Data

- Analyzing Collected Performance Data

- SQL Server Utility

Troubleshooting SQL Server

- A Trouble Shooting Methodology for SQL Server

- Resolving Service Related Issues

- Resolving Connectivity and Log-in issues

Importing and Exporting Data

- Transferring Data to and from SQL Server

- Importing and Exporting Table Data

- Using bcp and BULK INSERT to Import Data

- Deploying and Upgrading Data-Tier Application

MOC 20765: PROVISIONING SQL DATABASES

SQL SERVER 2016 COMPONENTS

- Introduction to the SQL Server Platform

- Overview of SQL Server Architecture

- SQL Server Services and Configuration Options

INSTALLING SQL SERVER 2016

- Considerations for installing SQL Server

- TempDB Files

- Installing SQL Server 2016

- Automating Installation

UPGRADING SQL SERVER TO SQL SERVER 2016

- Upgrade Requirements

- Upgrade SQL Server Services

- Migrating SQL Server Data and Applications

DEPLOYING SQL SERVER ON MICROSOFT AZURE

- SQL Server Virtual Machines in Azure

- Deploying an Azure SQL Database

- Migrating an On-Premise Database to an Azure SQL Database

WORKING WITH DATABASES

- Overview of SQL Server Databases

- Creating Databases

- Database Files and Filegroups

- Moving Database Files

- Buffer Pool Extension

DATABASE STORAGE OPTIONS

- SQL Server storage Performance

- SMB Fileshare

- SQL Server Storage in Azure

- Stretch Databases

PLANNING TO DEPLOY SQL SERVER ON MICROSOFT AZURE

- SQL Server Virtual Machines in Azure

- Azure Storage

- Azure SQL Authentication

- Deploying an Azure SQL Database

MIGRATING DATABASES TO AZURE SQL DATABASE

- Database Migration Testing Tools

- Database Migration Compatibility Issues

- Migrating a SQL Server Database to Azure SQL Database

DEPLOYING SQL SERVER ON A MICROSOFT AZURE VIRTUAL MACHINE

- Automating Routine Database Maintenance

- Deploying SQL Server on an Azure VM

- The Deploy Database to a Microsoft Azure VM Wizard

MANAGING DATABASES IN THE CLOUD

- Managing Azure SQL Database Security

- Configure Azure storage

- Azure Automation