DP-900: Microsoft Azure Data Fundamentals

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.

• 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)

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 Job 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

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.

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

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