Architect a data platform in Azure

Intermediate
Solution Architect
Azure
SQL Database
Synapse Analytics
Cosmos DB

Learn how to architect a data platform in Azure and build solutions to store relational and NoSQL data.

Prerequisites

  • Familiarity with relational databases
  • Familiarity with NoSQL databases

Modules in this learning path

In this module, you'll learn about several of the database services that are available on Microsoft Azure, such as Azure Cosmos DB, Azure SQL Database, Azure SQL Managed Instance, Azure Database for MySQL, and Azure Database for PostgreSQL. In addition, you'll learn about several of the big data and analysis services in Azure.

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

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

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.

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.

Learn how to create an Azure Cosmos DB account, database, and container built to scale as your application grows.

Learn how to distribute your data globally with Azure Cosmos DB.

Learn how to add data to your database and query NoSQL data in Azure Cosmos DB.