What you'll learn:
- Students will be better prepared for the DP-900 certification exam
- Students will learn the important aspects for what is required from an exam perspective
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 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.