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 the core features and functionality of Azure Cosmos DB.

Learn how partitions are organized in Azure Cosmos DB and how to choose an appropriate partition key for your solution.

Learn how to develop client and server-side programming solutions on Azure Cosmos DB.