A comprehensive learning pathway designed to prepare individuals for the Microsoft Azure Data Fundamentals DP-900 certification exam, covering core data concepts, relational and non-relational data services on Azure, and analytics workloads in cloud environments.
Learners will demonstrate foundational knowledge of core data concepts and related Microsoft Azure data services. They will understand the concepts of relational and non-relational data, different types of data workloads such as transactional and analytical, identify considerations for working with data on Azure, describe analytics workloads, and demonstrate proficiency in using Azure data visualization tools like Power BI.
Understanding Azure Synapse Analytics, Azure Databricks, Azure Event Hubs, and Azure Stream Analytics.
Understanding Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
Understanding Azure Cosmos DB as a globally distributed NoSQL database service with multiple APIs.
Understanding Azure Blob Storage, Azure File Storage, and Azure Table Storage capabilities.
Understanding Azure Database services for MySQL, PostgreSQL, and MariaDB.
Understanding Microsoft Fabric as a unified analytics platform integrating multiple data services.
Understanding streaming data processing, real-time analytics, and the differences between batch and stream processing.
Comprehensive understanding of relational database principles, normalization, and SQL language basics.
Understanding Power BI capabilities for data visualization, reporting, and business intelligence.
Understanding data ingestion, processing, and modern data warehouse concepts for analytics workloads.
Understanding various storage mechanisms including file systems, databases, and cloud storage solutions.
Fundamental understanding of structured, semi-structured, and unstructured data types and their characteristics.
Understanding OLTP and OLAP workload characteristics and appropriate technology choices.
Understanding roles of database administrators, data engineers, and data analysts in data organizations.
Comprehensive information about the DP-900 certification exam including format, objectives, and preparation resources.