OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.
Course image
Udemy logo

DP-900 Azure Data Fundamentals Exam Prep In One Day

4.5 Filled star Filled star Filled star Filled star Empty star
Based on 12,356 ratings
see reviews
Scott Duffy • 1.000.000+ Students and Software Architect.ca

LEARN AZURE 

The course is completely up-to-date with new requirements.

Up-to-date with the latest requirements for January 2024.

Complete preparation for the new DP-900 Azure Data Fundamentals exam.

The content of this exam was updated for the January 2024 changes.

  • Describe core data concepts (25-30%)

  • Describe how to work with relational data on Azure (20-25%)

  • Describe how to work with non-relational data on Azure (15-20%)

  • Describe an analytics workload on Azure (25-30%)

Read more

LEARN AZURE 

The course is completely up-to-date with new requirements.

Up-to-date with the latest requirements for January 2024.

Complete preparation for the new DP-900 Azure Data Fundamentals exam.

The content of this exam was updated for the January 2024 changes.

  • Describe core data concepts (25-30%)

  • Describe how to work with relational data on Azure (20-25%)

  • Describe how to work with non-relational data on Azure (15-20%)

  • Describe an analytics workload on Azure (25-30%)

This brand-new course completely covers the DP-900 exam from start to finish. Always updated with the latest requirements. This course goes over each requirement of the exam in detail. If you have no background in databases and want to learn about them and want to learn more about database concepts and services within Azure, or have some background in databases and want to progress eventually to an Azure Data Engineer or Data Analyst type role, this course is a great resource for you.

Microsoft Azure is still the fastest-growing large cloud platform. The opportunities for jobs in cloud computing are still out there, and finding well-qualified people is the #1 problem that businesses have.

If you're looking to change your career, this would be a good entry point into cloud computing on the data side.

Sign up today.

Added English, Spanish, and Portuguese closed captions.

Enroll now

What's inside

Learning objectives

  • Take and pass the azure dp-900 data fundamentals exam
  • Understand the core concepts of azure data services like sql database
  • Understand the data analytics products of azure such as azure stream analytics
  • Understand the data reporting products of azure such as power bi

Syllabus

Welcome to the DP-900 Azure Data Fundamentals course
Welcome to the course
DP-900 Exam Requirements
Udemy Video Player
Read more

Let's see what you remember from this first section.

Traffic lights

Read about what's good
what should give you pause
and possible dealbreakers
Covers the DP-900 exam requirements in detail, which is helpful for learners with no prior database background who want to learn about database concepts and services within Azure
Explores relational database concepts, including normalization, SQL statements, and Azure relational data services, which are fundamental for anyone working with structured data in Azure
Examines non-relational database concepts, including NoSQL databases and Azure's Cosmos DB, which are essential for handling diverse data types and building scalable applications
Discusses data analytics workloads, including OLTP, OLAP, Synapse Analytics, and Microsoft Fabric, which are important for understanding data processing and warehousing in Azure
Includes live demonstrations of creating database views, stored procedures, and indexes, which provides practical experience with database management in Azure
Requires learners to create test resources, which may incur costs if learners do not remember to delete them after use

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Reviews summary

Concise dp-900 azure data fundamentals prep

According to learners, this course is a highly effective starting point for preparing for the DP-900 exam. Students found the content clear, concise, and well-structured, making complex Azure data concepts digestible. Many appreciate that it is up-to-date with the latest exam requirements. While the course provides a solid theoretical foundation and includes helpful demos, some reviewers note that additional hands-on practice or labs outside the course might be necessary to fully grasp the practical aspects and feel completely prepared for the exam. It's widely seen as excellent for beginners or those needing a quick overview, but potentially not sufficient as the sole resource for passing the exam if you have no prior experience.
Reflects recent exam changes.
"The content is current and includes the latest updates for the DP-900 exam."
"Pleased to see the course material is aligned with the January 2024 changes."
"Instructor clearly keeps the material fresh and relevant."
Accessible even with limited prior knowledge.
"As someone new to Azure and data concepts, I found this course to be a great introduction."
"Perfect starting point if you have no background in databases or cloud."
"It makes learning Azure data fundamentals approachable for everyone."
Concepts are explained simply and effectively.
"The explanations were very clear and straight to the point. Easy to follow even for complex topics."
"I appreciate how concise the lectures are. It cuts down on unnecessary jargon and gets to the core concepts."
"The instructor has a gift for explaining things simply."
Aligns well with DP-900 exam topics.
"The course content is very relevant to the DP-900 exam syllabus. It covers all the required areas."
"This course helped me understand what topics are covered in the DP-900. Highly recommended for exam prep."
"I found the course to align perfectly with the exam objectives."
Suggests supplementing with practical labs.
"While the demos are helpful, I think more hands-on exercises or labs would enhance learning."
"The theoretical part is great, but I felt the need to seek out additional labs on my own."
"Good overview, but actual practice is crucial for the exam and this course could benefit from more hands-on."

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in DP-900 Azure Data Fundamentals Exam Prep In One Day with these activities:
Review Relational Database Concepts
Solidify your understanding of relational database concepts before diving into Azure-specific implementations. This will make grasping the nuances of Azure SQL Database and other relational services much easier.
Browse courses on Relational Databases
Show steps
  • Review the definition of relational databases.
  • Study the concepts of normalization.
  • Practice writing basic SQL queries.
Read 'SQL for Data Analysis'
Enhance your SQL skills to better understand and utilize Azure's relational database offerings. This book provides practical examples and advanced techniques.
View Putting Knowledge to Work on Amazon
Show steps
  • Obtain a copy of 'SQL for Data Analysis'.
  • Read the chapters on data transformation.
  • Practice the SQL techniques described.
Practice SQL Queries on a Sample Database
Reinforce your SQL skills by practicing writing queries against a sample database. This will help you become more comfortable with SQL syntax and data manipulation.
Show steps
  • Set up a local SQL Server instance.
  • Download a sample database like AdventureWorks.
  • Write SQL queries to retrieve and manipulate data.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Read 'Azure Data Lake Storage Succinctly'
Gain a deeper understanding of Azure Data Lake Storage, a crucial component for handling large datasets in Azure. This book provides a concise and accessible overview.
View Putting Knowledge to Work on Amazon
Show steps
  • Obtain a copy of 'Azure Data Lake Storage Succinctly'.
  • Read the book to understand the core concepts.
  • Explore the Azure portal to see Data Lake Storage in action.
Create a Data Visualization Dashboard
Apply your knowledge of Azure data services and Power BI by creating a data visualization dashboard. This will solidify your understanding of data ingestion, processing, and visualization.
Show steps
  • Choose a dataset to visualize.
  • Ingest the data into Azure Data Factory.
  • Create a Power BI dashboard to visualize the data.
Build a Modern Data Warehouse Prototype
Design and implement a simplified modern data warehouse using Azure services. This project will integrate various concepts learned in the course, such as data ingestion, storage, processing, and visualization.
Show steps
  • Design the data warehouse architecture.
  • Implement data ingestion using Azure Data Factory.
  • Store data in Azure Synapse Analytics.
  • Visualize data using Power BI.
Create a Cheat Sheet for DP-900
Compile a cheat sheet summarizing key concepts, definitions, and Azure services covered in the DP-900 exam. This will serve as a valuable reference for exam preparation and future use.
Show steps
  • Review course materials and notes.
  • Identify key concepts and definitions.
  • Organize the information into a concise cheat sheet.

Career center

Learners who complete DP-900 Azure Data Fundamentals Exam Prep In One Day will develop knowledge and skills that may be useful to these careers:
Azure Data Engineer
An Azure Data Engineer designs, builds, and maintains data infrastructure on the Azure platform. They are responsible for data ingestion, processing, and storage. This course provides an introduction to Azure data services, relational databases, non-relational databases, and data analytics workloads, which are all important aspects of the work of an Azure Data Engineer. Exposure to tools like Azure Data Factory and Synapse Analytics in the course helps build a base of knowledge for this career.
See salaries and explore the career path for Azure Data Engineer
Cloud Database Administrator
A Cloud Database Administrator manages and maintains database systems in a cloud environment. This role is responsible for the performance, security, and availability of cloud databases. This course is a great starting point for anyone seeking this role, as it introduces core data concepts, relational database concepts and non-relational database concepts. The course also provides experience with Azure SQL Database and Cosmos DB, which are essential skills for a cloud database administrator.
See salaries and explore the career path for Cloud Database Administrator
Database Developer
A Database Developer designs and implements databases. This includes tasks such as writing structured query language queries, stored procedures and functions as well as creating database views, indexes, and tables. This course introduces features of relational data, normalization, and common SQL statements. The course also includes live demonstration of many of these tasks including creating database views, creating stored procedures, and creating indexes which are all necessary skills for a database developer.
See salaries and explore the career path for Database Developer
Data Architect
A Data Architect designs and manages the data infrastructure of an organization. They are responsible for ensuring data is stored efficiently and securely. To become a data architect, one should have experience with both relational and non-relational data. This course helps one build a foundation of knowledge in these concepts and also provides familiarity with Azure services. This exposure to Azure is important as many companies use this for their data infrastructure.
See salaries and explore the career path for Data Architect
Data Analyst
A Data Analyst interprets data and transforms it into actionable insights. They often use tools such as Power BI to visualize data and create reports. This course helps build a foundation for a data analyst role by explaining data concepts, relational and non-relational data, and data analytics workloads on Azure. Knowledge of Azure data services like SQL Database and Power BI, covered within this course, positions one well for a role as a data analyst.
See salaries and explore the career path for Data Analyst
Cloud Solutions Architect
A Cloud Solutions Architect designs and implements cloud computing solutions. They must understand various cloud services, including databases and data analytics. This course is a great starting point to building a base of knowledge in cloud data architecture by introducing core data concepts, relational and non-relational databases, and Azure data services. This will help a cloud solutions architect choose appropriate cloud technologies for their designs.
See salaries and explore the career path for Cloud Solutions Architect
Business Intelligence Analyst
A Business Intelligence Analyst uses data to help businesses make better decisions. They often work with data warehouses and data visualization tools. This course helps provide an introduction to data concepts, data workloads, and data visualization through tools such as Power BI. This can help someone interested in becoming a business intelligence analyst understand the underlying technology they will work with.
See salaries and explore the career path for Business Intelligence Analyst
Database Support Specialist
A Database Support Specialist provides technical support for database systems. They help users troubleshoot issues and maintain database performance. The course introduces concepts such as relational databases and non-relational databases, as well as concepts such as database normalization. The course also covers practical skills, such as creating Azure SQL databases and using ARM templates to manage them. This will help one succeed as a database support specialist.
See salaries and explore the career path for Database Support Specialist
Analytics Engineer
An Analytics Engineer transforms raw data into a format that can be used for analysis. They must have familiarity with data warehouses and structured query language. This course may be useful as it covers data warehousing concepts and provides instruction in structured query language. The course also introduces data ingestion and processing which are part of the work of analytics engineers.
See salaries and explore the career path for Analytics Engineer
Data Visualization Specialist
A Data Visualization Specialist creates dashboards and reports to communicate data insights. They are skilled in tools such as Power BI. This course may be useful to someone in this role as it introduces Power BI in the context of a modern data warehouse. The course also discusses how to connect Power BI to various data sources as well as the content workflow of Power BI.
See salaries and explore the career path for Data Visualization Specialist
Cloud Consultant
A Cloud Consultant advises businesses on how to use cloud technologies. They need to understand cloud database options and data analytics services. This course may be useful for a cloud consultant as it provides a starting point in Azure data services, relational and non-relational database concepts. The course covers a range of tools including Azure SQL Database, Cosmos DB, and Power BI which are essential for use in consulting.
See salaries and explore the career path for Cloud Consultant
Cloud Data Migration Specialist
A Cloud Data Migration Specialist helps organizations move their data to the cloud. They need a broad understanding of data concepts, relational data, non-relational data, and Azure cloud data services. This course may be useful for this role as it provides a broad, high-level overview of these areas. Understanding the basics, such as those covered in this course, helps in making informed decisions about data migration.
See salaries and explore the career path for Cloud Data Migration Specialist
Artificial Intelligence Specialist
An Artificial Intelligence Specialist develops and implements AI solutions. They are often involved in data collection and preparation. This course may be helpful to someone wishing to become an artificial intelligence specialist as it introduces them to the data concepts that are fundamental to the field. The course also covers data workloads which are very common in artificial intelligence programs.
See salaries and explore the career path for Artificial Intelligence Specialist
Machine Learning Engineer
A Machine Learning Engineer builds and deploys machine learning models. They need to work with large datasets and data pipelines. While not the primary focus of the course, it may be useful as it describes how to work with data in Azure and how to prepare it for analysis using Azure services. An understanding of how data is ingested, stored, and processed in the cloud is important to machine learning engineers
See salaries and explore the career path for Machine Learning Engineer
Technical Writer
A Technical Writer creates documentation for technical products, and should be able to explain relational and non-relational databases, and Azure data services. This course may be useful for a technical writer to become acquainted with general concepts relating to databases and data analysis on the Azure platform. It also describes tools and processes that a technical writer may need to explain in documentation.
See salaries and explore the career path for Technical Writer

Reading list

We've selected one books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in DP-900 Azure Data Fundamentals Exam Prep In One Day.
Cover image
Putting Knowledge to Work
Save
Provides a comprehensive guide to using SQL for data analysis, covering advanced techniques for data transformation and insight generation. It is particularly useful for understanding how to leverage SQL within the context of Azure data services. While not strictly required, it offers a deeper dive into SQL that complements the course material. This book is valuable as additional reading to expand your SQL skills.
Putting Knowledge to Work
Paperback
Check
Putting Knowledge to Work
Kindle Edition
Check

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Here are nine courses similar to DP-900 Azure Data Fundamentals Exam Prep In One Day.
Introduction to Data Analytics in Google Cloud
Most relevant
Information System Auditing, Governance and Management
Most relevant
Database Design and Basic SQL in PostgreSQL
Most relevant
Introduction to Data Analytics for Accounting...
Most relevant
Teradata: Building Analytics Systems
Most relevant
Advanced Tableau - Data Model
Most relevant
Build LangChain Applications using Vertex AI: Challenge...
Most relevant
Key Enablers and Challenges in Implementing Industry 4.0
Most relevant
GenAI in Data Analytics
Most relevant

Udemy Buyer Protection & Guarantee

Verified partner policies & purchase protections

Global Marketplace Leader
Free Trial & Audit

Free Lecture Previews

Free preview video lectures available for all courses; optional 7-day free trial on Personal Plan subscriptions (cancel before trial ends to avoid conversion).

Return & Refund Policy

30-Day Money-Back Guarantee

30-day money-back guarantee on all eligible individual course purchases (provided course content has not been substantially consumed or downloaded). Subscription fees are non-refundable once billed.

Buyer Protections

Verified Academic & Industry Partner

Lifetime access to purchased individual courses and future updates, verifiable certificate of completion, and direct student Q&A forums.

Key Purchase Protections
30-day 100% money-back guarantee on course purchases
Lifetime access on web, mobile, and offline
Certificate of completion included with purchase
Direct instructor Q&A and active student community
OpenCourser Verified Partner Policy details last reviewed: 2026-10-22
Course image
Rating
4.5 Filled star Filled star Filled star Filled star Empty star
Effort
4.5 total hours
Via
Udemy
Instructors
Scott Duffy • 1.000.000+ Students
Software Architect.ca
Language
English
Traffic lights
Read about what's good
what should give you pause
and possible dealbreakers
Covers the DP-900 exam requirements in detail, which is helpful for learners with no prior database background who want to learn about database concepts and services within Azure
Explores relational database concepts, including normalization, SQL statements, and Azure relational data services, which are fundamental for anyone working with structured data in Azure
Examines non-relational database concepts, including NoSQL databases and Azure's Cosmos DB, which are essential for handling diverse data types and building scalable applications
Discusses data analytics workloads, including OLTP, OLAP, Synapse Analytics, and Microsoft Fabric, which are important for understanding data processing and warehousing in Azure
Includes live demonstrations of creating database views, stored procedures, and indexes, which provides practical experience with database management in Azure
Requires learners to create test resources, which may incur costs if learners do not remember to delete them after use
Share this
Share to help others discover this course.
Facebook LinkedIn X Reddit Link Email
Begin learning today
Enroll now to gain full access to DP-900 Azure Data Fundamentals Exam Prep In One Day.
Enroll now
Save for later
Add this course to your list. Find it anytime.
Save
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser