DP-900 Microsoft Azure Data Fundamentals Certification

Name: DP-900 Microsoft Azure Data Fundamentals Certification
Rating: 4.6 (4931 reviews)

DP-900 Azure Data Fundamentals Exam Preparation Course

Created byAlan Rodrigues

Last updated 3/2026

English

What you'll learn

This course is designed to test foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services.
Students will learn about securing data in Azure including encryption, access control, and role-based access control (RBAC).
Students will learn about Azure HDInsight for big data processing with services like Hadoop, Spark, and more.
Students will learn how to use Azure Blob Storage to store unstructured data like text, images or video.

Course content

6 sections • 146 lectures • 9h 7m total length

Slides and Diagrams download0:06
Describe ways to represent data2:52
Describe common data workloads3:43
Identify options for data storage2:59
Identify roles and responsibilities for data workloads1:29
What's next0:58
Introduction to Azure1:39
The Azure Free Account4:49
Creating the Azure Free Account5:23
Tour around the Azure Portal2:57
Disabling security defaults2:03
Explore how security defaults add multi-factor prompts during Azure login and how to disable or re-enable them via Microsoft Entra ID properties, with a note on trade-offs.
Section Revision3:29
Section Quiz

Section Introduction0:47
A database system2:55
Different options for hosting a database4:31
Explore infrastructure as a service via virtual machines and platform as a service with Azure SQL Database for hosting relational databases on Azure, including pay-as-you-use pricing.
Lab - Creating a virtual machine12:11
This chapter focuses on creating a virtual machine
Lab - Connecting to the Virtual Machine3:53
Lab - Installing Microsoft SQL Server4:53
This chapter focuses on installing Microsoft SQL Server
Lab - Working with the SQL Server Instance9:54
This chapter focuses on connecting to Microsoft SQL Server
Lab - Working with the SQL Server Instance - Resources0:21
Azure SQL Database2:40
Lab - Creating an Azure SQL Database8:48
This chapter focuses on creating an Azure SQL database
Lab - Installing Azure Data Studio1:21
Install Azure Data Studio on your laptop, covering Windows system installer (x64) and macOS availability, with download, license acceptance, next, and install steps. Launch the app to explore the interface.
Lab - Using Azure Data Studio2:05
Lab - Using Azure Data Studio on macOS1:44
Installing SQL Server Management Studio on your local machine4:36
Understanding key database terms2:51
Explore core database terms like database, relational database, table, columns and rows, SQL, and result set to understand how data is stored, organized, and retrieved.
ACID Properties3:57
The different types of SQL statements1:22
This chapter focuses on different types of SQL statements
Lab - SQL - SELECT Statement7:34
Lab - SQL - SELECT Statement - Resources0:11
Lab - SQL - WHERE Clause12:38
Lab - SQL - WHERE Clause - Resources0:29
Lab - SQL - ORDER BY Clause1:53
Sort query results using the order by clause, ordering by unit price in ascending or descending order. Combine order by with where clauses to create multi-clause queries in SQL.
Lab - SQL - ORDER BY Clause - Resources0:12
Lab - SQL - Aggregate Functions6:05
Lab - SQL - Aggregate Functions - Resources0:19
Lab - SQL - GROUP BY Clause2:26
Lab - SQL - GROUP BY Clause - Resources0:13
Lab - SQL - JOIN Clause7:27
Learn how to use the SQL inner join to combine data from the SalesOrderDetail and Product tables, using ProductID in the ON clause and table aliases for clarity.
Lab - SQL - JOIN Clause - Resources0:17
Database Normalization7:40
Lab - SQL - CREATE TABLE statement8:55
Lab - SQL - CREATE TABLE statement - Resources0:09
Lab - SQL - Using relationships between tables8:58
Learn how to create and relate course, student, and orders tables by defining primary keys and foreign keys, enforce relationships, and perform updates, inserts, deletes, and drops.
Lab - SQL - Using relationships between tables - Resources0:35
Lab - Granting another user access5:43
Create a new sql login in the master database, map it to a user in appdb, and grant select permission on tables to enable data access for the new user.
Lab - Table Views2:46
This chapter focuses on table views
Lab - Table Views - Resources0:12
This chapter focuses on resources on table views
Indexes in tables4:16
This chapter focuses on table indexes
Lab - Working with Indexes3:54
Lab - Working with Indexes - Resources0:34
Lab - Stored Procedure6:08
Lab - Stored Procedure - Resources0:15
Lab - Using sqlcmd2:32
Lab - Using sqlcmd - Resources0:10
Azure SQL Database - Transparent Data Encryption2:24
Just a quick note on the server-level firewall1:49
Azure SQL Managed Instance6:23
Explore the Azure SQL managed instance, a fully managed paas offering with 100 percent SQL Server compatibility and automated backups, deployed in a private virtual network.
Azure SQL Databases - Serverless1:34
Explore the Azure SQL Database serverless compute tier, billed per second and automatically pausing when idle, ideal for variable usage patterns compared to DTU-based purchasing.
Lab - Azure Database for MySQL7:43
Lab - Azure Database for MySQL - Resources0:25
Deleting our Azure SQL database as well1:00
Section Revision8:38
Section Quiz

Introduction to Azure Storage Accounts4:01
Lab - Azure Storage Accounts - Creating a storage account2:34
Lab - Azure Storage Account - Blob service6:19
This chapter focuses on Azure Storage accounts - blob service
Storage Accounts - Data Redundancy7:15
This chapter focuses on Azure Storage accounts - Data Redundancy
Azure Storage Accounts - Access tiers6:47
Lab - Azure Blob storage - Access tiers4:07
This chapter focuses on Azure Storage accounts - Service tiers
Lab - Azure Storage Account - File service4:52
This chapter focuses on Azure Storage accounts - File service
Connecting to a file share from macOS1:00
Lab - Azure Storage Account - Table service4:58
This chapter focuses on Azure Storage accounts - Table service
Lab - Azure Storage Explorer3:06
This chapter focuses on Azure Storage Explorer
Azure Storage Explorer - macOS2:18
Explore Azure Storage Explorer on macOS ARM64, sign in with Azure, load subscriptions, and navigate storage accounts, containers, and file shares.
About the Azure Storage Firewall2:17
This chapter focuses on Azure Storage Accounts - Firewall
Azure Storage - Lifecycle management policies2:37
What is Azure Cosmos DB5:22
Important concepts in Azure Cosmos DB9:32
About JSON3:15
Lab - Creating an Azure Cosmos DB account2:23
Lab - Azure Cosmos DB - Adding data5:26
Lab - Azure Cosmos DB - Adding data - Resources0:19
Azure Cosmos DB and multiple regions3:00
Note on the Table API in Azure Cosmos DB1:29
Lab - Azure Cosmos DB - Gremlin API5:51
Lab - Azure Cosmos DB - Gremlin API - Resources0:08
Review on the different data stores2:57
Section Review4:44
Review non-relational data concepts and flexible schemas. Outline Azure storage services, including blob, file share, table, and queue, storage tiers, and Cosmos DB APIs with geo-redundancy.
Section Quiz

Recap on the common data workloads2:52
Data Processing5:35
Extract, transform and load7:35
Lab - Azure Data Lake Storage7:59
Azure Synapse Analytics3:08
Explore Azure Synapse Analytics as an enterprise data platform, covering Synapse SQL, Apache Spark, Data Factory features, Data Lake Storage Gen2, and Studio‑driven tooling for ingestion, processing, and reporting.
Lab - Azure Synapse - Creating a workspace4:04
Azure Synapse - Serverless Pool Compute option4:39
Lab - Azure Synapse - Serverless SQL pool11:20
Lab - Azure Synapse - Serverless SQL pool - Resources0:31
Designing a data warehouse4:55
Fact and Dimension tables4:04
Lab - Azure Synpase - Creating a dedicated SQL pool6:39
Learn to set up a dedicated SQL pool in Azure Synapse, manage data warehousing units and cost, pause compute, and build a fact-based table by joining SalesOrderHeader and SalesOrderDetail.
Lab - Azure Synpase - Using the dedicated SQL pool9:12
Lab - Azure Synpase - Using the dedicated SQL pool - Resources0:34
Understanding Azure Synapse Architecture3:50
Azure Synapse - Spark pool11:06
Azure Synapse - Spark pool - Resources0:07
Azure Synapse - Data Explorer5:23
Azure Synapse - Data Explorer - Resources0:20
Azure Data Factory4:14
Lab - Azure Data Factory - CSV To Parquet9:33
Lab - Azure Data Factory - Parquet to Data pool7:51
Azure Data Factory - Triggers3:49
Lab - Azure Data Factory - Mapping Data Flow10:15
Use mapping data flows in Azure Data Factory to transform data with spark. Filter null resource groups from CSV in data lake Gen2 and load into SQL pool via pipeline.
Lab - Azure Data Factory - Mapping Data Flow - Resources0:19
Azure Stream Analytics2:15
Lab - Azure Stream Analytics11:00
Create an Azure stream analytics job with a csv input from Azure Data Lake Gen2 and an Azure Synapse dedicated sql pool output, then verify results after uploading ActivityLog.csv.
Lab - Azure Stream Analytics - Resources0:51
What is Azure Databricks2:41
Azure Databricks - Creating a workspace1:27
Azure Databricks - Reading data5:25
Learn to read csv data from an Azure Data Lake Gen2 storage using a Spark-based Databricks notebook, creating a minimal compute cluster, loading into a data frame, and displaying results.
Azure Databricks - Reading data - Resources0:12
Installing Power BI Desktop1:35
Lab - Power BI Desktop - Azure Data Lake Gen24:08
Learn to connect Power BI Desktop to Azure Data Lake Gen2 Storage, fetch activity log data with a SAS token, transform via Power Query, and visualize operation counts by status.
Power BI Desktop - Removing Null values1:49
Lab - Power BI Desktop - Azure SQL Database2:58
Lab - Power BI Desktop - Adding other datasets2:19
Lab - Power BI Desktop - Creating a calculated column - Power Query Editor3:25
Lab - Power BI Desktop - Creating a calculated column - DAX Expression2:36
Lab - Power BI Desktop - Clustered Column Chart2:13
The Power BI service6:59
Publishing to Power BI2:39
Quick Note - Power Report Builder1:38
Power BI - Different visualization charts1:34
Power BI Dashboards1:33
Note on Azure HDInsight1:12
Section Summary8:21
Section Quiz

What are we going to implement1:22
Lab - Deploying an Azure Web App3:24
Azure Event Hubs1:29
Lab - Deploying an Azure Event Hub4:13
Deploy an Azure Event Hubs namespace and an Event Hub in North Europe with basic pricing. Configure diagnostic settings to stream web app logs to the Event Hub.
Lab - Setting up Azure Stream Analytics - Input8:14
Configure an Azure Stream Analytics input from an Azure Event Hub to process web app http logs, extract method, status, uri, and ip with cross apply and test query.
Lab - Setting up Azure Stream Analytics - Output3:47
Lab - Setting up Azure Stream Analytics - Output - Resources0:22
Lab - Power BI Reports1:49

Requirements

Students are required to have prior knowledge on general database concepts and data
Students are required to have prior knowledge on basic concepts on processing data
Having a basic understanding of cloud computing, databases and Azure services will be helpful.

Description

Version 4.0 - June 2024

Entire course revamped with all chapters re-recorded. This is to align the course with the updated exam objectives and services on the Azure platform.

Version 3.1 - July 2023

Changed the chapters which relate onto the working of the storage account service. This is to keep in line with the changes made to the service.
For Azure Databricks, changed the way we access data in a storage account. This is to keep in line with the recent recommendations on accessing a storage account from Azure Databricks.

Version 3.0 - Nov 2022

Carried out a major refresh of the course. The major refresh includes updating all of the videos to reflect the newer changes to Azure services. This refresh was also done to align with the newer exam objectives.

Version 2.0 - Feb 2021

Added chapters on
- Azure SQL Managed Instance
- Azure Cosmos DB - Mongo DB API
- Azure Cosmos DB - Gremlin API
Revised chapters on Azure Databricks
Updated chapters on Azure Synapse Analytics to reflect recent changes in Azure on this service
Added a completely NEW SECTION. This section includes
- Working with SQL commands on data
- Working with data in Power BI
- Additional aspects related to Azure Data Factory

This course is designed for students who want to attempt the Exam DP-900: Microsoft Azure Data Fundamentals

This course has contents for the Exam DP-900

The objectives covered in this course are

Describe core data concepts (15-20%)
Describe how to work with relational data on Azure (25-30%)
Describe how to work with non-relational data on Azure (25-30%)
Describe an analytics workload on Azure (25-30%)

The following key aspects are covered in this course

Working with SQL databases - Here we will see how to work with SQL databases using Microsoft SQL Server on an Azure virtual machine.
We will then explore the Azure SQL database service
We will look at non-relational data stores such as Azure Storage accounts and Azure Cosmos DB
We will look at Analytical services such as Azure Synapse
We will see how to use Azure Data Factory as an ETL tool

This course has a number of videos that will help the student be prepared for the DP-900 exam. Right from the basics on understanding the different data services to knowing how they can work together.

Who this course is for:

This course is great starting point for anyone interested in pursuing a career in Data Management or Data Analysis with Azure.
This course is ideal for individuals who want to build foundational knowledge and skills in working with data in Microsoft Azure.

DP-900 Microsoft Azure Data Fundamentals Certification

What you'll learn

Explore related topics

Course content

Describe core data concepts12 lectures • 32min

Identify considerations for relational data on Azure52 lectures • 3hr 11min

Describe how to work with non-relational data on Azure25 lectures • 1hr 37min

Describe an analytics workload on Azure47 lectures • 3hr 19min

Mini-Project8 lectures • 25min

Practice Section2 lectures • 3min

Requirements

Description

Who this course is for: