Training course
This is a free, self-paced reading course for DP-900: Microsoft Certified: Azure Data Fundamentals, the entry-level data credential in Microsoft’s 900-series, alongside AZ-900 and AI-900. DP-900 does not ask you to have run a production data platform. It asks whether you can hold the map in your head: structured against semi-structured against unstructured data, relational against non-relational stores, transactional against analytical workloads, and where each Azure data service sits on that map. Reading is how you build the map; practice questions are how you find the holes in it.
The course is organized as one module per official exam domain, in the order Microsoft publishes them, and each module carries the domain’s published weight. Core Data Concepts and Analytics Workload are the two heaviest domains and they get the two longest modules, which matches where candidates actually lose marks, the first because its vocabulary is assumed by every later question, the last because it spans the widest set of services. Every lesson ends with its key terms and suggested further reading, so it works as a glossary on the second pass as well as a syllabus on the first.
What the course covers
Core Data Concepts
Module 1 · 25-30%The foundation terminology the rest of the exam assumes: structured, semi-structured, and unstructured data; the file formats you are expected to place (CSV, JSON, Parquet, and Avro; transactional against analytical workloads; the ACID guarantees; and the canonical data roles) database administrator, data engineer, and data analyst, with a clear line around which part of the stack each one owns. This module is the one most worth reading slowly, because skimming it is where most wrong answers later in the exam originate.
Relational Data on Azure
Module 2 · 20-25%Relational fundamentals (primary keys, foreign keys, normalization, views, stored procedures, and indexes) mapped onto Microsoft’s Azure SQL portfolio. The module works through the choice DP-900 keeps asking about: Azure SQL Database as the most abstracted PaaS option, Azure SQL Managed Instance for near-full SQL Server feature parity as a managed service, and SQL Server on Azure VMs where you need full control of the operating system, plus the managed open-source options Azure Database for PostgreSQL and MySQL. Basic SQL literacy is covered too: SELECT, INSERT, UPDATE, DELETE, and which statement category CREATE TABLE belongs to.
Non-Relational Data on Azure
Module 3 · 15-20%The Azure non-relational lineup: Blob storage with its Hot, Cool, Cold, and Archive tiers; Azure Files for SMB and NFS shares; Azure Table storage as a schemaless key and attribute store; and Azure Cosmos DB across all five of its APIs: NoSQL, MongoDB, Cassandra, Table, and Gremlin. Cosmos DB gets the most room here because it gets the most questions: the multi-model design, the tunable consistency levels, and the global-distribution story come back repeatedly.
Analytics Workload
Module 4 · 25-30%The widest module, and tied for the heaviest. Azure Data Factory and its vocabulary of linked services, triggers, and pipelines; ETL against ELT; Azure Synapse Analytics with dedicated and serverless SQL pools and Spark pools; Azure Data Lake Storage Gen2 and its hierarchical namespace; Azure Databricks and Delta Lake; Microsoft Fabric and OneLake; streaming through Event Hubs, IoT Hub, and Stream Analytics; and the Power BI essentials, dashboards, reports, Power BI Desktop, DAX, and star-schema modeling.
How to use it
Read a module, then take the matching portion of the DP-900 practice exam rather than waiting until you have read all four. DP-900’s difficulty is not conceptual depth, it is discrimination between neighbors, which Cosmos DB API, which SQL deployment tier, which Synapse pool type, dedicated or serverless. That distinction only surfaces when you are choosing between four plausible options, not when you are reading a paragraph that describes each of them in turn. The free sample set is a quick way to calibrate before committing to a full attempt. The course modules themselves open once you are signed in to a free Certifym account.
Aim higher than you think you need to. The pass mark is 700 out of 1000 on Microsoft’s scaled scoring, not a raw 70%, so knowing only the easy items in each domain tends to land in the low-to-mid 600s. Deliberately learn the edge cases, the five Cosmos DB APIs, the five consistency levels, the three-tier Azure SQL spectrum, the Data Factory vocabulary, the Synapse pool types. For exam logistics (question count, timing, the $99 fee, and the free annual renewal) see the DP-900 certification guide.
DP-900: Microsoft Azure Data Fundamentals
One module per DP-900 exam domain, weighted to Microsoft's published outline.
A self-paced reading course for DP-900: Microsoft Certified: Azure Data Fundamentals, the entry-level data credential in Microsoft's 900-series. The course is organized as one module per official exam domain, in the order Microsoft publishes them, and each module carries the domain's published weight.
DP-900 does not ask you to have run a production data platform. It asks whether you can hold the map in your head: structured against semi-structured against unstructured data, relational against non-relational stores, transactional against analytical workloads, and where each Azure data service sits on that map. Every lesson closes with its key terms and suggested further reading, so the course works as a glossary on the second pass as well as a syllabus on the first.
Module 1: Core Data Concepts 29% of exam
The vocabulary the rest of DP-900 assumes: structured, semi-structured and unstructured data; the file formats you are expected to place; transactional against analytical workloads; the ACID guarantees; batch against stream processing; the data roles and what each one owns; and the analytics types from descriptive through cognitive.
- 1.1 Structured, semi-structured, and unstructured data 5 min Free preview
- 1.2 Delimited text, JSON, and XML file formats 5 min 🔒
- 1.3 Optimized file formats: Avro, ORC, and Parquet 5 min 🔒
- 1.4 Relational and non-relational data stores compared 5 min 🔒
- 1.5 Transactional workloads and OLTP systems 5 min 🔒
- 1.6 The ACID guarantees 5 min 🔒
- 1.7 Analytical workloads and OLAP systems 5 min 🔒
- 1.8 Data warehouses, data lakes, and the lakehouse 5 min 🔒
- 1.9 Batch processing 5 min 🔒
- 1.10 Stream processing and choosing between batch and stream 5 min 🔒
- 1.11 The database administrator role 5 min 🔒
- 1.12 The data engineer role 5 min 🔒
- 1.13 The data analyst role 5 min 🔒
- 1.14 Descriptive, diagnostic, predictive, prescriptive, and cognitive analytics 5 min 🔒
Module 2: Relational Data on Azure 24% of exam
Relational fundamentals — keys, normalization, indexes, views and stored procedures — mapped onto Microsoft's Azure SQL portfolio, plus the SQL literacy DP-900 expects and the deployment choice the exam keeps returning to: Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure Virtual Machines, and the managed open-source engines.
- 2.1 The relational model: tables, rows, and columns 5 min 🔒
- 2.2 Primary keys, foreign keys, and referential integrity 5 min 🔒
- 2.3 Normalization 5 min 🔒
- 2.4 Indexes 5 min 🔒
- 2.5 Views, stored procedures, and functions 5 min 🔒
- 2.6 SQL statement categories: DDL, DML, DCL, and TCL 5 min 🔒
- 2.7 Querying with SELECT, JOIN, and aggregation 5 min 🔒
- 2.8 IaaS and PaaS: choosing an Azure SQL deployment option 5 min Free preview
- 2.9 Azure SQL Database 5 min 🔒
- 2.10 Azure SQL Managed Instance and SQL Server on Azure Virtual Machines 5 min 🔒
- 2.11 Azure Database for PostgreSQL and MySQL 5 min 🔒
- 2.12 Provisioning, connecting to, and securing relational services 5 min 🔒
Module 3: Non-Relational Data on Azure 18% of exam
The Azure non-relational lineup: Storage account services, Blob storage and its access tiers, Azure Files, Azure Table storage, and Azure Cosmos DB across its APIs — with the partitioning, throughput, global distribution and consistency detail that DP-900 asks about most.
- 3.1 When to use non-relational data stores 5 min 🔒
- 3.2 Azure Storage accounts and their services 5 min 🔒
- 3.3 Azure Blob storage and access tiers 5 min 🔒
- 3.4 Azure Files 5 min 🔒
- 3.5 Azure Table storage 5 min 🔒
- 3.6 Azure Cosmos DB overview 5 min 🔒
- 3.7 Azure Cosmos DB APIs 5 min 🔒
- 3.8 Cosmos DB partitioning and request units 5 min 🔒
- 3.9 Cosmos DB global distribution and consistency levels 5 min 🔒
Module 4: Analytics Workload 29% of exam
The widest module: modern data warehouse architecture, ETL against ELT, Azure Data Factory, Azure Data Lake Storage Gen2, Azure Synapse Analytics, Azure Databricks and Delta Lake, Microsoft Fabric and OneLake, real-time ingestion and processing, and the Power BI modeling and visualization essentials.
- 4.1 The modern data warehouse architecture 5 min 🔒
- 4.2 ETL and ELT 5 min 🔒
- 4.3 Azure Data Factory: pipelines, activities, and linked services 5 min 🔒
- 4.4 Data Factory triggers and integration runtimes 5 min 🔒
- 4.5 Azure Data Lake Storage Gen2 5 min 🔒
- 4.6 Azure Synapse Analytics overview 5 min 🔒
- 4.7 Synapse SQL pools: dedicated and serverless 5 min 🔒
- 4.8 Apache Spark in Azure analytics 4 min 🔒
- 4.9 Azure Databricks and Delta Lake 5 min 🔒
- 4.10 Microsoft Fabric and OneLake 5 min 🔒
- 4.11 Real-time analytics concepts 5 min 🔒
- 4.12 Azure Event Hubs and Azure IoT Hub 5 min 🔒
- 4.13 Azure Stream Analytics 5 min 🔒
- 4.14 Power BI components: Desktop, service, reports, and dashboards 5 min 🔒
- 4.15 Data modeling in Power BI: star schemas, relationships, and DAX 5 min 🔒
- 4.16 Visualization in Power BI: choosing and using visuals 5 min 🔒
Frequently asked questions about the DP-900 training course
Is the DP-900 training course free?
Yes. The course costs nothing to read and opens once you are signed in to a free Certifym account, no payment and no card.
How is the course structured?
One module per official DP-900 exam domain, in Microsoft’s published order, with each module weighted to the domain’s published percentage range. Within each module the material is broken into short lessons, followed by key terms and further reading, the key terms matter here, because much of DP-900 is knowing which service name goes with which description.
Does this replace Microsoft’s official training?
No. Microsoft Learn publishes free official learning paths for DP-900, and the exam guide on Microsoft’s credentials site is the authoritative statement of what is examinable. This course is an independent study companion, written to be read quickly and to slot alongside practice questions.
Do I need database experience before starting?
No. DP-900 has no prerequisites and no requirement for hands-on production experience. If you have written a SQL query before you will move faster through module 2, but the course introduces relational concepts from the beginning rather than assuming them.
What should I do after finishing the course?
Work the DP-900 practice exam until you are scoring consistently across all four domains rather than carrying a weak Analytics Workload result on a strong Core Data Concepts one. Because scoring is scaled, leave yourself margin above the nominal cut before you book.
Is the course current with the latest DP-900 outline?
The course is built against the exam skills outline as currently published by Microsoft, with the four domains and their weightings as Microsoft lists them. Microsoft can revise the outline at any time; confirm the current exam guide, weightings, and logistics on Microsoft’s credentials site before you schedule.
Trademark notice & independence. Certifym.net is operated by Certifym Exam Services, LLC and is not affiliated with, endorsed by, or sponsored by Microsoft Corporation. Microsoft®, Azure®, DP-900, and the Microsoft Certified logos are trademarks or registered trademarks of Microsoft Corporation, referenced here solely to identify the certification these study materials target. The DP-900 exam objectives are the property of Microsoft Corporation; candidates should always confirm the current exam guide, weightings, and logistics directly on Microsoft’s credentials site.
All course content, questions, answers, and explanations on Certifym are original content created for study purposes. No Microsoft exam content, question text, or objective language is reproduced, and none of it is represented as official Microsoft training material. Studying with these materials does not guarantee a passing result on DP-900 itself. Exam requirements, format, domain weights, pricing, and renewal policies are set by Microsoft and may change; always verify current details on Microsoft’s credentials site before scheduling your exam.