Microsoft

Microsoft Azure Data Fundamentals DP-900

  • 2 upcoming dates 2 open for booking
  • $695 per seat

Upcoming dates

Dates Where Status Seat Book
Oct 5 2026 Live Online 6:00 AM to 2:00 PM PT Confirmed to run Partner led $695
Dec 7 2026 Live Online 6:00 AM to 2:00 PM PT Confirmed to run Partner led $695

See every class on the schedule

About this class

In this course, students will gain foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Microsoft Azure. The students will explore relational data offerings, provisioning and deploying relational databases, and querying relational data. They will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure. Students will explore the processing options available for building data analytics solutions in Azure. They will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Students will learn what Power BI is, including its building blocks and how they work together.

What you'll be able to do

  • The audience for this course is individuals who want to learn the fundamentals of database
  • concepts in a cloud environment, get basic skilling in cloud data services, and build their
  • foundational knowledge of cloud data services within Microsoft Azure.
  • Describe core data concepts in Azure
  • Explain concepts of relational data in Azure
  • Explain concepts of non- relational data in Azure
  • Identify components of a modern data warehouse in Azure
  • Import data into Azure SQL Data Wa
  • Identify how data is defined and stored
  • Identify characteristics of relational and non- relational data
  • Describe and differentiate data workloads
  • Describe and differentiate batch and streaming data
  • Identify common data professional roles
  • Identify common cloud services used by data professionals
  • Module 2: Explore fundamentals of relational data in Azure
  • Students will explore fundamental relational data concepts and relational database
  • services in Azure.
  • Lessons
  • Explore relational data offerings in Azure
  • Explore Azure services for relational data
  • Lab : Provision Azure relational database services
  • Identify characteristics of relational data
  • Define normalization
  • Identify types of SQL statement
  • Identify common relational database objects
  • Identify options for Azure SQL services
  • Identify options for open - source databases in Azure
  • Provision a database service on Azure
  • Module 3: Explore fundamentals of non - relational data in
  • Azure
  • Students will explore Azure storage for non - relational data and the fundamentals of Azure
  • Cosmos DB.
  • Lessons
  • Fundamentals of Azure Storage
  • Fundamentals of Azure Cosmos DB
  • Lab : Explore Azure Storage
  • Lab : Explore Azure Cosmos DB
  • Describe features and capabilities of Azure blob storage
  • Describe features and capabilities of Azure Data Lake Gen2
  • Describe features and capabilities of Azure file storage
  • Describe features and capabilities of Azure table storage
  • Provision and use an Azure Storage account
  • Describe key features and capabilities of Azure Cosmos DB
  • Identify the APIs supported in Azure Cosmos DB
  • Provision and use an Azure Cosmos DB instance
  • Module 4: Explore fundamentals of data analytics
  • Students will learn about modern data warehousing, real - time analytics, and data
  • visualization.
  • Lessons
  • Modern data warehousing
  • Streaming and real - time analytics
  • Data visualization
  • Lab : Analyze streaming data
  • Lab : Visualize data with Power BI
  • Lab : Explore Azure Synapse Analytics
  • Identify common elements of a modern data warehousing solution
  • Describe key features for data ingestion pipelines
  • Identify common types of analytical data store and related Azure services
  • Provision Azure Sy napse Analytics and use it to ingest, process, and query data
  • Compare batch and stream processing
  • Describe common elements of streaming data solutions
  • Describe features and capabilities of Azure Stream Analytics
  • Describe features and capabilities of Spark Structured Streaming on Azure
  • Describe features and capabilities of Azure Synapse Data Explorer
  • Describe a high- level process for creating reporting solutions with Microsoft
  • Power BI
  • Describe core principles of analytical data modeling
  • Identify common types of data visualization and their uses
  • Create an interactive report with Power BI Desktop

Course outline

  1. Module 1Explore core data concepts

    • Students will learn about core data concepts such as relational, non- relational, big data,
    • and analytics, and build their foundational knowledge of cloud data services within
    • Microsoft Azure.
    • Lessons
    • Core data concepts
    • Data roles and Services

Download the full outline (PDF)

Before you attend

This course requires that you meet the following prerequisites: Some exposure to and experience with Active Directory Domain Services (AD DS) concepts and technologies in Windows Server 2012 or Windows Server 2016. DS) concepts and technologies in Windows Server 2012 or Windows Server 2016. Experience and an understanding of core networking technologies such as IP addressing, name resolution, and Dynamic Host Configuration Protocol (DHCP). Experience working with and an understanding of Microsoft Hyper - V and basic An awareness of basic security best practices. Experience working hands - on with Windows client operat ing systems such as Windows 8, Windows 8.1 or Windows 10. Basic experience with Windows PowerShell Course Materials The student kit includes a workbook and other necessary materials for this class.

Run this for a team

Private cohorts run on your dates, at your site or online, with the labs pointed at your environment. Above about four people it usually costs less than buying seats.

Or call 916-920-1700, weekdays 8 to 5 Pacific.

More microsoft technical classes

See all