DP-900: Microsoft Azure Data Fundamentals

In this course, learners will gain a foundational understanding of the basics of Microsoft Azure data and related data services. They will learn about basic data concepts, such as relational, non-relational, big data, and analytics, and build their foundational knowledge of cloud data services within Microsoft Azure. They will also explore the basics of: relational data and relational database services in Azure, Azure storage for non-relational data, and the basics of Azure Cosmos DB, large-scale data warehousing, real-time analytics, and data visualization.

Program

Module 1: Exploring Core Data Concepts.

Identification of data formats.
File storage exploration.
Database exploration.
Exploration of transactional data processing.
Exploration of analytical data processing.

Module 2: Exploring Data Roles and Services.

Exploring the job roles of the data world.
Identification of data services.
Knowledge test.

Module 3: Exploring fundamental concepts of relational data.

Information about relational data.
Understanding standardization.
SQL exploration.
Description of database objects.

Module 4: Explore relational database services in Azure.

Understanding Azure SQL services and capabilities.
Description of Azure services for open source databases.
Exercise: Exploring Azure relational database services.

Module 5: Explore Azure Storage for non-relational data.

Module 6: Explore the basics of Azure Cosmos DB.

Understanding Azure Cosmos DB
Identify 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.
Exploration of analytical data stores.
Exercise: Exploring data analytics in Microsoft Fabric

Module 8: Exploring the basics of real-time analysis.

Understanding flow and batch processing.
Exploring common elements of the flow processing architecture.
Explore Microsoft Fabric’s real-time intelligence.
Explore Apache Spark structured streaming.
Exercise: Explore Microsoft Fabric’s real-time intelligence.

Module 9: Exploring the basics of data visualization.

Description of Power BI tools and workflow.
Description of the basics of data modeling.
Description of considerations for data visualization.
Exercise: Explore the fundamentals of data visualization with Power BI