Microsoft Azure Data Fundamentals (DP-900)

Level: Foundation

Build Essential Cloud Data & Microsoft Azure Knowledge
Explore Relational, Non-Relational & Analytics Workloads
Prepare for Microsoft Azure Data Fundamentals Certification
Official Microsoft Course Materials & Exam Voucher Included
Our Exam Pass Guarantee Included*
Welsh Government Funding Accepted
Get this course for FREE with PLA Digital Funding!

Course Overview

Duration: 1 Day (9am-5pm) Accredited: Yes Exams: Included Funding: PLA, PLA Digital, ReAct Type: Classroom, Onsite, Virtual Company group booking discount available
This one-day instructor-led course will introduce you to core data concepts and show you how they are implemented using Microsoft Azure data services. You’ll explore relational and non-relational data, transactional and analytical workloads, data storage and modern analytics. You’ll also learn about the Azure services used to store, process and [...]

This one-day instructor-led course will introduce you to core data concepts and show you how they are implemented using Microsoft Azure data services.

You’ll explore relational and non-relational data, transactional and analytical workloads, data storage and modern analytics. You’ll also learn about the Azure services used to store, process and analyse different types of data.

The course is suitable if you’re beginning to work with data in the cloud or want to develop a clearer understanding of Azure’s data capabilities. It will also help you prepare for the DP-900: Microsoft Azure Data Fundamentals examination.

Target Audience

This course is suitable for:

  • Anyone beginning to work with data in the cloud.
  • Aspiring data analysts, data engineers and database professionals.
  • IT professionals who want to understand Azure data services.
  • Developers and administrators who work with data-driven solutions.
  • Business and technical decision-makers who need an overview of cloud data capabilities.
  • Learners preparing for the DP-900 examination.
  • Anyone considering further Microsoft Azure data training and certification.

By the End of This Course, You Will Be Able To

  • Describe structured, semi-structured and unstructured data.
  • Explain the differences between transactional and analytical data workloads.
  • Describe core relational data concepts.
  • Identify considerations for relational data services in Azure.
  • Describe non-relational data and common use cases.
  • Identify considerations for working with non-relational data in Azure.
  • Explain common data storage and processing options.
  • Describe data ingestion and transformation processes.
  • Explain the characteristics of modern data warehousing and analytics workloads.
  • Identify relevant Microsoft Azure data services.
  • Prepare for the Microsoft DP-900 examination.
This one-day instructor-led course will introduce you to core data concepts and show you how they are implemented using Microsoft Azure data services. You’ll explore relational and non-relational data, transactional and analytical workloads, data storage and modern analytics. You’ll also learn about the Azure services used to store, process and [...]

This one-day instructor-led course will introduce you to core data concepts and show you how they are implemented using Microsoft Azure data services.

You’ll explore relational and non-relational data, transactional and analytical workloads, data storage and modern analytics. You’ll also learn about the Azure services used to store, process and analyse different types of data.

The course is suitable if you’re beginning to work with data in the cloud or want to develop a clearer understanding of Azure’s data capabilities. It will also help you prepare for the DP-900: Microsoft Azure Data Fundamentals examination.

Target Audience

This course is suitable for:

  • Anyone beginning to work with data in the cloud.
  • Aspiring data analysts, data engineers and database professionals.
  • IT professionals who want to understand Azure data services.
  • Developers and administrators who work with data-driven solutions.
  • Business and technical decision-makers who need an overview of cloud data capabilities.
  • Learners preparing for the DP-900 examination.
  • Anyone considering further Microsoft Azure data training and certification.

By the End of This Course, You Will Be Able To

  • Describe structured, semi-structured and unstructured data.
  • Explain the differences between transactional and analytical data workloads.
  • Describe core relational data concepts.
  • Identify considerations for relational data services in Azure.
  • Describe non-relational data and common use cases.
  • Identify considerations for working with non-relational data in Azure.
  • Explain common data storage and processing options.
  • Describe data ingestion and transformation processes.
  • Explain the characteristics of modern data warehousing and analytics workloads.
  • Identify relevant Microsoft Azure data services.
  • Prepare for the Microsoft DP-900 examination.

Microsoft Azure Data Fundamentals (DP-900)

Module 1: Explore core data concepts

Students will learn the fundamentals of database concepts in a cloud environment, gain basic skills in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Azure. Students will explore the roles, tasks, and responsibilities in the world of data.

Lessons of Module 1

  • Explore core data concepts
  • Explore roles and responsibilities in the world of data
  • Describe concepts of relational data
  • Explore concepts of non-relational data
  • Explore concepts of data analytics

After completing module 1, students will be able to:

  • Show foundational knowledge of cloud data services within Azure
  • Identify and describe core data concepts such as relational, non-relational, big data, and analytics
  • Explain how this technology is implemented with Azure

Module 2: Explore relational data in Azure

Students will learn the fundamentals of database concepts in a cloud environment, build basic skills in cloud data services, and develop foundational knowledge of cloud data services within Microsoft Azure. Students will explore relational data offerings, provision and deploy relational databases, and query relational data through cloud data solutions in Azure.

Lessons of Module 2

  • Explore relational data offerings in Azure
  • Explore provisioning and deploying relational database offerings in Azure
  • Query relational data in Azure

After completing Module 2, students will be able to:

  • Describe relational data offerings on Azure
  • Explain provisioning and deploying relational databases on Azure
  • Query relational data through cloud data solutions in Azure

Module 3: Explore non-relational data in Azure

Students will learn the fundamentals of database concepts in a cloud environment, get basic skills in cloud data services, and build their foundational knowledge of cloud data services within Azure. Students will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure.

Lessons of Module 3

  • Explore non-relational data offerings in Azure
  • Explore provisioning and deploying non-relational data services on Azure
  • Manage non-relational data stores in Azure

After completing Module 3, students will be able to:

  • Describe non-relational data offerings on Azure
  • Explain provisioning and deploying non-relational databases on Azure
  • Describe non-relational data stores on Azure

Module 4: Explore modern data warehouse analytics in Azure

Students will learn the fundamentals of database concepts in a cloud environment, build basic skills in cloud data services, and develop foundational knowledge of cloud data services within Azure. Students will explore the processing options available for building data analytics solutions in Azure. Students will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Students will learn what Power BI is, including its building blocks and how they work together.

Lessons of Module 4

  • Examine components of a modern data warehouse
  • Explore data ingestion in Azure
  • Explore data storage and processing in Azure
  • Get started building with Power BI

After completing Module 4, students will be able to:

  • Describe processing options available for building data analytics solutions in Azure
  • Describe Azure Synapse Analytics, Azure Databricks, and Azure HDInsight
  • Explain what Microsoft Power BI is, including its building blocks and how they work together

Microsoft Azure Data Fundamentals (DP-900)

Module 1: Explore core data concepts

Students will learn the fundamentals of database concepts in a cloud environment, gain basic skills in cloud data services, and build their foundational knowledge of cloud data services within Microsoft Azure. Students will identify and describe core data concepts such as relational, non-relational, big data, and analytics, and explore how this technology is implemented with Azure. Students will explore the roles, tasks, and responsibilities in the world of data.

Lessons of Module 1

  • Explore core data concepts
  • Explore roles and responsibilities in the world of data
  • Describe concepts of relational data
  • Explore concepts of non-relational data
  • Explore concepts of data analytics

After completing module 1, students will be able to:

  • Show foundational knowledge of cloud data services within Azure
  • Identify and describe core data concepts such as relational, non-relational, big data, and analytics
  • Explain how this technology is implemented with Azure

Module 2: Explore relational data in Azure

Students will learn the fundamentals of database concepts in a cloud environment, build basic skills in cloud data services, and develop foundational knowledge of cloud data services within Microsoft Azure. Students will explore relational data offerings, provision and deploy relational databases, and query relational data through cloud data solutions in Azure.

Lessons of Module 2

  • Explore relational data offerings in Azure
  • Explore provisioning and deploying relational database offerings in Azure
  • Query relational data in Azure

After completing Module 2, students will be able to:

  • Describe relational data offerings on Azure
  • Explain provisioning and deploying relational databases on Azure
  • Query relational data through cloud data solutions in Azure

Module 3: Explore non-relational data in Azure

Students will learn the fundamentals of database concepts in a cloud environment, get basic skills in cloud data services, and build their foundational knowledge of cloud data services within Azure. Students will explore non-relational data offerings, provisioning and deploying non-relational databases, and non-relational data stores with Microsoft Azure.

Lessons of Module 3

  • Explore non-relational data offerings in Azure
  • Explore provisioning and deploying non-relational data services on Azure
  • Manage non-relational data stores in Azure

After completing Module 3, students will be able to:

  • Describe non-relational data offerings on Azure
  • Explain provisioning and deploying non-relational databases on Azure
  • Describe non-relational data stores on Azure

Module 4: Explore modern data warehouse analytics in Azure

Students will learn the fundamentals of database concepts in a cloud environment, build basic skills in cloud data services, and develop foundational knowledge of cloud data services within Azure. Students will explore the processing options available for building data analytics solutions in Azure. Students will explore Azure Synapse Analytics, Azure Databricks, and Azure HDInsight. Students will learn what Power BI is, including its building blocks and how they work together.

Lessons of Module 4

  • Examine components of a modern data warehouse
  • Explore data ingestion in Azure
  • Explore data storage and processing in Azure
  • Get started building with Power BI

After completing Module 4, students will be able to:

  • Describe processing options available for building data analytics solutions in Azure
  • Describe Azure Synapse Analytics, Azure Databricks, and Azure HDInsight
  • Explain what Microsoft Power BI is, including its building blocks and how they work together
  • Examination duration: 45 minutes.
  • Passing score: 700 out of 1,000.
  • Examination format: Proctored Microsoft certification examination.
  • Question formats: May include multiple-choice, multiple-response, drag-and-drop and other interactive question types.
  • Open or closed book: Closed book.
  • Examination voucher: Included with the course.
  • Delivery: Online proctored or at an authorised Pearson VUE testing centre.
  • Examination duration: 45 minutes.
  • Passing score: 700 out of 1,000.
  • Examination format: Proctored Microsoft certification examination.
  • Question formats: May include multiple-choice, multiple-response, drag-and-drop and other interactive question types.
  • Open or closed book: Closed book.
  • Examination voucher: Included with the course.
  • Delivery: Online proctored or at an authorised Pearson VUE testing centre.
  • One day of instructor-led training and examination preparation delivered by an accredited Microsoft trainer.
  • Official Microsoft Azure course materials and learning resources.
  • Microsoft DP-900 certification examination voucher included. Examination vouchers are usually valid for up to 12 months from the date of issue; however, funding rules may require learners funded through schemes such as PLA, ReAct or other government-funded programmes to sit their examination within a shorter timeframe.
  • Exam Pass Guarantee – if you do not pass the examination after attending the course, you can retake the same training with NILC at no additional cost. You will only need to pay the examination fee charged by the examination provider. Applies to instructor-led courses only.
  • One day of instructor-led training and examination preparation delivered by an accredited Microsoft trainer.
  • Official Microsoft Azure course materials and learning resources.
  • Microsoft DP-900 certification examination voucher included. Examination vouchers are usually valid for up to 12 months from the date of issue; however, funding rules may require learners funded through schemes such as PLA, ReAct or other government-funded programmes to sit their examination within a shorter timeframe.
  • Exam Pass Guarantee – if you do not pass the examination after attending the course, you can retake the same training with NILC at no additional cost. You will only need to pay the examination fee charged by the examination provider. Applies to instructor-led courses only.

This course has no formal prerequisites.

It would be beneficial to have:

  • A basic understanding of databases, data analysis or common data concepts.
  • General IT knowledge and an interest in cloud technology.
  • Some familiarity with Microsoft Azure.

Although it is not required, completing Microsoft Azure Fundamentals (AZ-900) beforehand may help you understand the Azure services discussed during the course.

This course has no formal prerequisites.

It would be beneficial to have:

  • A basic understanding of databases, data analysis or common data concepts.
  • General IT knowledge and an interest in cloud technology.
  • Some familiarity with Microsoft Azure.

Although it is not required, completing Microsoft Azure Fundamentals (AZ-900) beforehand may help you understand the Azure services discussed during the course.

Does this course include an Exam Pass Guarantee?

Yes. If you do not pass after attending our instructor-led course, you can repeat the same training with us free of charge. The examination provider’s resit fee remains payable.

Who is the DP-900 course suitable for?

Our course is designed for people beginning to work with data in the cloud. It suits aspiring data professionals and anyone who wants to understand data concepts and the Azure services used for relational, non-relational and analytical workloads.

DP-900 is a beginner-level certification and can support progression towards more specialised Azure data qualifications, although it is not a prerequisite for them.

Are there any prerequisites?

There are no formal prerequisites. A basic understanding of databases, analytics or other data concepts will help you get the most from the training.

Previous Azure experience is also beneficial. We strongly recommend developing Azure fundamentals knowledge through AZ-900 or equivalent experience before attending.

View all FAQs

Does this course include an Exam Pass Guarantee?

Yes. If you do not pass after attending our instructor-led course, you can repeat the same training with us free of charge. The examination provider’s resit fee remains payable.

Who is the DP-900 course suitable for?

Our course is designed for people beginning to work with data in the cloud. It suits aspiring data professionals and anyone who wants to understand data concepts and the Azure services used for relational, non-relational and analytical workloads.

DP-900 is a beginner-level certification and can support progression towards more specialised Azure data qualifications, although it is not a prerequisite for them.

Are there any prerequisites?

There are no formal prerequisites. A basic understanding of databases, analytics or other data concepts will help you get the most from the training.

Previous Azure experience is also beneficial. We strongly recommend developing Azure fundamentals knowledge through AZ-900 or equivalent experience before attending.

View all FAQs

Dates & Prices

Upcoming Courses
Live Instructor-Led Virtual
Spaces: Available Start Date: Fri 30 October 2026
£750.00 excl. VAT
Live Instructor-Led Virtual
Spaces: Available Start Date: Fri 18 December 2026
£750.00 excl. VAT

Can't find the course dates, location or delivery type you are looking for?

Fill out the request dates form above and we'll try our best to accommodate or contact us directly.

"*" indicates required fields

Name*
Number of Delegates*
Course Delivery Format*

How we deliver our courses

Virtual

Our virtual courses allow you to access live instructor-led training from the same expert instructors that deliver our classroom courses, without leaving the comfort of your home or office. All virtual courses are fully interactive, and learners can communicate with their trainer and peers at any time.

Many of our virtual courses are also recorded, so you can recap over the content you learnt as many time as you wish.

Find out more about Virtual learning

Classroom

Our classroom courses allow you to learn and interact face-to-face with our expert instructors in a comfortable and modern training environment. All of our classroom based courses take place at NILC centers, or high quality training facilities, and include all required IT and physical equipment.

We also limit our class sizes to help promote better discussions and to ensure your learning experience is comfortable as possible.

Find out more about Classroom learning

Onsite

Save time and hassle by arranging for one of our expert instructors to come to you. Our onsite courses allow you to learn in a location of your choosing, and you can train as many or as few people as you want – from a single person or team to whole departments. We can also fully customize the course content to the specific requirements of your business or project.

We offer onsite courses throughout the UK and it can be a great team building opportunity for colleagues to come together, bond and discuss.

Find out more about Onsite learning

Online

Our Online Self Paced courses allow you to learn new skills from our expert instructors, in your own time and at your own pace. Our flexible online learning platform allows you to access content on your computer, tablet or mobile device, whether you’re on the move or at home. All our online courses come with immediate access and you can start learning straight away, from any internet enabled compatible device.

We also offer online email support from our expert instructors, so they’re always on hand and happy to help you with any questions which may arise.

Find out more about Online learning

Why choose NILC for your training?

Award-Winning Training with Industry-Leading Customer Satisfaction

Trusted Training Partner by Colleges, Government Organisations and Businesses

UK-Based Trainers with Real-World Industry Experience

Family-Run Business with Customer Service at Its Core

Rated Excellent on Trustpilot with 950+ Customer Reviews

Our learners rate us 'Excellent' on Trustpilot

Frequently Asked Questions

Yes. If you do not pass after attending our instructor-led course, you can repeat the same training with us free of charge. The examination provider’s resit fee remains payable.

Our course is designed for people beginning to work with data in the cloud. It suits aspiring data professionals and anyone who wants to understand data concepts and the Azure services used for relational, non-relational and analytical workloads.

DP-900 is a beginner-level certification and can support progression towards more specialised Azure data qualifications, although it is not a prerequisite for them.

There are no formal prerequisites. A basic understanding of databases, analytics or other data concepts will help you get the most from the training.

Previous Azure experience is also beneficial. We strongly recommend developing Azure fundamentals knowledge through AZ-900 or equivalent experience before attending.

We introduce structured, semi-structured and unstructured data; transactional and analytical workloads; and the responsibilities of database administrators, data engineers and data analysts.

 

No formal programming experience is required. The course introduces relational concepts, common database objects, and frequently used SQL statements at a foundational level.

DP-900 focuses on understanding data workloads and selecting appropriate Azure services rather than developing advanced database administration, engineering or coding skills.

Our course lasts one day, normally from 9 am to 5 pm. We offer classroom, live virtual and on-site delivery. Contact our team to discuss available dates or training for your organisation.

We recommend reviewing the course material and gaining practical familiarity with Azure data services before taking the exam. Microsoft’s study guide, free practice assessment and exam sandbox can help you check your knowledge and become familiar with the assessment experience.

Yes. We accept Welsh Government funding through PLA, PLA Digital and ReAct, subject to eligibility and availability.

Frequently Asked Questions

Yes. If you do not pass after attending our instructor-led course, you can repeat the same training with us free of charge. The examination provider’s resit fee remains payable.

Our course is designed for people beginning to work with data in the cloud. It suits aspiring data professionals and anyone who wants to understand data concepts and the Azure services used for relational, non-relational and analytical workloads.

DP-900 is a beginner-level certification and can support progression towards more specialised Azure data qualifications, although it is not a prerequisite for them.

There are no formal prerequisites. A basic understanding of databases, analytics or other data concepts will help you get the most from the training.

Previous Azure experience is also beneficial. We strongly recommend developing Azure fundamentals knowledge through AZ-900 or equivalent experience before attending.

We introduce structured, semi-structured and unstructured data; transactional and analytical workloads; and the responsibilities of database administrators, data engineers and data analysts.

 

No formal programming experience is required. The course introduces relational concepts, common database objects, and frequently used SQL statements at a foundational level.

DP-900 focuses on understanding data workloads and selecting appropriate Azure services rather than developing advanced database administration, engineering or coding skills.

Our course lasts one day, normally from 9 am to 5 pm. We offer classroom, live virtual and on-site delivery. Contact our team to discuss available dates or training for your organisation.

We recommend reviewing the course material and gaining practical familiarity with Azure data services before taking the exam. Microsoft’s study guide, free practice assessment and exam sandbox can help you check your knowledge and become familiar with the assessment experience.

Yes. We accept Welsh Government funding through PLA, PLA Digital and ReAct, subject to eligibility and availability.

Trusted By

Related Courses

Microsoft Azure Training Courses
Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB (DP-420)
Level: Advanced
4 Days (9am-5pm) Accredited: Yes Funding: PLA, PLA Digital, ReAct
Get this course for FREE with PLA Digital Funding!
£2,495.00 excl. VAT
View dates & prices
Microsoft Azure Training Courses
Microsoft Azure Administrator (AZ-104)
Level: Intermediate
4 Days (9:30am-5:00pm) Accredited: Yes Funding: PLA, PLA Digital, ReAct
Get this course for FREE with PLA Digital Funding!
£2,195.00 excl. VAT
View dates & prices
Microsoft Technical Training Courses
Microsoft Fabric Data Engineer (DP-700)
Level: Intermediate
4 Days (9am-5pm) Accredited: Yes Funding: PLA, PLA Digital, ReAct
Get this course for FREE with PLA Digital Funding!
£2,395.00 excl. VAT
View dates & prices
Microsoft Power BI Training Courses
Power BI Data Analyst (PL-300)
Level: Intermediate
3 Days (9:30am-5:00pm) Accredited: Yes Funding: PLA, PLA Digital, ReAct
Get this course for FREE with PLA Digital Funding!
£1,995.00 excl. VAT
View dates & prices
Microsoft Azure Training Courses
Microsoft Azure Data Scientist Associate (DP-100)
Level: Intermediate
4 Days (9:30am-5:00pm) Accredited: Yes Funding: PLA, PLA Digital, ReAct
Get this course for FREE with PLA Digital Funding!
£2,195.00 excl. VAT
View dates & prices
Microsoft 365 Training Courses
Microsoft Power Platform Functional Consultant Associate (PL-200)
Level: Intermediate
5 Days (9am-5pm) Accredited: Yes Funding: PLA, PLA Digital, ReAct
Get this course for FREE with PLA Digital Funding!
View dates & prices
0