Architect a data platform in Azure
- Offered byMicrosoft
Architect a data platform in Azure at Microsoft Overview
Duration | 8 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Architect a data platform in Azure at Microsoft Highlights
- Learn about several of the big data and analysis services in Azure
- 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
- Know about Load petabytes of data into an Azure Synapse Analytics database in minutes by using PolyBase
Architect a data platform in Azure at Microsoft Course details
- Explore Azure database and analytics services
- Provision an Azure SQL database to store application data
- Scale multiple Azure SQL Databases with SQL elastic pools
- Migrate your relational data stored in SQL Server to Azure SQL Database
- Create an Azure Cosmos DB database built to scale
- Distribute your data globally with Azure Cosmos DB
- Learn about several of the database services that are available on Microsoft Azure
- SQL elastic pools allow you to manage performance and cost for a collection of SQL databases
- Learn how to create an Azure Cosmos DB account, database, and container built to scale as your application grows
- The appropriate migration strategy for your database
Architect a data platform in Azure at Microsoft Curriculum
MODULE: 1 Explore Azure database and analytics services
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
MODULE: 2 Provision an Azure SQL database to store application data
Plan your Azure SQL database
Exercise - Create your Azure SQL database
Exercise - Connect to your database and add sample data
MODULE: 3 Scale multiple Azure SQL Databases with SQL elastic pools
Create a SQL elastic pool
Exercise - Create a SQL elastic pool
Manage SQL elastic pools performance and cost
Exercise - Manage SQL elastic pools
MODULE: 4 Migrate your relational data stored in SQL Server to Azure SQL Database
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
MODULE: 5 Develop and configure an ASP.NET application that queries an Azure SQL database
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
MODULE: 6 Create an Azure Cosmos DB database built to scale
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
MODULE: 7 Distribute your data globally with Azure Cosmos DB
Exercise - Distribute data globally
Write to multiple regions
Exercise - Change global read and write priorities
Choose a consistency level
MODULE: 8 Insert and query data in your Azure Cosmos DB database
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
MODULE: 9 Design a data warehouse with Azure Synapse Analytics
Understand Azure Synapse Analytics
Azure Synapse Analytics features
Types of solution scenarios
Understand massively parallel processing concepts
Table geometries
Exercise - Create a data warehouse in Azure Synapse Analytics by using the portal
MODULE: 10 Import data into Azure Synapse Analytics by using PolyBase
Introduction to PolyBase
Exercise - Create a blank Azure Synapse Analytics workspace
Exercise - Create a blob container for the source data
Exercise - Upload data to an Azure Blob storage container
Exercise - Retrieve the URL and access key for the storage account
Exercise - Import data from blob storage to Azure Synapse Analytics by using PolyBase
Architect a data platform in Azure at Microsoft Entry Requirements
- Prerequisites: Familiarity with relational databases & NoSQL databases
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?