Plan and implement data platform resources

Intermediate
Data Engineer
Database Administrator
Azure
SQL Database
SQL Server

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

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

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

Describe database migration options and tools on Azure. Understand how compatibility level affects database behavior. Describe Azure private and public preview options.

In this module, you will learn to demonstrate the benefits and processes for moving a SQL Server database to Azure SQL Database.

Learners will be able to demonstrate the benefits and processes for moving a SQL Server database to an Azure SQL Database Managed Instance.