Plan and implement data platform resources

  • Learning Path
  • 5 Modules

At a glance

Deploy data platform resources in Azure SQL. Explore options for deployment and migration. Calculate resource requirements and create templates.

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.
  • Ability to write code in the SQL language, particularly the Microsoft T-SQL dialect, at a basic level.
  • Experience creating and configuring resources using the Azure portal.

Modules in this learning path

Prepare to maintain SQL databases on Azure

Explore the role of a database administrator on Azure. Describe SQL Server-based offerings on Azure.

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.

Deploy PaaS solutions with Azure SQL

Provision and deploy Azure SQL Database and Azure SQL managed instance. Select the appropriate options when performing a migration to the SQL PaaS platform.

Migrate SQL Server workloads to Azure SQL Database

You will explore different migration tools and migrate SQL Server databases to Azure SQL Database.

Migrate SQL Server workloads to Azure SQL Managed Instance

You'll explore different migration tools and migrate SQL Server databases to Azure SQL Managed Instance.