Course Overview

Learn the key skills you need to provision SQL Server instances both on premises and using the cloud-based Azure service.

Course Circullum

Introduction

Welcome
Using the exercise files
What you should know

1. Deploy Microsoft Azure SQL Database

Create servers and databases
Choose a service tier
Create a server admin account
Configure elastic pools

2. Plan for a SQL Server Installation

Plan for an IaaS or on-premises deployment
Size a virtual machine
Performance-based storage pools
Evaluate best practices for installation

3. SQL Server Instances

Provision an Azure VM
Storage layouts for a SQL Server VM
Install SQL Server on an Azure VM
Automate the deployment of SQL Server
Deploy SQL Server using templates

4. Configure Secure Access to Azure SQL Databases

Configure firewall rules
Enable transparent data encryption
Enable Always Encrypted
Configure dynamic data masking

5. Configure SQL Performance Settings

SQL database performance settings
Configure max server memory
Configure the database scope
Create operators and alerts

6. Manage SQL Server Instances

Create databases
Install Management Studio
Manage user database files
Manage system database files
Configure tempdb

7. Deploy Applications to Azure SQL Database

Support multiple tenants
Migrate SQL Server to Azure SQL Database
Migrate data to Azure SQL Database

8. Deploy Applications to SQL Server on Azure VMs

Migrate SQL Server databases to Azure VM
Generate benchmark data
Support availability sets in Azure

9. Migrate Client Applications

Configure application connection strings
Manage traffic
Application retry logic

Conclusion

Next steps

Adam Wilbert

out of 5.0

5 Star 85%

4 Star 75%

3 Star 53%

1 Star 20%

Item Reviews - 3

Submit Reviews

5 stars 4 stars 3 stars 2 stars 1 star

Name

Review

Free Trial Available

Enroll Now

This Course Include: