Microsoft Certified
| # | Certified | Exam |
| 1 | Azure Data Fundamentals | Exam DP-900 |
| 2 | Azure Database Administrator Associate | Exam DP-300 |
| 3 | Azure Data Engineer Associate | Exam DP-203 |
Azure Data Fundamentals , Learning paths
1.1 Explore core data concepts
- Introduction to Azure SQL Database
- Introduction to Azure Blob storage
- Introduction to Azure Cosmos DB
- Description of the database normalization basics
1.2 Explore roles and responsibilities in the world of data
- Overview of Azure Databricks
- Overview of Azure HDInsight
- Introduction to Azure Cosmos DB
- Overview of Power BI
- SQL Server Technical Documentation
- Introduction to Azure Data Factory
1.3 Describe concepts of relational data
- Description of the database normalization basics
- Structured Query Language (SQL)
- Technical overview of SQL Database
- SQL Server Technical Documentation
- SQL Database PaaS vs IaaS Offerings
1.4 Explore concepts of non-relational data
- Welcome to Azure Cosmos DB
- Indexing in Azure Cosmos DB – Overview
- Introduction to Azure Cosmos DB: Table API
- Introduction to Azure Cosmos DB: Gremlin API
- Introduction to Azure Blob storage
1.5 Explore concepts of data analytics
- Create reports and dashboards in Power BI – documentation
- Azure Databricks
- Azure Cognitive Services
- Extract, transform, and load (ETL)
2.Explore relational data in Azure
2.1 Explore relational data services in Azure
- Choose the right deployment option
- What is a single database in Azure SQL Database
- What is Azure SQL Database managed instance?
- Data Migration Assistant (DMA)
- Azure Database Migration Service (DMS)
- Choose the right data store
- Transport Layer Security
- Transparent Data Encryption
- Always Encrypted
2.2 Explore provisioning and deploying relational database services in Azure
- Create an Azure Database for PostgreSQL
- Create an Azure Database for MySQL
- Create an Azure single Database
- Azure SQL Database documentation
- PostgreSQL Server parameters
- PostgreSQL extensions in Azure Database for PostgreSQL – Single Server
- How to configure server parameters in Azure Database for MySQL by using the Azure portal
2.3 Query relational data in Azure
- sqlcmd Utility
- Download and install Azure Data Studio
- Download SQL Server Management Studio (SSMS)
- Tutorial: Design a relational database in a single database within Azure SQL using SSMS
- MySQL Community Downloads
- Azure Database for MySQL: Use MySQL Workbench to connect and query data
- Quickstart: Use the Azure portal’s query editor to query a database
- DML Queries with SQL
- Joins (SQL Server)
3.Explore non-relational data in Azure
3.1 Explore non-relational data offerings in Azure
- Understanding the Table service data model
- Azure Table storage table design guide: Scalable and performant tables
- Introduction to Azure Blob storage
- Introduction to Azure Data Lake Storage Gen2
- Static website hosting in Azure Storage
- What is Azure Files?
- Planning for an Azure Files deployment
- Welcome to Azure Cosmos DB
- Indexing in Azure Cosmos DB – Overview
- Consistency levels in Azure Cosmos DB
3.2 Explore provisioning and deploying non-relational data services in Azure
- What is Azure CLI
- Azure PowerShell documentation
- What are Azure Resource Manager templates?
- Built-in Jupyter notebooks in Azure Cosmos DB
- What is Azure Private Endpoint?
- Manage Azure Cosmos DB Core (SQL) API resources with Azure Resource Manager templates
- Configure Azure Storage firewalls and virtual networks
- Create or update Azure custom roles using the Azure portal
- Add or remove Azure role assignments using the Azure portal
- What is Azure Active Directory?
3.3 Manage non-relational data stores in Azure
- Common Azure Cosmos DB use cases
- Migrate normalized database schema from Azure SQL Database to Azure CosmosDB denormalized container
- Copy and transform data in Azure Cosmos DB (SQL API) by using Azure Data Factory
- Quickstart: Build a console app using the .NET V4 SDK to manage Azure Cosmos DB SQL API account resources
- Getting started with SQL queries
- az storage container create
- New-AzStorageContainer
- az storage blob upload
- Set-AzStorageBlobContent
- az storage blob list
- Get-AzStorageBlob
- az storage blob download
- az storage blob download-batch Get-AzStorageBlobContent
- az storage blob delete
- Remove-AzStorageBlob
- az storage blob delete-batch
- az storage container delete
- Remove-AzStorageContainer
- Get started with AzCopy
- Azure Storage Explorer
- Transfer data with AzCopy and file storage
4.Explore modern data warehouse analytics in Azure