DP-900: Microsoft Azure Data Fundamentals

DP-900 Course: Microsoft Azure Data Fundamentals

In this course, students will gain fundamental knowledge of data fundamentals and related data services in Microsoft Azure. 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 relational data fundamentals 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 storage, real-time analytics, and data visualization.

The course includes a certification exam and a gift opportunity! *Promotion valid until August 31st for customers in Spain only.

Course aimed at

The audience for this course is individuals who want to learn the fundamentals of database concepts in a cloud environment, gain foundational skills in cloud data services, and develop their fundamental knowledge of cloud data services within Microsoft Azure.

Elements of the DP-900 formation

• Exploring Core Data Concepts (8 Units)
• Exploring Data Roles and Services (5 Units)
• Exploring Fundamental Relational Data Concepts (7 Units)
• Exploring Relational Database Services in Azure (6 Units)
• Exploring Azure Storage for Non-Relational Data (8 Units)
• Exploring Azure Cosmos DB Fundamentals (6 Units)
• Exploring the Basics of Large-Scale Data Storage (7 Units)
• Exploring the Basics of Real-Time Analytics (11 Units)
• Exploring the Basics of Data Visualization (7 Units)

DP-900 Course Content

Module 1. Exploring Core Data Concepts

• Identifying data formats
• Exploring file storage
• Database Exploration
• Exploring transactional data processing
• Exploring analytical data processing

Module 2. Exploring Data Roles and Services

• Exploring Data Roles
• Identification of data services

Module 3. Exploring Fundamental Relational Data Concepts

• Information about relational data
• Understanding Normalization
• SQL Exploration
• Description of database objects

Module 4. Exploring relational database services in Azure

• Description of Azure SQL services and capabilities
• Overview of Azure services for open source databases
• Exercise: Exploring Azure Relational Database Services

Module 5. Exploring Azure Storage for Non-Relational Data

• Exploring Azure Blob Storage
• Exploring Azure Data Lake Storage Gen2
• Exploring Microsoft OneLake on Fabric
• Exploring Azure Files
• Exploring Azure Tables
• Exercise: Exploring Azure Storage

Module 6. Exploring Azure Cosmos DB Basics

• Azure Cosmos DB Description
• Identifying Azure Cosmos DB APIs
• Exercise: Exploring Azure Cosmos DB

Module 7. Exploring the Basics of Large-Scale Analysis

• Description of the architecture of a data warehouse
• Exploring data ingestion pipelines
• Exploring analytical data warehouses
• Exercise: Exploring Data Analysis in Microsoft Fabric

Module 8. Exploring Azure Cosmos DB Basics

• Understanding Stream and Batch Processing
• Exploring common elements of stream processing architecture
• Exploring Azure Stream Analytics
• Exercise: Exploring Azure Stream Analytics
• Exploring Apache Spark on Microsoft Azure
• Exercise: Exploring Spark Streaming in Azure Synapse Analytics
• Exploring Real-Time Analytics in Microsoft Fabric
• Exercise: Exploring Real-Time Analytics in Microsoft Fabric

Module 9. Exploring the Basics of Data Visualization

• Power BI Tools and Workflow Overview
• Description of basic data modeling conceptsDescription of considerations for data visualization
• Exercise: Exploring the basics of data visualization with Power BI

Prerequisites

No prerequisite certification is required to take this course. Azure Data Fundamentals students who complete this course begin with some basic knowledge of computer science and internet concepts and demonstrate an interest in extracting insights from data.

Specifically:

• Experience using a web browser, such as Microsoft Edge.
• Familiarity with basic data concepts, such as working with data tables in a spreadsheet and visualizing data using charts.
• Desire to learn through practical exploration.

Language

• Course: English / Spanish
• Labs: English / Spanish

Microsoft Associate Certification: Azure Data Fundamentals

Microsoft Certified: Azure Data Fundamentals

Demonstrate your knowledge of data fundamentals related to Microsoft Azure data services.

Level: Beginner
Role: Data Engineer
Product: Azure
Subject: Data and AI