Version 2.0 - Feb 2021

• Added chapters on

  • Azure SQLManaged Instance

  • Azure Cosmos DB- Mongo DBAPI

  • Azure Cosmos DB- GremlinAPI

• Revised chapters on Azure Databricks

• Updated chapters on Azure Synapse Analytics to reflect recent changes in Azure on this service

• Added a completely NEWSECTION.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 MicrosoftSQLServer 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.