Microsoft Azure DP-900 Data Fundamentals Training Course
Key information
Upcoming sessions
Would you like to schedule this training on a specific date? Contact us by email or via the contact form.
Description of the training: Microsoft Azure DP-900 Data Fundamentals Training Course
This Microsoft Azure DP-900 training introduces you to the fundamental concepts of data in a cloud environment. Designed to provide a clear, accessible view, it is aimed at anyone wanting to understand how data is stored, processed and analysed on the Microsoft Azure platform.
During this intensive day, you will discover the essential principles of relational and non-relational databases, exploring the Azure services dedicated to each model. You will learn to distinguish the different data formats, understand the key roles in the data world and identify the right solutions for each business need.
The course also includes an exploration of modern data warehouses and large-scale analytics tools offered by Azure, including a hands-on introduction to Power BI for data visualisation. Hands-on exercises and demonstrations let you consolidate each concept. This training is excellent preparation for the DP-900 certification. You may also be interested in our Azure Databricks DP-750 Data Engineer Training Course, our Microsoft Azure AZ-900 Fundamentals Training Course, our Microsoft Azure AZ-104 Administrator Training Course and our Cloud Computing Training Courses.
Good to know
Sessions are guaranteed from a single registrant (except in cases of force majeure). A preliminary discussion takes place between the participant and/or a company representative to fully take into account the participant’s profile (level, needs, professional context, challenges, etc.). Assessment: during the training, the trainer assesses participants’ progress through quizzes, role-play and practical exercises. Participants receive a certificate of completion at the end of the training. This training prepares you for the Microsoft DP-900 certification (certification exam not included). This training is part of our Cloud Computing Training Courses catalogue. Discover our other cloud training courses to master architectures, services and best practices on AWS, Azure and GCP.
Objectives of the training: Microsoft Azure DP-900 Data Fundamentals Training Course
By the end of the training, participants will be able to:
- Describe the fundamental concepts of data, including file formats, workload types and the roles associated with the data world
- Master the principles of relational databases and use the Azure SQL Database, Azure Database for MySQL and PostgreSQL services
- Understand non-relational data and explore the Azure Cosmos DB, Azure Blob Storage and Azure Table Storage services
- Identify the components of a modern data warehouse and understand the large-scale analytics solutions offered by Azure
- Get started with Power BI to create relevant data visualisations and interactive reports
- Prepare effectively to sit the Microsoft Azure Data Fundamentals (DP-900) certification
Prerequisites of the training: Microsoft Azure DP-900 Data Fundamentals Training Course
No technical prerequisites are required for this training. Comfort using a web browser and familiarity with basic data concepts (tables, charts) are recommended. General notions of cloud computing are an asset but not essential. Because every participant is unique, a personalised discussion with our expert lets us design a training course perfectly aligned with their objectives, level and professional challenges.
Target audience of the training: Microsoft Azure DP-900 Data Fundamentals Training Course
- IT professionals wanting to gain an understanding of data concepts in an Azure cloud environment
- Business analysts, project managers and decision-makers looking to understand Microsoft Azure data solutions to guide their strategy
- Students and people retraining who are aiming for a first Microsoft data certification
- Anyone involved in managing, operating or visualising data who wants to master Azure Data fundamentals
Detailed programme of the training: Microsoft Azure DP-900 Data Fundamentals Training Course
Core database concepts
- Explore essential data concepts: structured, semi-structured and unstructured data
- Understand roles and responsibilities in the data world: database administrator, data engineer, data analyst
- Describe the principles of relational data: tables, primary keys, foreign keys and normalisation
- Explore non-relational data concepts: documents, graphs, key-value pairs and columns
- Understand the fundamentals of data analytics and the different processing types (OLTP vs OLAP)
Relational data in Azure
- Explore the relational data services offered by Azure: Azure SQL Database, Azure SQL Managed Instance and SQL Server on a virtual machine
- Discover Azure Database for MySQL, MariaDB and PostgreSQL
- Understand provisioning and deploying relational databases in Azure
- Query relational data using the SQL language and integrated Azure tools
Non-relational data in Azure
- Explore the non-relational data services in Azure: Azure Cosmos DB, Azure Table Storage, Azure Blob Storage
- Understand provisioning and deploying non-relational data services on Azure
- Manage non-relational data stores: CRUD operations, indexing and partitioning
- Choose the right non-relational data service for each business use case
Analytics and modern data warehouses in Azure
- Examine the components of a modern data warehouse: ingestion, storage, processing and visualisation
- Discover Azure Synapse Analytics and large-scale data analytics solutions
- Explore Azure Data Factory for data pipeline orchestration
- Get started with Power BI: creating interactive reports and visual dashboards
- Understand Data Lake concepts and real-time data streaming with Azure
Why choose this training
- lays the data fundamentals on Azure: relational and non-relational
- covers analytics and modern data warehouses
- uses an accessible approach with no advanced technical prerequisites
- prepares you for the Microsoft DP-900 exam
FAQ
What is the Microsoft DP-900 certification?
The Microsoft DP-900 (Azure Data Fundamentals) certification validates an understanding of the fundamental data concepts on Azure: relational and non-relational data, analytics and data warehouses. At MFE-IT it is delivered in a small group and tailored to your context.
What is the difference between DP-900, DP-203 and DP-300?
DP-900 is the foundational level, ideal for decision-makers and beginners. DP-203 (Data Engineer Associate) targets data engineers who design pipelines. DP-300 targets database administrators.
What are the prerequisites for the DP-900 training?
No strong technical prerequisites. General IT awareness is enough: knowing the basics of databases (tables, queries) and being comfortable with a web browser.
Does the course cover relational, non-relational data and analytics on Azure?
Yes. The DP-900 preparation covers data concepts: relational data (Azure SQL) and non-relational data (Cosmos DB), analytics workloads, data warehousing and Microsoft Fabric/Synapse, as well as data-related roles and responsibilities.
Do I need prior technical knowledge for the DP-900?
No. DP-900 (Azure Data Fundamentals) is a fundamental-level certification with no technical prerequisites. It is a foundation before more advanced data certifications (DP-203, DP-300…).
How long does it take to prepare for the DP-900 exam?
The MFE-IT training lasts 1 day (6 hours), fully tailored, with a maximum of 3 participants per session. It covers the four domains of the exam.