Deploy IaaS solutions with Azure SQL

Intermediate
Data Analyst
Data Engineer
Database Administrator
Azure
Azure SQL Database
SQL Server

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

Learning 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

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.