Plan and implement data platform resources

Intermediate
Data Engineer
Database Administrator
Azure
SQL Database
SQL Server

Deploy data platform resources in Azure for SQL Server and Open Source databases. Explore options for upgrade 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 a 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. Investigate options for migrating existing workloads.

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

Compare Open Source Azure Database offerings with Azure SQL offerings. Configure an Open Source database and configure high availability and security options.