Microsoft Azure Data Fundamentals (DP-900T00)
Course Duration
1 Day
Audience
Employees of federal, state and local governments; and businesses working with the government.
Prerequisites
No prerequisites required.
Course Description
In this course, students will 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. 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. They will explore the roles, tasks, and responsibilities in the world of data. The students will explore relational data offerings, provisioning and deploying relational databases, and querying relational data through cloud data solutions with Microsoft Azure. 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.
Course Outline
Module 1: Explore core data concepts
Lessons
- Explore core data concepts
- Explore roles and responsibilities in the world of data
- Describe concepts of relational data
- Explore concepts of non-relational data
- Explore concepts of data analytics
- Show foundational knowledge of cloud data services within Azure
- Identify and describe core data concepts such as relational, non-relational, big data, and analytics
- Explain how this technology is implemented with Azure
Module 2: Explore relational data in Azure
Lessons
- Explore relational data services in Azure
- Explore provisioning and deploying relational database services in Azure
- Query relational data in Azure
- Describe relational data services on Azure
- Explain provisioning and deploying relational databases on Azure
- Query relational data through cloud data solutions in Azure
Module 3: Explore non-relational data in Azure
Lessons
- Explore non-relational data services in Azure
- Explore provisioning and deploying non-relational data services on Azure
- Manage non-relational data stores in Azure
- Describe non-relational data services on Azure
- Explain provisioning and deploying non-relational databases on Azure
- Describe non-relational data stores on Azure
Module 4: Explore modern data warehouse analytics in Azure
Lessons
- Examine components of a modern data warehouse
- Explore large-scale data analytics
- Get started building with Power BI
- Describe processing options available for building 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