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:

• Those who want to pursue the Microsoft Azure Data Fundamentals Certification
• Those who want to pass the Microsoft exam DP-900