Architect a data platform in Azure

Intermediate
Solutions 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, we'll explore the benefits of Azure data storage versus on-premises storage.

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.

Learn how to create a data warehouse in Azure Synapse Analytics in minutes to take advantage of massively parallel processing (MPP) and run complex queries at petabyte scale quickly.

Load petabytes of data into an Azure Synapse Analytics database in minutes by using PolyBase.