Microsoft Azure Data Fundamentals DP-900

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.

• 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 Warehouse using PolyBase
• 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.

• 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.

• 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 Synapse 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

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.
• Some exposure to and experience with Active Directory Domain Services (AD 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 server virtualization concepts.
• An awareness of basic security best practices.
• Experience working hands-on with Windows client operating systems such as Windows 8, Windows 8.1 or Windows 10.
• Basic experience with Windows PowerShell