DP‑900: Microsoft Azure Data Fundamentals

About this course

Describe Core Data Concepts (≈15–20%) Describe Relational Data in Azure (≈25–30%) Describe Non‑Relational Data in Azure (≈25–30%) Describe Analytics Workloads in Azure (≈25–30%) Domain 1: Core Data Concepts (Foundation Layer)TopicsTypes of data:StructuredSemi‑structuredUnstructuredTransactional vs Analytical workloadsOLTP vs OLAPTables, rows, columns, indexesSchema conceptsTypical Question Patterns“Which type of data…”“Which workload is most suitable…”“Which scenario describes OLTP…” Easy questions High confidence builders Warm‑up section in every practice testTarget: 8–10 questions per testDomain 2: Relational Data in Azure (MOST IMPORTANT)Azure Services to CoverAzure SQL DatabaseAzure SQL Managed InstanceSQL Server on Azure VMAzure Database for:MySQLPostgreSQLMariaDBConceptsTables, primary keys, foreign keysIndex purpose (performance, NOT storage)Basic SQL:SELECTINSERTUPDATEDELETEViews vs TablesWhen to choose which serviceScenario Examples“A company needs a fully managed relational database…”“Which Azure service supports SQL queries and relational schema?”“Which command retrieves data from a table?” High‑scoring sectionStudents fail here if unclearTarget: 14–16 questions per test Domain 3: Non‑Relational Data in Azure (Co

Course objectives

• provide a foundational understanding of data in Azure
• prepare students for practical applications in data management
• familiarize students with different Azure data services