20765: Provisioning SQL 2016 Databases

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of Transact-SQL.
• Working knowledge of relational databases.
• Some experience with database design.

• Querying Data with Transact-SQL (20761)

• Provision a database server.
• Upgrade SQL Server.
• Configure SQL Server.
• Manage databases and files (shared).
• Provision, migrate and manage databases in cloud

• Individuals who administer and maintain SQL Server databases, performing database administration and maintenance as their primary area of responsibility, or who work in environments where databases play a key role in their primary job.
• Individuals who develop applications that deliver content from SQL Server databases.

1. SQL Server 2016 Components

• Introduction to the SQL Server Platform
• Overview of SQL Server Architecture
• SQL Server Services and Configuration Options

2. Installing SQL Server 2016

• Considerations for Installing SQL Server
• TempDB Files
• Installing SQL Server 2016
• Automating Installation

3. Upgrading SQL Server to SQL Server 2017

• Upgrade Requirements
• Upgrade SQL Server Services
• Migrating SQL Server Data and Applications

4. Working with Databases

• Introduction to Data Storage with SQL Server
• Managing Storage for System Databases
• Managing Storage for User Databses
• Moving and Copying Database Files
• Buffer Pool Extension

5. Perform Data Maintenance

• Ensuring Database Integrity
• Maintaining Indexes
• Automating Routine Database Maintenance

6. Database Storage Options

• SQL Server Storage Performance
• SMB Fileshare
• SQL Server Storage in Azure
• Stretch Databases

7. Planning to Deploy SQL Server on Microsoft Azure

• SQL Server Virtual Machines in Azure
• Azure Storage
• Azure SQL Authentication
• Deploying an Azure SQL Database

8. Migrating Databases to Azure SQL Database

• Database Migration Testing Tools
• Database Migration Compatibility Issues
• Migrating a SQL Server Database to Azure SQL Database

9. Deploying SQL Server on a Microsoft Azure Virtual Machine

• Deploying SQL Server on an Azure VM
###li/li###

10. Managing databases in the Cloud

• Managing Azure SQL Database Security
• Configure Azure storage
• Azure Automation