Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Microsoft

Architect a data platform in Azure

Microsoft via Microsoft Learn

Overview

  • Module 1: Learn about 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, Azure Database for PostgreSQL, as well as big data and analytics. (AZ-900)
  • After completing this module, you'll be able to describe the benefits and usage of:

    • Azure Cosmos DB
    • Azure SQL Database
    • Azure SQL Managed Instance
    • Azure Database for MySQL
    • Azure Database for PostgreSQL
    • Azure Synapse Analytics
    • Azure HDInsight
    • Azure Databricks
    • Azure Data Lake Analytics
  • Module 2: Find out what makes Azure SQL Database a good choice for your relational database, how to create the database from the portal and connect with Azure Cloud Shell.
  • In this module, you will learn:

    • Why Azure SQL Database is a good choice for running your relational database
    • What configuration and pricing options are available for your Azure SQL database
    • How to create an Azure SQL database from the portal
    • How to use Azure Cloud Shell to connect to your Azure SQL database, add a table, and work with data
  • Module 3: Learn how to create SQL elastic pools and how to use them to manage performance and cost for a collection of SQL databases.
  • In this module, you will:

    • Create an elastic pool
    • Add databases to an elastic pool
    • Configure database performance in an elastic pool
  • Module 4: 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.
  • In this module, you will:

    • Select a migration strategy for your relational data stored in SQL Server
    • Perform a migration from SQL Server to a single Azure SQL database by using the process of migration with downtime
  • Module 5: Create an Azure SQL database to store data for an application, and create an ASP.NET application to query data from the database.
  • In this module, you will:

    • Create, configure, and populate a single database in SQL Database
    • Configure an ASP.NET application to query the database
  • Module 6: Learn how to create an Azure Cosmos DB account, database, and container built to scale as your application grows.
  • In this module, you will:

    • Create a NoSQL database with Azure Cosmos DB
    • Set the initial throughput volume for your database using request units
    • Choose a partition key
    • Create a database and container in Azure Cosmos DB
  • Module 7: Discover the benefits of writing and replicating customized data to regions around the world with Azure Cosmos DB global distribution.
  • In this module, you will:

    • Learn about the benefits of writing and replicating data to multiple regions around the world
    • Change the read and write priorities for the regions in which your data is located
    • Change the consistency setting for your database
  • Module 8: Discover the Azure Cosmos DB Data Explorer tool that enables you to add or modify data. Create stored procedures in JavaScript.
  • In this module, you will:

    • Create product catalog documents in the Data Explorer
    • Perform Azure Cosmos DB queries
    • Create and run operations on your documents by using stored procedures

Syllabus

  • Module 1: Explore Azure database and analytics services
    • Introduction
    • Explore Azure Cosmos DB
    • Explore Azure SQL Database
    • Exercise - Create a SQL database
    • Explore Azure database for MySQL
    • Explore Azure Database for PostgreSQL
    • Explore Azure SQL Managed Instance
    • Explore big data and analytics
    • Knowledge check
    • Summary
  • Module 2: Provision an Azure SQL database to store application data
    • Introduction
    • Plan your Azure SQL database
    • Exercise - Create your Azure SQL database
    • Exercise - Connect to your database and add sample data
    • Summary and cleanup
  • Module 3: Scale multiple Azure SQL Databases with SQL elastic pools
    • Introduction
    • Create a SQL elastic pool
    • Exercise - Create a SQL elastic pool
    • Manage SQL elastic pools performance and cost
    • Exercise - Manage SQL elastic pools
    • Knowledge Check
    • Summary
  • Module 4: Migrate your relational data stored in SQL Server to Azure SQL Database
    • Introduction
    • Exercise - Environment setup
    • Migration process overview
    • Exercise - Assess a database by using Data Migration Assistant
    • Migration with downtime
    • Exercise - Migrate a database schema by using Data Migration Assistant
    • Exercise - Migrate a database with downtime by using Azure Database Migration Service
    • Summary
  • Module 5: Develop and configure an ASP.NET application that queries an Azure SQL database
    • Introduction
    • Create tables, bulk import, and query data
    • Exercise - Create tables, bulk import, and query data
    • Connect an ASP.NET application to Azure SQL Database
    • Exercise - Connect an ASP.NET application to Azure SQL Database
    • Summary
  • Module 6: Create an Azure Cosmos DB database built to scale
    • Introduction
    • Exercise - Create an Azure Cosmos DB account in the Azure portal
    • What is a request unit?
    • Choose a partition key in Azure Cosmos DB
    • Exercise - Create a database and container in Azure Cosmos DB using the portal
    • Exercise - Create a database and container in Azure Cosmos DB programmatically
    • Summary and cleanup
  • Module 7: Distribute your data globally with Azure Cosmos DB
    • Introduction
    • Exercise - Distribute data globally
    • Write to multiple regions
    • Exercise - Change global read and write priorities
    • Choose a consistency level
    • Summary and cleanup
  • Module 8: Insert and query data in your Azure Cosmos DB database
    • Introduction
    • Exercise - Set up your Azure Cosmos DB database and container
    • Exercise - add data using Data Explorer
    • Explore SQL query types
    • Exercise - run queries using Data Explorer
    • Define stored procedures and user-defined functions
    • Exercise - run complex operations on your data
    • Summary

Reviews

Start your review of Architect a data platform in Azure

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.