DP-900: Microsoft Azure Data Fundamentals
Overview
DP-900 is the entry-level certification for understanding core data concepts and services in
Microsoft Azure. It’s designed for individuals beginning their journey in cloud-based data
solutions and analytics. This course provides a foundational understanding of database types,
data processing, and key Azure data services — both relational and non-relational.
Ideal for aspiring data professionals, business users, or anyone looking to understand the data ecosystem in Azure, it helps bridge the gap between business needs and cloud-based data capabilities.
Ideal for aspiring data professionals, business users, or anyone looking to understand the data ecosystem in Azure, it helps bridge the gap between business needs and cloud-based data capabilities.
What You’ll Learn
By the end of this course, you’ll be able to:
- Understand fundamental data concepts (structured, semi-structured, unstructured)
- Differentiate between relational and non-relational data types
- Explore data workloads: transactional vs analytical
- Identify core Azure data services like Azure SQL, Cosmos DB, Synapse, and Data Lake
- Understand basics of data security, privacy, and compliance in Azure
- Describe provisioning, pricing, and deployment considerations for Azure data services
Prerequisites
- No prior experience with Azure or databases required
- Suitable for business users, students, and entry-level IT/data professionals
- Familiarity with cloud concepts (e.g., AZ-900) is helpful but not required
Course Content Outline
1. Describe Core Data Concepts
- Types of data: structured, semi-structured, unstructured
- Data roles: database administrator, data engineer, data analyst
- OLTP vs OLAP workloads
- Data analytics and visualization basics
2. Describe How to Work with Relational Data on Azure
- Relational database concepts and normalization
- Azure SQL Database, SQL Managed Instance, and SQL Server on Azure VMs
- Querying and managing relational data
- Security and scalability of relational databases
3. Describe How to Work with Non-relational Data on Azure
- Overview of NoSQL and non-relational models
- Azure Cosmos DB: key-value, document, graph, and column-family stores
- Use cases for non-relational databases
- Choosing the right data store for workloads
4. Describe an Analytics Workload on Azure
- Data ingestion and transformation
- Azure Synapse Analytics for big data and enterprise BI
- Azure Data Factory: data movement and orchestration
- Real-time analytics using Azure Stream Analytics
- Data visualization with Power BI (basic overview)