Provisioning SQL Databases (20765)

This module describes the various SQL Server 2016 components and versions.

Lessons

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

Lab: Discussion: SQL Server versions

• When we do use a separate installation of SQL Server and when would use a separate instance?
• Which version of SQL Server is most suitable in your organization?

After completing this module, you will be able to:

• Describe SQL Server components and versions
• Describe SQL Server architecture and resource usage
• Describe SQL Server services and how you manage the configuration of those services

This modules describes the process to install SQL Server 2016.

Lessons

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

Lab: Installing SQL Server

• Assess the available resources
• Install an instance of SQL Server
• Perform post installation checks
• Automating Installation

After completing this module, you will be able to:

• Describe the considerations when installing SQL Server
• Describe TempDB files
• Install SQL Server 2016
• Automate a SQL Server installation

This module describes the process for upgrading to SQL Server 2016.

Lessons

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

Lab: Upgrading SQL Server

• Create the Application Logins
• Restore Database Backups
• Orphaned Users and Database Compatibility Level

After completing this module, you will be able to:

• Describe the upgrade requirements for SQL Server
• Upgrade SQL Server
• Migrate SQL Server data and applications

This module describes the preinstalled system databases, the physical structure of databases and the most common configuration options related to them.

Lessons

• Introduction to Data Storage with SQL Server
• Managing Storage for System Databases
• Managing Storage for User Databases
• Moving and Copying Database Files
• Side-by-Side Upgrade: Migrating SQL Server Data and Applications
• Buffer Pool Extension

Lab: Managing Database Storage

• Configuring tempDB Storage
• Creating Databases
• Attaching a Database
• Enable Buffer Pool Extension

After completing this module, you will be able to:

• Describe Data Storage with SQL Server
• Manage Storage for System Databases
• Manage Storage for User Databases
• Move and Copy Database Files
• Describe the Side-by-Side Upgrade: Migrating SQL Server Data and Applications process
• Describe and use Buffer Pool Extensions

This module covers database maintenance plans.

Lessons

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

Lab: Performing Database Maintenance

• Use DBCC CHECKDB to Verify Database Integrity
• Rebuild Indexes
• Create a Database Maintenance Plan

After completing this module, you will be able to:

• Ensure Database Integrity
• Maintain Indexes
• Automate Routine Database Maintenance

Describe SQL Server storage options.

Lessons

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

Lab: Implementing Stretch Database

• Run Stretch Database Advisor
• Implement Stretch Database

After completing this module, you will be able to:

• Describe SQL Server Storage Performance
• Describe SMB Fileshare
• Explain SQL Server Storage in Microsoft Azure.
• Describe Stretch Database

This module describes how to plan to deploy SQL Server on Azure.

Lessons

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

Lab: Plan and Deploy an Azure SQL Database

• Plan an Azure SQL Database, Networking, performance tiers, security
• Provision an Azure SQL Database
• Connect to an Azure SQL Database

After completing this module, you will be able to:

• Describe SQL Server Virtual Machines in Azure
• Describe Azure Storage
• Explain Azure SQL Authentication, auditing and compliance
• Deploy an Azure SQL Database

This module describes how to migrate databases to Azure SQL Database.

Lessons

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

Lab: Migrating SQL Server Databases to Azure

• Perform Migration Testing
• Migrate a SQL Server Database to Azure SQL Database
• Test a Migrated Database

After completing this module, you will be able to:

• Describe various database migration testing tools
• Explain database migration compatibility issues
• Migrate a SQL Server database to Azure SQL database

This module describes how to deploy SQL Server on Microsoft Azure VMs.

Lessons

• Deploying SQL Server on an Azure VM
• The Deploy Database to a Microsoft Azure VM Wizard

Lab: Deploying SQL Server on an Azure Virtual Machine

• Provision an Azure VM
• Use the Deploy Database to Azure VM Wizard

After completing this module, you will be able to:

• Deploy SQL Server on an Azure VM
• Use The Deploy Database to a Microsoft Azure VM Wizard

This module describes how to manage SQL Server on Azure.

Lessons

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

Lab: Managing Databases in the Cloud

• Configure Azure Security
• Automate Azure Deployment

After completing this module, you will be able to:

• Manage Azure SQL Database Security
• Configure Azure storage
• Implement Azure Automation