Course Overview
This course provides participants with a strong foundation in core data concepts and Microsoft Azure data services. It builds essential knowledge of relational and non-relational data, analytics workloads, and cloud-based data solutions aligned with the DP-900 certification.
Detailed Curriculum
Module 1: Introduction to Data Fundamentals
- Overview of data in modern organizations
- Types of data: structured, semi-structured, unstructured
- Transactional (OLTP) vs analytical (OLAP) workloads
- Introduction to cloud-based data platforms
Module 2: Core Data Concepts
- Basic data terminology and concepts
- Relational data principles
- Non-relational (NoSQL) data principles
- Schema, tables, rows, columns, and keys
- Selecting suitable data storage solutions
Module 3: Relational Data in Microsoft Azure
- Overview of Azure relational data services
- Azure SQL Database concepts
- Azure SQL Managed Instance overview
- Basic SQL operations and queries
- Common use cases for relational databases
Module 4: Non-Relational Data in Microsoft Azure
- Introduction to NoSQL databases
- Azure Cosmos DB fundamentals
- Containers, items, and partitioning
- Common non-relational data scenarios
Module 5: Analytics Workloads in Microsoft Azure
- Introduction to analytics and data warehousing
- Azure Synapse Analytics overview
- Azure Data Factory fundamentals
- Data ingestion, transformation, and analytics workflows
Module 6: Hands-On Demonstrations
- Guided demonstrations of Azure SQL Database
- Exploring Azure Cosmos DB concepts
- Understanding analytics workflows in Azure
- Practical examples aligned with DP-900 exam objectives
Module 7: Assessment and Certification Preparation
- DP-900 exam structure and domains
- Sample exam questions and discussion
- Examination tips and strategies
Module 8: Course Review and Closure
- Recap of key learning points
- Question and answer session
- Guidance on further learning and certification pathways