Projects
Assignments
Overview
In this course, students will gain foundational knowledge of core data concepts and related Microsoft Azure data services. 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. Students will explore fundamental relational data concepts and relational database services in Azure. They will explore Azure storage for non-relational data and the fundamentals of Azure Cosmos DB. Students will learn about large-scale data warehousing, real-time analytics, and data visualization.
Objectives
At the end of DP-900 Microsoft Azure Data Fundamentals training course, participants will learn to
Prerequisites
Prerequisite certification is not required before taking this course. Successful Azure Data Fundamentals students start with some basic awareness of computing and Internet concepts, and an interest in extracting insights from data.
Specifically:
- Experience using a web browser, such as Microsoft Edge.
- Familiarity with basic data-related concepts, such as working with tables of data in a spreadsheet and visualizing data using charts.
- A willingness to learn through hands-on exploration.
Course Outline
Explore core data concepts
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, nonrelational, big data, and analytics, and explore how this technology is implemented with Azure. Students will explore the roles, tasks, and responsibilities in the world of data.
Lesson
- 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
Explore relational data in Azure
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 explore relational data offerings, provisioning and deploying
relational databases, and querying relational data through cloud data solutions with Azure.
Lesson
- Explore relational data services in Azure
- Explore provisioning and deploying relational database services in Azure
- Query relational data in Azure
Explore non-relational data in Azure
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 Azure. Students will explore non-relational data services, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure.
Lesson
- Explore non-relational data services in Azure
- Explore provisioning and deploying non-relational data services on Azure
- Manage non-relational data stores in Azure
Explore modern data warehouse analytics in Azure
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 Azure. Students will explore the processing options available for building data analytics solutions in Azure. Students 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.
Lesson
- Examine components of a modern data warehouse
- Explore large-scale data analytics
- Get started building with Power BI
