DP-900 Exam prep reading list  (further reading)

This DP-900 Exam prep reading list comes from Microsoft Learn. Links will be added as I go through the course material / suggested reading on the Microsoft Learn site until I have completed the full course. I am currently working my way through the material.

If you are thinking of sitting DP-900 Azure data fundamentals, I recommend following through the free course on the Microsoft learn site (scroll down past exam info) and also reading the recommended links. The links may add a bit of time onto your learning, and you can be the judge about about how intensively you need to study the extra material, however the more prepared you are, the greater your chance of success with the certification exam. Links duplicated in Microsoft Learn are only shown once in the list below.

I find it great that Microsoft are making these resources available for free these days. Some video learning would also be nice but this is a great start.

Azure Data Fundamentals: Explore core data concepts

Explore core data concepts

• https://docs.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description
• https://docs.microsoft.com/en-us/azure/cosmos-db/introduction
• https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blobs-introduction
• https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview

Explore roles and responsibilities in the world of data

• https://docs.microsoft.com/en-us/azure/databricks/scenarios/what-is-azure-databricks
• https://docs.microsoft.com/en-us/azure/hdinsight/hdinsight-overview
• https://docs.microsoft.com/en-us/power-bi/fundamentals/power-bi-overview
• https://docs.microsoft.com/en-us/azure/data-factory/introduction

Describe concepts of relational data

• https://docs.microsoft.com/en-us/office/troubleshoot/access/database-normalization-description
• https://docs.microsoft.com/en-us/sql/odbc/reference/structured-query-language-sql?view=sql-server-ver15
• https://docs.microsoft.com/en-us/azure/azure-sql/azure-sql-iaas-vs-paas-what-is-overview

Explore concepts of non-relational data

• https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
• https://docs.microsoft.com/en-us/azure/cosmos-db/index-overview
• https://docs.microsoft.com/en-us/azure/cosmos-db/table-introduction
• https://docs.microsoft.com/en-us/azure/cosmos-db/graph-introduction

Explore concepts of data analytics

• https://docs.microsoft.com/en-us/power-bi/create-reports/
• https://azure.microsoft.com/en-us/services/databricks/
• https://azure.microsoft.com/en-gb/services/cognitive-services/  (Broken link on site)
• https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

Azure Data Fundamentals: Explore relational data in Azure

Explore relational data offerings in Azure

Explore provisioning and deploying relational database offerings in Azure

Query relational data in Azure

Azure Data Fundamentals: Explore non-relational data in Azure

Explore non-relational data offerings in Azure

Explore provisioning and deploying non-relational data services in Azure

Manage non-relational data stores in Azure

Azure Data Fundamentals: Explore modern data warehouse analytics in Azure

Examine components of a modern data warehouse

Explore data ingestion in Azure

Explore data storage and processing in Azure

Get started building with Power BI

Recommended posts:

SQL Server on Amazon RDS 

Put tempdb files on d drive in Azure IAAS