Microsoft

Microsoft Certified Azure Data Fundamentals (DP-900)

Learn the basics of managing relational and non-relational databases, data analytics, and modern data warehouses in Azure.

(DP-900.AE1) / ISBN : 978-1-64459-391-2
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Get A Free Trial

About This Course

If you’ve ever wanted to get ahead in cloud data without breaking a sweat, our Microsoft Certified Azure Data Fundamentals (exam DP-900) certification guide is the perfect start. You’ll learn the difference between relational and non-relational databases, explore Azure Synapse Analytics for end-to-end data solutions, and get hands-on with tools like Power BI for reporting. This beginner-friendly course makes mastering Azure data workloads and modern data warehouses a breeze.

Skills You’ll Get

  • Learn to describe core data workloads such as transactional and analytical workloads, and their key differences 
  • Manage and work with relational databases using tools luke Azure SQL Databases, Azure Database for PostgreSQL, and Azure SQL Managed Instance 
  • Gain hands-on experience with Azure Cosmos DB and Azure Table Storage for managing nonrelational data, including key-value, column-family, and document data models
  • Understand the fundamentals of data analytics such as batch processing, stream processing, and real-time analytics 
  • Learn to work with modern data warehouse solutions and implement en-to-end analytics using Azure Synapse Analytics 
  • Develop skills in managing and storing data using Azure Blob Storage, Data Lakes, and other Azure Storage options
  • Sharpen your SQL skills by learning query techniques for managing and retrieving data from relational databases on Azure 
  • Deploy and manage databases and resources using Azure Resource Manager (ARM) templates 
  • Create HDInsight clusters and Azure Databricks for big data processing to manage Azure workloads.
Download Course Outline

1

Introduction

  • Who Should Read This Course?
  • DP-900 Exam Objectives
  • Domain 1: Describe Core Data Components
  • Domain 2: Describe How to Work with Relational Data on Azure
  • Domain 3: Describe How to Work with Nonrelational Data on Azure
  • Domain 4: Describe an Analytics Workload on Azure
2

Core Data Concepts

  • Describe Types of Core Data Workloads
  • Describe Data Analytics Core Concepts
  • Summary
  • Exam Essentials
3

Relational Databases in Azure

  • Relational Database Features
  • Relational Database Offerings in Azure
  • Management Tasks for Relational Databases in Azure
  • Query Techniques for SQL
  • Summary
  • Exam Essentials
4

Nonrelational Databases in Azure

  • Nonrelational Database Features
  • Azure Cosmos DB
  • Management Tasks for Azure Cosmos DB
  • Summary
  • Exam Essentials
5

File, Object, and Data Lake Storage

  • File and Object Storage Features
  • Azure Storage
  • Management Tasks for Azure Storage
  • Summary
  • Exam Essentials
6

Modern Data Warehouses in Azure

  • Analytical Workload Features
  • Modern Data Warehouse Components
  • End-to-End Analytics with Azure Synapse Analytics
  • Summary
  • Exam Essentials
7

Reporting with Power BI

  • Power BI at a Glance
  • Summary
  • Exam Essentials

1

Relational Databases in Azure

  • Creating a SQL Server VM in the Azure Portal
  • Creating an Azure SQL Database
  • Viewing Access with RBAC for a Resource Group
  • Using an ARM Template in the Portal
  • Deploying an ARM Template
  • Creating an Azure Database for PostgreSQL Servers
2

Nonrelational Databases in Azure

  • Creating a Table in Azure Table Storage
  • Creating a Cosmos DB Account and Getting the ARM Template
  • Creating a Cosmos DB Account from the Azure Portal Using the ARM Template
3

File, Object, and Data Lake Storage

  • Creating a Storage Account, Container, and Storage Blob Directory
  • Creating a Blob Container
4

Modern Data Warehouses in Azure

  • Creating an HDInsight Cluster
  • Provisioning an Azure Databricks Workspace and Creating a Cluster

Any questions?
Check out the FAQs

Explore the most pressing questions asked by the community about the Microsoft DP 900 certification exam.

Contact Us Now

The Azure Data Fundamentals DP-900 certification certifies your skills and knowledge relating to the foundational concepts of data in Azure, including relational and non-relational databases, analytics workload, and data management in the cloud.

While prior experience is not required, basic knowledge of databases and cloud computing will be helpful.

The cost of the DP-900 varies by country, but it’s typically around USD 99.

The DP-900 certification is perfect for beginners in cloud data or IT professionals looking to enhance their understanding of Azure’s data services.

The exam includes multiple-choice, and drag-and-drop questions, usually lasting around 60 minutes.

To pass the DP-900 exam, you need a score of at least 700 out of 1000.

You can take the DP-900 exam online through Microsoft’s testing platform or at authorized Pearson VUE testing centers.

Related Courses

All Course