Audience profile

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

Prerequisites

• 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.

Course outline

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 2017

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

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

Perform Data Maintenance

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

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

• 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