Work with relational data in Azure

  • Learning Path
  • 6 Modules
Intermediate
Developer
Data Engineer
Azure
SQL Database
Cloud Shell
CLIs

Azure supports several popular SQL-based database solutions including SQL Server, PostgreSQL, and MySQL. Learn how to use these enterprise data solutions in Azure to store and retrieve your app's data in the cloud. This learning path can help you prepare for the Microsoft Certified: Azure Developer Associate certification.

Prerequisites

None

Modules in this learning path

Provision an Azure SQL database to store application data

Use the Azure Portal and Cloud Shell to provision, connect, and manage Azure SQL databases.

Migrate your relational data stored in SQL Server to Azure SQL Database

Plan and implement the migration of relational data from SQL Server to Azure SQL Database. Select the appropriate migration strategy for your database, and then use Data Migration Assistant to do the assessment and the migration.

Introduction to Azure Database for PostgreSQL

This module is a no-code introduction to PostgreSQL on Azure, including an explanation of particular problems that using Azure Database for PostgreSQL can solve. At a high level, we show how the components fit together and identify situations where you should use Azure Database for PostgreSQL.

Scale multiple Azure SQL Databases with SQL elastic pools

SQL elastic pools allow you to manage performance and cost for a collection of SQL databases.

Secure your Azure SQL Database

Secure your Azure SQL Database to keep your data secure and diagnose potential security concerns as they happen.

Develop and configure an ASP.NET application that queries an Azure SQL database

Create a database on Azure SQL Database to store data for an application, and create an ASP.NET application to query data from the database.