Microsoft Azure Data Fundamentals (DP-900)

In this course, students will gain foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services. 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.

Description

 

About This Course

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.

 

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.

 

At Course Completion

After completing this course, students will be able to:

  • 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

After completing this module, 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

 

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 services in Azure
  • Explore provisioning and deploying relational database services in Azure
  • Query relational data in Azure

After completing this module, students will be able to:

  • 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

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.

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

After completing this module, students will be able to:

  • Describe non-relational data services on Azure
  • Explain provisioning and deploying non-relational databases on Azure
  • Decribe non-relational data stores on 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 Data bricks, 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

After completing this module, 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

 

Similar courses

This course teaches IT Professionals how to secure identities, manage their Azure subscriptions, administer the infrastructure, configure virtual networking, connect Azure and on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, implement web apps and containers, back up and share data, and monitor your solution.

More Information

This course provides IT Security Professionals with the knowledge and skills needed to implement security controls, maintain an organization’s security posture, and identify and remediate security vulnerabilities. This course includes security for identity and access, platform protection, data and applications, and security operations.

More Information

This course focuses on securing user identity and access, threat protection, information protection and data governance. This course was designed for IT Professionals who manage and deploy security technologies for Microsoft 365 in their organization.

More Information

This course teaches Solutions Architects how to translate business requirements into secure, scalable, and reliable solutions. Lessons include virtualization, automation, networking, storage, identity, security, data platform, and application infrastructure.

More Information

55316A is the equivalent of the retired legacy MOC Course 20764A - Administering a SQL Database Infrastructure. The 55316A five-day instructor-led course will provide training in how to administer and maintain SQL Server, Azure SQL Database and other cloud-based SQL Server databases. IT professionals who work in environments where databases play a key role in their job will find this material useful. By using demonstrations and hands-on lab exercises, students will learn to carry out these important tasks.

More Information

This course teaches IT Professionals how to secure identities, manage their Azure subscriptions, administer the infrastructure, configure virtual networking, connect Azure and on-premises sites, manage network traffic, implement storage solutions, create and scale virtual machines, implement web apps and containers, back up and share data, and monitor your solution.

More Information

The audience for this course includes software developers and data scientists who need to use large language models for generative AI. Some programming experience is recommended, but the course will be valuable to anyone seeking to understand how the Azure OpenAI service can be used to implement generative AI solutions.

More Information

This course is for IT professionals looking to learn how to build AI solutions in Azure AI Services.

More Information