DP 900 : Training Overview
This course provides essential knowledge about data concepts and their implementation in Azure. Starting with basic data types (structured, semi-structured, unstructured), you’ll explore relational vs. non-relational systems, data ingestion, and analytics services like Azure Synapse. The course also covers security, privacy, compliance, and pricing, equipping you to confidently build foundational data solutions on Azure.
Why DP‑900?
-
Validates foundational knowledge in Azure data services
-
Ideal starting point for data roles like Data Engineer or Analyst
-
Demonstrates ability to work with SQL, NoSQL, and analytics services
-
Recognized by enterprises adopting cloud data solutions
-
Essential stepping stone for higher-level Azure data certifications
What You Will Learn
-
Fundamentals of relational and non-relational data systems
-
Core Azure data services: SQL Database, Cosmos DB, Synapse
-
Basics of big data analytics with Azure Synapse and Databricks
-
Techniques for data ingestion purpose and storage policies
-
Data security, compliance, and privacy on Azure
-
Insight into cost management and monitoring for data solutions
Prerequisites
-
Basic understanding of data concepts and databases
-
Familiarity with spreadsheet or SQL is helpful
-
No prior Azure experience required
-
Eagerness to work with data on the cloud
Course Curriculum
Ways to represent structured and unstructured data
Data storage options (relational, non-relational, file, object)
Types of data workloads: transactional, analytical, streaming
Key roles in data: database admin, data engineer, data analyst
Core relational database concepts and schemas
Azure SQL Database, Azure Database for PostgreSQL, MySQL
Provisioning, configuring, and scaling relational data services
Writing and optimizing queries in Azure SQL
Azure Blob Storage and Table Storage capabilities
Azure Cosmos DB features: global distribution, consistency models
API models: Core (SQL), MongoDB, Cassandra, Table, Gremlin
Use cases for non-relational (NoSQL) databases
Real-time data processing with Azure Stream Analytics
Introduction to Azure Synapse Analytics and data pipelines
Data visualization concepts using Microsoft Power BI
Elements of big data and large-scale analytics solutions