DP-900: Microsoft Azure Data Fundamentals

DP-900 Course: Microsoft Azure Data Fundamentals

In this course, students will gain fundamental knowledge of basic data concepts and related data services in Microsoft Azure. Students will learn about fundamental data concepts, such as relational, non-relational, big data, and analytics, and build their foundational understanding 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 basics of Azure Cosmos DB. Students will learn about large-scale data storage, real-time analytics, and data visualization.

Level: Beginner - Product: Azure - Role: Data Engineer

Azure Data Fundamentals - Azure Certification - Cloud Databases - Data Services - SQL - NoSQL - Data Analysis - DP-900 Exam Preparation

Course aimed at

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

Elements of the DP-900 formation

• Exploring the concepts of core data (8 units)
  
• Exploring roles and data services (5 units)
  
• Exploration of fundamental concepts of relational data (7 units)
  
• Exploring relational database services in Azure (6 units)
  
• Exploring Azure Storage for Non-Relational Data (9 units)
  
• Exploring the basics of Azure Cosmos DB (6 units)
  
• Exploration of the basics of large-scale analysis (7 units)
  
• Exploring the basics of real-time analysis (8 units)
  
• Exploring the basics of data visualization (7 units)

Course content DP-900: Data basics in Microsoft Azure

Module 1. Exploring the fundamentals of data

• Basic data concepts
  
• Data roles and services
  

After completing this module, you will be able to:

• Identify common data formats.
  
• Describe the options for storing data in files and databases.
  
• Describe the characteristics of transactional and analytical data processing solutions.
  
• Identify the common roles of data professionals.
  
• Identify the common cloud services used by data professionals.
  

Module 2. Exploring the basics of relational data in Azure

• Exploring the concepts of relational data
  
• Exploring Azure services for relational data
  
• Lab: Provisioning Azure Relational Database Services

After completing this module, you will be able to:

• Identifying the characteristics of relational data.
  
• Definition of standardization.
  
• Identify types of SQL statements and relational database objects.
  
• Identify the options for Azure SQL services.
  
• Identify the options for open source databases in Azure.
  
• Provisioning a database service in Azure.
  

Module 3. Exploring the basics of non-relational data in Azure

• Azure Storage basics
  
• Azure Cosmos DB Basics
  
• Lab: Provisioning Azure Relational Database Services
  
• Lab: Exploring Azure Storage Lab: Exploring Azure Cosmos DB

After completing this module, you will be able to:

• Describe the features and functionalities of Azure Blob Storage, Azure Data Lake Gen2, Azure File Storage, and Azure Table Storage
  
• Provision and use an Azure Storage account.
  
• Describe the key functionalities and features of Azure Cosmos DB.
  
• Identify the APIs supported in Azure Cosmos DB.
  
• Provisioning and using an Azure Cosmos DB instance.

Module 4. Exploring the fundamentals of data analysis

• Large-scale data analysis
  
• Streaming and real-time analytics
  
• Data visualization
  
• Lab: Exploring Data Analysis in Microsoft Fabric
• Lab: Exploring real-time analytics in Microsoft Fabric
• Lab: Data Visualization with Power BI

After completing this module, you will be able to:

• Describe the common characteristics of large-scale analytical solutions.
  
• Describe the common characteristics of real-time analytical solutions.
  
• Description of considerations for data visualization

Prerequisites

No prerequisite certification is required to take this course. Azure Data Fundamentals students who benefit from the course typically start with some basic computer and internet knowledge and demonstrate an interest in extracting information from data.

Specifically:

• Experience using a web browser, such as Microsoft Edge.
• Familiarity with basic data-related 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 basic data concepts related to Microsoft Azure data services.

Level: Beginner
Role: Data Engineer
Product: Azure
Subject: Cloud & AI Platforms