DP-900: Azure Data Fundamentals

Home > Products > DP-900: Azure Data Fundamentals

DP-900: Azure Data Fundamentals

Instructor: Dominic Thevan

This foundational course introduces core data concepts and Azure data services, perfect for beginners starting their data journey.

CA$800.00

CA$1,200.00

Sale!

At A Glance

This course provides an entry-level introduction to core data concepts and Microsoft Azure data services, covering relational, non-relational, big data, and analytics fundamentals. Ideal for IT professionals, beginners, or business decision-makers starting their data journey, it offers hands-on insights into Azure SQL Database, Cosmos DB, and data analytics services. Participants will gain the knowledge needed to understand cloud data solutions and prepare for the DP-900 certification exam.

Difficulty

Some related experience required

Duration

4 sessions

(8 hours)

Overview

Welcome to the DP-900 course, your essential gateway into the world of Azure data services and cloud data management. This program introduces you to fundamental data concepts, including relational databases, NoSQL solutions, and modern analytics platforms, all updated for 2025 with the latest Azure data services and real-world applications. It’s perfect for anyone beginning their data career or seeking to understand how data works in the cloud, providing a solid foundation for the DP-900 certification and future data specializations.

Featuring 8 hours of interactive content with hands-on labs, demos, and practical exercises, you’ll learn from Azure data experts through engaging videos and real-world scenarios. This cost-effective training includes community support, practice exams, and continuous updates based on Azure’s evolving data platform. Thousands of professionals have launched successful data careers with this course—enroll today and discover the power of cloud data!

The Syllabus

Discover the key topics covered in this course:

Module 1: Describe core data concepts

You would learn about:

Define relational and non-relational data structures.
Understand data processing workloads (OLTP vs OLAP).
Identify batch and streaming data processing methods.
Learn about data roles and responsibilities in organizations.
Describe common data formats and storage patterns.

Module 2: Describe how to work with relational data on Azure

You would learn about:

Explore Azure SQL Database and SQL Managed Instance.
Configure SQL Server on Azure Virtual Machines.
Understand Azure Database for PostgreSQL and MySQL.
Learn about database security and backup strategies.
Describe high availability and disaster recovery options.

Module 3: Transform data for a data warehouse

You would learn about:

Implement T-SQL-based transformations and stored procedures.
Configure data cleansing and standardization processes.
Use advanced SQL techniques for complex business rules.
Learn about performance optimization for large-scale transformations.
Describe integration with external transformation tools.

Module 4: Load data into a Microsoft Fabric data warehouse

You would learn about:

Configure high-performance bulk loading strategies.
Implement parallel processing and partition-wise operations.
Use batch and micro-batch loading patterns.
Learn about transaction management and consistency guarantees.
Describe the monitoring and optimization of load processes.

Module 5: Query a data warehouse in Microsoft Fabric

You would learn about:

Write optimized analytical queries and complex joins.
Implement aggregations and analytical functions.
Configure materialized views and query acceleration.
Learn about query performance tuning and execution plans.
Describe integration with reporting and BI tools.

Module 6: Monitor and manage a Microsoft Fabric data warehouse

You would learn about:

Configure monitoring and performance alerting.
Implement backup and disaster recovery strategies.
Use administrative tools and automation scripts.
Learn about capacity planning and resource optimization.
Describe security and compliance for data warehouses.

Module 7: Final Review and Projects

You would learn about:

Review data warehouse design and implementation concepts.
Complete comprehensive data warehouse projects using Fabric.
Prepare for the Microsoft Fabric certification, focusing on warehousing.
Receive expert feedback on warehouse architecture and optimization.
Collaborate on enterprise data warehouse modernization case studies.

Meet The Graduated Learner

Don’t just take my word for it, check out what existing students have to say about the course:

Explore From Related Topics

Dive into related subjects to enhance your learning experience:

Synchronous

Data Analytics