MEAPSA

Deploy IaaS solutions with Azure SQL

Configure virtual machine sizing, storage, and networking options to ensure adequate performance for your database workloads. Choose and configure appropriate high availability options.

Data Analyst

Data Engineer

Database Administrator

Azure

SQL Server

SQL Database

Module Objectives

After completing this module, you will be able to:

Explore the basics of SQL Server in an Infrastructure as a Service (IaaS) offering
Learn the available options for provisioning and deployment
Deploy SQL Server into an Azure Virtual Machine

Units

Introduction min
Explain IaaS options to deploy SQL Server in Azure min
Understand hybrid scenarios min
Explore performance and security min
Explain high availability and disaster recovery options min
Exercise: Provision a SQL Server on an Azure Virtual Machine min
Knowledge check min
Summary min

Prerequisites

Familiarity with on-premises virtualization technologies, including: VMs, virtual networking, and virtual hard disks.
Familiarity with network configuration, including TCP/IP, Domain Name System (DNS), virtual private networks (VPNs), firewalls, and encryption technologies.
Ability to create an on-premises SQL Server database, including the configuration of data files and log files.
Experience creating and configuring resources using the Azure portal.