DP-900: Microsoft Azure Data Fundamentals - UPDATED 2021

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 includes around 150 practice questions. These practice questions will help students be better prepared to take on the DP-900 exam.