DP-900 Microsoft Azure Data Fundamentals Certification

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.