Microsoft DP-900 - Azure Data Fundamentals

What you will learn

• Learn to describe core data workloads such as transactional and analytical workloads, and their key differences
• Manage and work with relational databases using tools like Azure SQL Databases, Azure Database for PostgreSQL, and Azure SQL Managed Instance
• Gain hands-on experience with Azure Cosmos DB and Azure Table Storage for managing nonrelational data, including key-value, column-family, and document data models
• Understand the fundamentals of data analytics such as batch processing, stream processing, and real-time analytics
• Learn to work with modern data warehouse solutions and implement en-to-end analytics using Azure Synapse Analytics
• Develop skills in managing and storing data using Azure Blob Storage, Data Lakes, and other Azure Storage options
• Sharpen your SQL skills by learning query techniques for managing and retrieving data from relational databases on Azure
• Deploy and manage databases and resources using Azure Resource Manager (ARM) templates
• Create HDInsight clusters and Azure Databricks for big data processing to manage Azure workloads.
• This course prepares a student to take the Microsoft DP-900 - Azure Data Fundamentals national certification exam.

Course outline

1. 1

   Lesson 1: Introduction

   • Who Should Read This Course?
   • DP-900 Exam Objectives
   • Domain 1: Describe Core Data Components
   • Domain 2: Describe How to Work with Relational Data on Azure
   • Domain 3: Describe How to Work with Nonrelational Data on Azure
   • Domain 4: Describe an Analytics Workload on Azure
2. 2

   Lesson 2: Core Data Concepts

   • Describe Types of Core Data Workloads
   • Describe Data Analytics Core Concepts
   • Summary
   • Exam Essentials
3. 3

   Lesson 3: Relational Databases in Azure

   • Relational Database Features
   • Relational Database Offerings in Azure
   • Management Tasks for Relational Databases in Azure
   • Query Techniques for SQL
   • Summary
   • Exam Essentials
4. 4

   Lesson 4: Nonrelational Databases in Azure

   • Nonrelational Database Features
   • Azure Cosmos DB
   • Management Tasks for Azure Cosmos DB
   • Summary
   • Exam Essentials
5. 5

   Lesson 5: File, Object, and Data Lake Storage

   • File and Object Storage Features
   • Azure Storage
   • Management Tasks for Azure Storage
   • Summary
   • Exam Essentials
6. 6

   Lesson 6: Modern Data Warehouses in Azure

   • Analytical Workload Features
   • Modern Data Warehouse Components
   • End-to-End Analytics with Azure Synapse Analytics
   • Summary
   • Exam Essentials
7. 7

   Lesson 7: Reporting with Power BI

   • Power BI at a Glance
   • Summary
   • Exam Essentials