Vault™ > DP-900T00: Microsoft Azure Data Fundamentals

Access to the Vault™ requires an active Microsoft Live Subscription.

Login Buy Subscription

DP-900T00: Microsoft Azure Data Fundamentals

By Tyler Farmer
1 Day
Live Class Recording
July 24, 2023
Course Description

This is an introductory 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

Learning Path 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.

Modules

  • Explore core data concepts
  • Explore data roles and services

After completing this Learning Path, students will be able to:

  • 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

 

Learning Path 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.

Modules

  • Explore fundamental relational concepts
  • Explore relational database services in Azure

After completing this Learning Path, students will be able to:

  • Describe relational data offerings on Azure
  • Explain provisioning and deploying relational databases on Azure
  • Query relational data through cloud data solutions in Azure

 

Learning Path 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.

Modules

  • Explore Azure Storage for non-relational data
  • Explore fundamentals of Azure Cosmo DB

After completing this Learning Path, students will be able to:

  • Describe non-relational data offerings on Azure
  • Explain provisioning and deploying non-relational databases on Azure
  • Describe non-relational data stores on Azure

 

Learning Path 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.

Modules

  • Explore fundamentals of large-scale data warehouse
  • Explore fundamentals of real-time analytics
  • Explore fundamentals of data visualization

After completing this Learning Path, students will be able to:

  • 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

 

Course Content
Introductions
Introductions
Course Overview
Course Overview
Accessing Courseware and Lab Materials
Accessing Courseware and Lab Materials
LP1-Explore Fundamentals of Data
Module 01 - Explore Data Concepts
Module 02 - Explore Data Roles & Services
LP2-Explore Fundamentals of Relational Data in Azure
Talk about Data Table Design
Module 03 - Explore Fundamental Relational Data Concepts
Module 04 - Explore Relational Database Services In Azure
Overview of Azure
Overview of Azure
Lab 01: Explore Relational Data in Azure - Azure SQL Database
Lab 01: Explore Relational Data in Azure - Azure SQL Database
Accessing the Lab Environment
Accessing the Lab Environment
Overview of Azure Storage
Overview of Azure Storage
LP3-Explore Fundamentals of Non-Relational Data in Azure
Module 05 - Explore Azure Storage For Non-Relational Data
Module 06 - Explore Fundamentals Of Azure Cosmos Db
Lab 02: Explore non-relational Data in Azure - Explore Azure Storage
Lab 02: Explore non-relational Data in Azure - Explore Azure Storage
Lab 03: Explore non-relational Data in Azure - Explore Azure Cosmos DB
Lab 03: Explore non-relational Data in Azure - Explore Azure Cosmos DB
Review of the Labs
Review of the Labs
LP4-Explore Fundamentals of Data Analytics
Module 07 - Explore Fundamentals Of Large-Scale Analytics
Lab 04: Explore Data Anlytics in Azure - Azure Synapse Analytics
Lab 04: Explore Data Anlytics in Azure - Azure Synapse Analytics
LP4-Explore Fundamentals of Data Analytics
Module 08 - Explore Fundamentals Of Real-Time Analytics
Lab 05: Explore Data Anlytics in Azure - Azure Stream Analytics
Lab 05: Explore Data Anlytics in Azure - Azure Stream Analytics
LP4-Explore Fundamentals of Data Analytics
Module 09 - Explore Fundamentals Of Data Visualization
Lab 06: Explore Data Anlytics in Azure - Fundamentals of Data Visualization with Power BI
Lab 06: Explore Data Anlytics in Azure - Fundamentals of Data Visualization with Power BI
Student Lab Time
Student Lab Time