Azure Data

Master the fundamentals of data concepts and Microsoft Azure data services in this comprehensive, AI-guided certification preparation course aligned to the Microsoft DP-900 exam.This course takes you from zero to exam-ready across all four DP-900 domains through a proven learn-then-practice structure. Each module begins with an AI-guided teaching lesson that delivers rich, interactive instruction complete with architecture diagrams, real-world scenarios, code examples, and knowledge assessments followed by hands-on lab exercises where you build and explore Azure data services in a live cloud environment.**What You'll Learn:****Core Data Concepts (25-30% of exam)** Understand the differences between structured, semi-structured, and unstructured data. Explore common file formats (CSV, JSON, Parquet, Avro), database types (relational, document, key-value, graph), and the distinction between transactional (OLTP) and analytical (OLAP) workloads. Learn the roles and responsibilities of database administrators, data engineers, and data analysts.**Relational Data on Azure (20-25% of exam)** Dive into relational database fundamentals including normalization, SQL statements, and database objects. Explore the Azure SQL family (Azure SQL Database, Managed Instance, SQL Server on VMs) and open-source database services (Azure Database for PostgreSQL, Azure Database for MySQL) through both guided instruction and hands-on provisioning labs.**Non-Relational Data on Azure (15-20% of exam)** Learn about Azure Storage services including Blob storage, Azure Files, Table storage, and Data Lake Storage Gen2. Explore Azure Cosmos DB's globally distributed, multi-model architecture and its supported APIs. Practice creating and querying these services in live Azure labs.**Analytics and Data Visualization (25-30% of exam)** Understand data ingestion patterns (ETL vs ELT), analytical data stores (data warehouses, data lakes, lakehouses), and modern analytics platforms including Microsoft Fabric and Azure Databricks. Learn the difference between batch and streaming processing, explore real-time analytics, and build interactive reports and visualizations with Power BI Desktop.**Hands-On Experience:**- Provision and query Azure SQL Database with the AdventureWorks sample database- Deploy Azure Database for PostgreSQL and MySQL Flexible Servers- Create and explore Azure Storage accounts with Blob, Files, Tables, and Data Lake Gen2- Build and query an Azure Cosmos DB database using the NoSQL API- Ingest and analyze data using Microsoft Fabric Lakehouse and pipelines- Process real-time streaming data with Fabric Real-Time Analytics- Build interactive Power BI reports with charts, maps, and drill-down navigation- Complete a final certification challenge deploying Azure data services from scratch**Course Format:**Each module follows a structured learning path: AI-guided instruction with embedded visuals and knowledge checks, followed by hands-on labs in a live Azure environment. The course concludes with a certification challenge that tests your ability to independently deploy and configure Azure data services. All cloud resources are provided no personal Azure subscription required.