If you're new to data work
We start with what data even is, structured versus not, before touching a single Azure service.
If you're exam-bound
The four DP-900 domains are weighted the way the real exam is, relational and non-relational data get equal, heavy focus.
1. Core data concepts
15–20% of exam
1.1 What data actually is: structured, semi-structured, unstructuredFree preview
1.2 Transactional vs. analytical workloads (OLTP vs. OLAP)Locked
1.3 Who works with data: DBA, data engineer, data analystLocked
2. Relational data on Azure
25–30% of exam
2.1 Relational concepts: tables, keys, normalizationLocked
2.2 SQL basics: actually querying dataLocked
2.3 Azure SQL Database, Managed Instance, and SQL on VMsLocked
2.4 Azure Database for PostgreSQL and MySQLLocked
3. Non-relational data on Azure
25–30% of exam
3.1 Non-relational concepts: key-value, document, graphLocked
3.2 Azure Cosmos DB and its APIsLocked
3.3 Azure Storage: blobs, files, and tablesLocked
3.4 Choosing relational vs. non-relational for a workloadLocked
4. Analytics on Azure
25–30% of exam
4.1 Data warehousing and ETL vs. ELTLocked
4.2 Microsoft Fabric and Synapse AnalyticsLocked
4.3 Power BI fundamentalsLocked
4.4 Streaming and real-time analytics basicsLocked
Capstone
Practical build
Design a simple data platform for a real business scenario, relational and non-relational bothLocked