What will you in DP-900 Azure Data Fundamentals Exam Prep In One Day Course
Understand core data concepts: relational, non-relational, big data, and analytics workloads
Navigate Microsoft Azure data services: Azure SQL Database, Cosmos DB, Data Lake, and Synapse Analytics
Implement simple relational data solutions and query data with SQL
Explore non-relational data models and work with Azure Cosmos DB APIs
Describe analytics workloads and ingest data using Azure Data Factory and Synapse pipelines
Program Overview
Module 1: Introduction to Data Fundamentals & Azure
⏳ 30 minutes
Overview of data concepts and the DP-900 exam objectives
Azure portal tour and setting up a free account
Module 2: Core Data Concepts
⏳ 45 minutes
Relational vs. non-relational data, structured vs. semi-structured data
Basics of transactional and analytical workload differences
Module 3: Relational Data in Azure
⏳ 1 hour
Provisioning Azure SQL Database and executing SQL queries
- Understanding SQL serverless, managed instances, and Elastic Pools
Module 4: Non-Relational Data in Azure
⏳ 1 hour
Introduction to Azure Cosmos DB and its multi-model APIs (SQL, MongoDB, Cassandra)
Data partitioning, consistency levels, and querying with the SQL API
Module 5: Data Analytics Workloads
⏳ 45 minutes
Overview of Azure Synapse Analytics and Data Lake Storage Gen2
Differences between on-demand vs. provisioned compute and storage
Module 6: Data Ingestion & Orchestration
⏳ 45 minutes
Building ETL/ELT pipelines with Azure Data Factory
Mapping data flows, triggers, and monitoring pipeline runs
Module 7: Exploring and Visualizing Data
⏳ 45 minutes
Querying data with serverless SQL pools and Spark pools in Synapse
Connecting Power BI to Azure data services for visualization
Module 8: Exam Preparation & Best Practices
⏳ 30 minutes
Sample DP-900 exam questions and study tips
Securing data with Azure RBAC, encryption, and compliance features
Get certificate
Job Outlook
Azure data fundamentals open doors to roles such as Data Analyst, Data Engineer (entry level), and Azure Administrator
Essential knowledge for organizations adopting cloud-native data solutions and analytics platforms
Provides a stepping-stone to associate-level certifications (DP-200/201, DP-203) and specialized Azure roles
Valuable for IT professionals transitioning into cloud and data-focused career paths
Explore More Learning Paths
Boost your Microsoft Azure knowledge and prepare for certification exams with these carefully selected courses, designed to help you gain practical skills in cloud computing and AI fundamentals.
Related Courses
Preparing for AI-900: Microsoft Azure AI Fundamentals Exam Course – Get hands-on guidance to pass the AI-900 exam and understand Azure AI services.
Microsoft Azure AI Fundamentals (AI-900) Exam Prep Specialization Course – Strengthen your foundational AI knowledge and prepare for the official certification exam.
Microsoft Azure AI Fundamental Certification Course – Learn Azure AI concepts and practical applications to earn your certification and advance your cloud career.
Related Reading
What Is Data Management? – Understand how data management principles integrate with cloud platforms like Azure to support analytics and AI solutions.
Specification: DP-900 Azure Data Fundamentals Exam Prep In One Day Course
|

