- 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)
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Create product catalog documents in the Data Explorer
- Perform Azure Cosmos DB queries
- Create and run operations on your documents by using stored procedures
After completing this module, you'll be able to describe the benefits and usage of:
In this module, you will learn:
In this module, you will:
In this module, you will:
In this module, you will:
In this module, you will:
In this module, you will:
In this module, you will:
