Course Summary

This CertPREP Microsoft Azure Data Fundamentals (DP-900) course focuses on core knowledge for describing fundamental database concepts and skills for cloud environments; cloud data services within Azure; cloud data roles, tasks, and responsibilities; Azure relational and non-relational data offerings, provisioning, and deployment; querying Azure relational databases; working with Azure non-relational data stores; building modern Azure data analytics solutions; and exploring Azure Data Factory, Azure Synapse Analytics, Azure Databricks, and Azure HDInsight.

The goal of this course is to demonstrate real-world foundational knowledge of core data concepts and how they are implemented using Data Fundamentals Microsoft Azure data services — including text explanations, video demos, lab activities, self-assessment questions, and a practice exam— to increase your chances of passing the exam on your first try.

Methodology:

  • Lessons
  • Video learning
  • MeasureUp Practice Test for Microsoft DP-900. Practice Mode with remediation and Certification mode to simulate the test day experience.
  • Labs

Duration: Approximately 8 hours of primary course content. Each learner will progress at their own rate.

Audience:

Designed for business users, functional consultants, and other professionals, this course focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified: Azure Data Fundamentals level. Passing this exam fulfills your requirements for the Microsoft Certified: Azure Data Fundamentals certification, demonstrating your understanding of the core capabilities of Azure data services and their use with relational data, non-relational data, and analytics workloads.

Prerequisites:

  • 1-2 years professional experience developing cloud solutions
  • Experience working with Microsoft Azure
  • Foundational knowledge of core data concepts and their implementation

Course Outline:

Upon successful completion of this course, students should be able to:  

  • Describe core data concepts
  • Describe how to work with relational data on Azure
  • Describe how to work with non-relational data on Azure
  • Describe an analytics workload on Azure

Lesson 1: Describe core data concepts

  • Skill 1.1: Describe types of core data workloads
  • Skill 1.2: Describe data analytics core concepts

Lesson 2: Describe how to work with relational data on Azure

  • Skill 2.1: Describe relational data workloads
  • Skill 2.2: Describe relational Azure data services
  • Skill 2.3: Identify basic management tasks for relational data
  • Skill 2.4: Describe query techniques for data using SQL language

Lesson 3: Describe how to work with non-relational data on Azure

  • Skill 3.1: Describe non-relational data workloads
  • Skill 3.2: Describe non-relational data offerings on Azure
  • Skill 3.3: Identify basic management tasks for non-relational data

Lesson 4: Describe an analytics workload on Azure

  • Skill 4.1: Describe analytics workloads
  • Skill 4.2: Describe the components of a modern data warehouse
  • Skill 4.3: Describe data ingestion and processing on Azure
  • Skill 4.4: Describe data visualization in Microsoft Power BI