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

DP-900 Azure Data Fundamentals Exam Prep In One Day

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
FAQs
Core Concepts
Describe ways to represent data
Identify options for data storage
Describe common data workloads
Identify roles and responsibilities for data workloads
Section Summary

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

Relational Database Concepts
Identify features of relational data
Describe normalization and why it is used
Three Normal Forms
LIVE DEMO: A Sample Database
Identify common structured query language (SQL) statements
LIVE DEMO: Create a Database View
LIVE DEMO: Create a Stored Procedure
LIVE DEMO: Create an Index
Describe relational Azure data services
Introduction to Relational DBs
Azure Relational DB Options
Manage Relational Databases
Create an Azure SQL Database
Use ARM Templates to Manage SQL Databases
SQL Database Security
Relational Query Tools
Structured Query Language (SQL)
Azure Storage Options
Create a Unmanaged Storage Account
Azure Blob Storage
Azure File Storage
Azure Table Storage
Don't Forget to Delete Test Resources
Non-Relational Database Concepts
Introduction to Non-Relational DBs
Non-Relational Data Types
Choose a NoSQL Database
Azure Non-Relational DB Options
Manage Non-Relational Databases
Create Cosmos DB
Query Cosmos DB
Use ARM Templates to Manage Cosmos DB
Cosmos DB Security
Cosmos DB Geo-Replication
Data Analytics Workloads
OLTP
OLAP
Synapse Analytics SQL Data Warehouse
Modern Data Warehouse
*NEW* Microsoft Fabric
Data Ingestion and Processing
Azure Data Factory
Data Visualization
Power BI Content Workflow
Wrap-up
Thank You!
End of Course Practice Test
FREE GIFT: Course Slides
Bonus Lecture

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Covers the DP-900 exam requirements in detail, which helps learners prepare for certification and demonstrate their understanding of core data concepts within the Azure ecosystem
Explores relational database concepts, including normalization and SQL, which are essential for managing structured data in Azure SQL Database and other relational services
Examines non-relational database concepts and Azure's NoSQL options like Cosmos DB, which are increasingly important for handling diverse data types and workloads
Includes demonstrations of creating database views, stored procedures, and indexes, which are practical skills for database management and optimization
Introduces Microsoft Fabric, which is a relatively new offering, giving learners exposure to cutting-edge data analytics solutions within the Azure ecosystem
Requires learners to create test resources, which may incur costs if learners do not remember to delete them after use

Save this course

Save DP-900 Azure Data Fundamentals Exam Prep In One Day to your list so you can find it easily later:
Save

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

Similar courses are unavailable at this time. Please try again later.
Effort
4.5 total hours
Via
Udemy
Instructors
Scott Duffy • 1.000.000+ Students
Software Architect.ca
Language
English
Good to know
Covers the DP-900 exam requirements in detail, which helps learners prepare for certification and demonstrate their understanding of core data concepts within the Azure ecosystem
Explores relational database concepts, including normalization and SQL, which are essential for managing structured data in Azure SQL Database and other relational services
Examines non-relational database concepts and Azure's NoSQL options like Cosmos DB, which are increasingly important for handling diverse data types and workloads
Includes demonstrations of creating database views, stored procedures, and indexes, which are practical skills for database management and optimization
Introduces Microsoft Fabric, which is a relatively new offering, giving learners exposure to cutting-edge data analytics solutions within the Azure ecosystem
Requires learners to create test resources, which may incur costs if learners do not remember to delete them after use
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
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