DP-900: Microsoft Data Fundamentals MTA (Microsoft Training After-hours) Course Outline

Special Note to New Hampshire Residents
This course has not yet been approved by the New Hampshire Department of Education. Please contact us for an update on when the class will be available in New Hampshire.

Overview
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. Other topics also include Power BI, its building blocks, and how they work together.

This event is delivered in our hybrid Microsoft Training After-hours (MTA) format that blends one late-day/evening session with the live instructor presentation, followed by on-demand training and a TA session for questions and problem-solving.

Audience profile
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.

Job role: Data Engineer, Database Administrator

Preparation for exam: DP-900

Skills gained
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

Course outline

Module 1: 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, non-relational, 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.
Lessons
Explore core data concepts
Explore roles and responsiblities in the world of data
Describe concepts of relational data
Explore concepts of non-relational data
Explore concepts of data analytics

Module 2: 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.
Lessons
Explore relational data offerings in Azure
Explore provisioning and deploying relational database offerings in Azure
Query relational data in Azure

Module 3: 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 offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure.
Lessons
Explore non-relational data offerings in Azure
Explore provisioning and deploying non-relational data services on Azure
Manage 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, 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.
Lessons
Examine components of a modern data warehouse
Explore data ingestion in Azure
Explore data storage and processing in Azure
Get started building with Power BI
View outline in Word

ADP9AH

Attend hands-on, instructor-led DP-900: Microsoft Data Fundamentals MTA (Microsoft Training After-hours) training classes at ONLC's more than 300 locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.

For additional training options, check out our list of Azure Courses and select the one that's right for you.