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

Architect a data platform in Azure

Microsoft via Microsoft Learn

Go to class Write review

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

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

Tags

united states

Reviews

Start your review of Architect a data platform in Azure