DP-900 Microsoft Azure Data Fundamentals

Description

Seminar Content

Module 1: Examine key data concepts.

Attendees will learn the basics of database concepts in a cloud environment, gain fundamental knowledge in cloud data services, and build their foundational knowledge of cloud data services in Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, Big Data, and analytics and explore how to implement this technology in Microsoft Azure. Students will learn about roles, tasks, and responsibilities in the data world.

Lessons

Examine key data concepts
Examine roles and responsibilities in the data world
Describe concepts of relational data
Examine concepts of non-relational data
Explore concepts related to data analysis
Upon completion of this module, students will be able to:

Demonstrate basic knowledge of cloud data services in Azure
Identify and describe core data concepts such as relational, non-relational, Big Data, and analytics
Explain how to implement this technology using Azure

Module 2: Investigate relational data in Azure.

Participants will learn the fundamentals of database concepts in a cloud environment, gain basic knowledge in cloud data services, and build their foundational knowledge of cloud data services in Microsoft Azure. Students will explore relational data offerings, deploy and use relational databases, and query relational data via cloud data solutions using Azure.

Lessons

Examine relational data offerings in Azure.
Learn about provisioning and deploying relational database offerings in Azure
Query relational data in Azure
Upon completion of this module, students will be able to:

Describe relational data offerings in Azure
Explain the deployment and provisioning of relational databases in Azure
Query relational data using cloud data solutions in Azure

Module 3: Explore non-relational data in Azure.

Participants will learn the fundamentals of database concepts in a cloud environment, gain basic knowledge in cloud data services, and build their foundational knowledge of cloud data services in Azure. Participants will explore non-relational data offerings, deploy and use non-relational databases as well as non-relational data stores for Microsoft Azure.

Lessons

Examine non-relational data offerings in Azure.
Examine the deployment and use of non-relational data services in Azure
Manage non-relational data stores in Azure
Upon completion of this module, students will be able to:

Describe non-relational data offerings in Azure
Explain the deployment and use of non-relational databases in Azure
Describe non-relational data stores in Azure

Module 4: Explore modern data warehouse analytics in Azure.

Students will learn the fundamentals of database concepts in a cloud environment, gain basic knowledge in cloud data services, and build their foundational knowledge of cloud data services in Azure. Students will learn about the processing options available to create data analytics solutions in Azure. Participants will learn about Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Participants will learn what Power BI is, including its building blocks and how they work together.

Lessons

Examine components of a modern data warehouse
Examine data ingestion in Azure
Examine data storage and processing in Azure
Begin creating with Power BI
Upon completion of this module, students will be able to:

Describe the processing options for creating data analytics solutions in Azure
Describe Azure Synapse Analytics, Azure Databricks, and Azure HDInsight
Explain what Microsoft Power BI is, including its building blocks and how they work together

Aim

/

Participant requirements

/

Participant

Data Engineer & Database Administrator

Upcoming courses