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

DP-900 Azure Data Fundamentals

Amy Coughlin

#### Get Your Data Game On! Do you want to get started working with data in the cloud? Are you pursuing certification for Azure Data Fundamentals or looking to check the prerequisite box for Azure Data Engineer or Azure Database Administrator certifications? This course will get you up to speed with core data concepts and how they are implemented using Microsoft Azure data services. We cover big data, NoSQL resources and tooling as well as traditional relational databases in the Cloud. Completing this course will prepare you to sit the DP-900 Microsoft Azure Data Fundamentals exam. And you'll become an expert at Buzzword Bingo, too! #### You Before This Course: * Hands-on experience performing basic IT or programming tasks. * Familiarity with simple data-related concepts, such as reading and interacting with tables and charts in a spreadsheet. * Foundational knowledge of cloud concepts and experience in the Azure Portal. (The first chapter of the course includes a brief review of the most course-relevant cloud concepts in Azure as well as an optional lab, *Accessing and Using the Azure Portal*.) * NOTE: While not required, students who have earned the AZ-900 Azure Fundamentals certification, or who have equivalent knowledge and experience, will be at an advantage in preparing for the DP-900 certification exam. Check out our AZ-900 course or shorter Intro to Azure course. #### You After This Course: By the end of our time together, you should possess business-level and novice technical knowledge of core data concepts -- and have hands-on practice applying those concepts using Azure data resources. You will be prepared to pass the DP-900 exam to earn the Azure Data Fundamentals certification and/or you will be better prepared to study for Microsoft’s Azure Data Engineer Associate or Azure Database Administrator Associate certifications.

Enroll now

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Develops core data concepts and applies them using Microsoft Azure data resources
Prepares learners to pass the DP-900 Microsoft Azure Data Fundamentals exam
Taught by Amy Coughlin, an experienced instructor in the field
Suitable for learners pursuing certifications in Azure Data Engineer or Azure Database Administrator
Suitable for individuals with experience in IT or programming
Requires foundational knowledge of cloud concepts and experience in the Azure Portal

Save this course

Save DP-900 Azure Data Fundamentals 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 with these activities:
Review Microsoft Azure Core Concepts
Reinforce your foundational knowledge of Microsoft Azure concepts before starting the course to ensure a stronger understanding of the core principles and terminology used throughout.
Browse courses on Azure Fundamentals
Show steps
  • Review official Microsoft documentation on Azure Fundamentals
  • Complete the Microsoft Learn module on Azure Fundamentals
  • Take practice quizzes or tests to assess your understanding
Review Relational Database Management
Azure offers SQL databases that relate to traditional relational databases. Reviewing this topic will aid in better comprehension when learning about Azure SQL.
Browse courses on Azure SQL
Show steps
  • Review relational database concepts: tables, rows, columns, relations, primary keys, foreign keys
  • Review database normalization and transactions
  • Practice writing SQL queries
Review Azure fundamentals and Portal navigation
Reviewing the basics of Azure and the Portal will help you understand the context and application of the data concepts covered in this course.
Browse courses on Azure Fundamentals
Show steps
  • Reread or read AZ-900 or equivalent materials
  • Practice navigating the Azure Portal
21 other activities
Expand to see all activities and additional details
Show all 24 activities
Review Distributed Computing Services
Azure cloud services are cloud implemented distributed computing services. Reviewing this before the course will help build foundational knowledge.
Browse courses on Distributed Computing
Show steps
  • Review network-based and distributed systems fundamentals
  • Review and practice writing algorithms and data structures using a preferred programming language
Organize and review your course materials
Regularly reviewing your notes, assignments, and quizzes will help you retain information and improve your comprehension.
Show steps
  • Gather all materials from the course
  • Organize and label materials for easy access
  • Review materials regularly
Visualize big data in Power BI
Gain hands-on experience visualizing big data in the Azure ecosystem, enriching your understanding of data analytics and data visualization techniques.
Browse courses on Power BI
Show steps
  • Explore the Power BI interface and its data visualization capabilities.
  • Import and connect big data to Power BI using the Azure Data Connector.
  • Create interactive data visualizations, such as charts, graphs, and maps, to explore and present big data insights.
  • Publish and share your Power BI visualizations with others for collaboration and data-informed decision-making.
Follow Microsoft's Tutorial on Azure Data Fundamentals
Gain hands-on experience with Azure data services through guided tutorials.
Browse courses on Azure Data Fundamentals
Show steps
  • Access the Microsoft Learn platform and locate the Azure Data Fundamentals tutorial.
  • Follow the tutorial steps and complete the hands-on exercises.
  • Review the concepts covered in the tutorial and complete additional practice exercises.
Work through Microsoft Learn tutorials on Azure Data Services
Supplement your learning by following guided tutorials from Microsoft Learn to gain hands-on experience with Azure data services, including big data, NoSQL, and SQL database technologies.
Browse courses on Azure Data Fundamentals
Show steps
  • Choose a specific Azure data service to focus on
  • Find relevant tutorials on Microsoft Learn
  • Follow the tutorials step-by-step and complete the exercises
Practice Creating and Using Tables in Azure SQL
Azure SQL is a useful tool for developing SQL databases in the cloud. This activity will help you practice using Azure SQL tables before moving into the more complex topics of the course.
Browse courses on Azure SQL
Show steps
  • Follow an Azure SQL Tutorial on creating and editing Tables
  • Create a database and add one table
  • Create a second table with a foreign key relationship to the first table
  • Write and execute queries to insert, update, and delete data from an Azure SQL Table
Join a Study Group for Azure Data Certification
Enhance your preparation for the DP-900 certification exam by collaborating with peers in a study group.
Show steps
  • Find or form a study group with fellow learners.
  • Set regular meeting times and establish a study schedule.
  • Discuss course materials, share knowledge, and practice exam questions together.
Follow tutorials on Azure data services
Hands-on practice with Azure data services will reinforce the concepts covered in the course and help you develop practical skills.
Browse courses on Azure Data Services
Show steps
  • Identify tutorials relevant to course topics
  • Follow tutorials and complete exercises
Participate in study groups or online discussions
Engaging with peers will provide opportunities to exchange knowledge, clarify concepts, and learn from different perspectives.
Show steps
  • Find or create a study group or online forum
  • Actively participate in discussions
  • Share your own insights and questions
Join a study group or online discussion forum for Azure Data Fundamentals
Engage with other learners by joining a study group or participating in online discussion forums to exchange knowledge, ask questions, and collaborate on projects.
Browse courses on Azure Data Fundamentals
Show steps
  • Find an active study group or forum related to Azure Data Fundamentals
  • Introduce yourself and actively participate in discussions
Guided Tutorials on Implementing NoSQL and Big Data Technologies
NoSQL and Big Data technologies will be used throughout this course. Exploring these technologies will provide a stronger understanding of the various use cases of each technology and tool.
Browse courses on NoSQL
Show steps
  • Review an Introduction to Big Data Technologies Tutorial
  • Review the benefits and differences of MongoDB, Cassandra, and Redis
  • Review and implement data modeling in Azure Cosmos DB
Practice Azure Data Services Operations
Strengthen your proficiency in performing operations on Azure data services.
Browse courses on Azure Data Services
Show steps
  • Set up an Azure account and provision necessary resources.
  • Complete hands-on labs and exercises on data creation, manipulation, and analysis using Azure data services.
  • Troubleshoot common issues and errors encountered during data operations.
Complete practice questions on Azure data fundamentals
Practicing exam-style questions will help you assess your understanding of the material and identify areas for improvement.
Browse courses on Azure Data Fundamentals
Show steps
  • Find practice questions online or in books
  • Attempt questions and review correct answers
Solve practice questions on Azure Data Fundamentals
Test your understanding and prepare for the DP-900 certification exam by practicing with questions that cover key concepts and scenarios related to Azure data fundamentals.
Browse courses on Azure Data Fundamentals
Show steps
  • Find practice questions or mock exams online
  • Attempt the questions and identify areas for improvement
  • Review the correct answers and explanations
Write a Blog Post on Azure Data Services
Share your understanding of Azure data services by creating a blog post that covers key concepts and use cases.
Browse courses on Azure Data Services
Show steps
  • Research and gather information on Azure data services.
  • Organize the content into a logical and coherent structure.
  • Write the blog post, highlighting the benefits and applications of Azure data services.
Develop a data visualization dashboard for a specific dataset
Demonstrate your proficiency in using Azure data services to create meaningful data visualizations by developing a dashboard that presents insights and trends from a given dataset.
Browse courses on Azure Data Fundamentals
Show steps
  • Choose a dataset and identify key metrics
  • Design and develop a data visualization dashboard using Azure tools
Develop a data management plan for a hypothetical scenario
Creating a data management plan will help you apply the concepts of data organization, security, and access control in a practical setting.
Browse courses on Data Management
Show steps
  • Define the scenario and data requirements
  • Identify data sources and data types
  • Develop a data management strategy
  • Document the plan
Develop a Data-Driven Application
Apply your acquired knowledge to create a practical data-driven application using Azure data services.
Browse courses on Data-driven Applications
Show steps
  • Identify a problem or opportunity that can be addressed with data.
  • Design the application architecture and select appropriate Azure data services.
  • Implement the application using data ingestion, processing, and analysis techniques.
  • Deploy and test the application.
Participate in hackathons or data challenges
Participating in competitions can provide a motivating and immersive way to apply your skills and test your knowledge against others.
Browse courses on Data Analysis
Show steps
  • Find relevant hackathons or challenges
  • Form a team or work independently
  • Develop a solution and present your findings
Design a data solution for a real-world scenario
Enhance your understanding of how Azure data services can be applied in practical scenarios by designing a data solution that addresses a specific business requirement or problem.
Browse courses on Azure Data Fundamentals
Show steps
  • Identify a real-world problem or business use case
  • Research and select appropriate Azure data services
  • Design a data architecture and solution
Build a small-scale data analytics application using Azure data services
Gain hands-on experience by working on a project that involves building a data analytics application using Azure data services, such as Azure Data Factory, Azure Synapse, or Power BI.
Browse courses on Azure Data Fundamentals
Show steps
  • Define the scope and objectives of the project
  • Choose appropriate Azure data services and tools
  • Develop and implement the data analytics application

Career center

Learners who complete DP-900 Azure Data Fundamentals will develop knowledge and skills that may be useful to these careers:
Cloud Data Engineer
A Cloud Data Engineer designs, builds, and maintains data pipelines and systems. This course will teach you the core data concepts and how to use Microsoft Azure data services to implement them. This course will also prepare you for the Azure Data Fundamentals exam, which is a prerequisite for the Azure Data Engineer Associate certification. Many employers require a Master's degree in Computer Science or a related field. Taking this course may provide the foundational knowledge to qualify for relevant entry-level positions prior to pursuing a higher degree.
See salaries and explore the career path for Cloud Data Engineer
Database Administrator
A Database Administrator manages and maintains databases. This course will teach you the core data concepts and how to use Microsoft Azure data services to perform these tasks. This course will also prepare you for the Azure Data Fundamentals exam, which is a prerequisite for the Azure Database Administrator Associate certification. Most employers require a bachelor's degree in Computer Science or a related field. This course is a good first step to prepare for a bachelor's degree and an entry-level DBA position.
See salaries and explore the career path for Database Administrator
Data Engineer
A Data Engineer designs, builds, and maintains data pipelines and systems. This course will teach you the core data concepts and how to use Microsoft Azure data services to implement them. This course will also prepare you for the Azure Data Fundamentals exam, which is a prerequisite for the Azure Data Engineer Associate certification. Many employers require a bachelor's degree in computer science or a related field. This course may provide the foundational knowledge to qualify for relevant entry-level positions prior to pursuing a higher degree.
See salaries and explore the career path for Data Engineer
Data Analyst
A Data Analyst collects, analyzes, and interprets data to help businesses make informed decisions. This course will teach you the core data concepts and how to use Microsoft Azure data services to perform these tasks. This course will also prepare you for the Azure Data Fundamentals exam, which is a prerequisite for the Azure Data Analyst Associate certification. Many employers require a bachelor's degree in computer science or statistics. While this course will provide a strong foundation, it is likely insufficient without a bachelor's degree in a relevant field.
See salaries and explore the career path for Data Analyst
Data Scientist
A Data Scientist uses data to build predictive models and algorithms. This course will teach you the core data concepts and how to use Microsoft Azure data services to build a strong foundation for data science. This course will also prepare you for the Azure Data Fundamentals exam, which is a prerequisite for the Azure Data Scientist Associate certification. In addition, many employers require a master's degree in a field such as computer science, data science, or statistics. This course may be useful in preparing for a higher degree or entry-level roles.
See salaries and explore the career path for Data Scientist
Data Warehouse Architect
A Data Warehouse Architect designs and builds data warehouses. This course will teach you the core data concepts and how to use Microsoft Azure data services to implement them. This course will help build a foundation for a career in data warehouse architecture. Employers typically require a bachelor's degree in computer science or a related field. While not a perfect fit, this course may be useful for individuals looking to enter data warehouse architecture with a non-traditional background.
See salaries and explore the career path for Data Warehouse Architect
Cloud Architect
A Cloud Architect designs and builds cloud-based solutions. This course will teach you the core data concepts and how to use Microsoft Azure data services to implement them. This course will also prepare you for the Azure Data Fundamentals exam, which is a prerequisite for the Azure Solutions Architect Expert certification. Many employers require a bachelor's degree in engineering or comuter science. Nonetheless, this course may be useful in gaining an initial foundational knowledge of cloud-based systems.
See salaries and explore the career path for Cloud Architect
Data Architect
A Data Architect designs and builds data architectures. This course will teach you the core data concepts and how to use Microsoft Azure data services to implement them. This course will help build a foundation for a career in data architecture. Employers typically require a bachelor's degree in computer science or a related field. While not a perfect fit, this course may be useful for individuals looking to enter data architecture with a non-traditional background.
See salaries and explore the career path for Data Architect
Business Analyst
A Business Analyst analyzes business processes and develops solutions to improve them. This course will teach you the core data concepts and how to use Microsoft Azure data services to implement them. This course will help build a foundation for a broad range of business analyst roles. Employers typically require a bachelor's degree in business or a related field. This course provides the foundational knowledge in data to be competitive in the field of business analysis.
See salaries and explore the career path for Business Analyst
Systems Engineer
A Systems Engineer designs, builds, and maintains computer systems. This course will teach you the core data concepts and how to use Microsoft Azure data services to implement them. This course will help build a foundation for the Cloud Solutions Architect certification as well as a broad range of jobs in IT. Employers typically require a bachelor's degree in computer science or a related field. While not a direct fit, this course may provide additional support in the absence of prior datacenter familiarity.
See salaries and explore the career path for Systems Engineer
IT Administrator
An IT Administrator manages and maintains computer systems and networks. This course will teach you the core data concepts and how to use Microsoft Azure data services to implement them. This course will help build a foundation for a broad range of entry-level IT jobs. Employers typically require a bachelor's degree in computer science or a related field. While not a direct fit for the field, this course is a valuable step forward in demonstrating a commitment to the field.
See salaries and explore the career path for IT Administrator
Software Engineer
A Software Engineer designs, builds, and maintains software systems. This course will teach you the core data concepts and how to use Microsoft Azure data services to implement them. This course will help build a foundation for developing software solutions with a focus on data, big or small. Employers typically require a bachelor's degree in computer science or a related field. Familiarity with software development best practices, programming, and a foundational knowledge of mathematics may be additionally helpful in software engineering roles.
See salaries and explore the career path for Software Engineer
Project Manager
A Project Manager plans, executes, and closes projects. This course will teach you the core data concepts and how to use Microsoft Azure data services to implement them. This course will help build a foundation for managing projects. Employers typically require a bachelor's degree. While not a perfect fit, this course may provide the foundational knowledge to qualify for relevant entry-level positions prior to pursuing an advanced degree or Project Management Professional certification.
See salaries and explore the career path for Project Manager
Management Consultant
A Management Consultant advises businesses on how to improve their operations. This course will teach you the core data concepts and how to use Microsoft Azure data services to implement them. This course will help build a foundation for a broad range of consulting roles. Employers typically require a bachelor's degree in business or a related field. While not a perfect fit, this course may provide the foundational knowledge to qualify for relevant entry-level positions prior to pursuing an advanced degree.
See salaries and explore the career path for Management Consultant
IT Manager
An IT Manager plans, directs, and coordinates an organization's IT resources. This course will teach you the core data concepts and how to use Microsoft Azure data services to implement them. This course will help build a foundation for a range of supervisory roles in IT. Employers typically require a bachelor's degree in computer science or a related field. While not a perfect fit, this course may be useful for individuals looking to enter IT management with a non-traditional background.
See salaries and explore the career path for IT Manager

Reading list

We've selected 13 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.
Cover image
Big Data: Second Edition
Save
Provides a practical guide to data analytics, covering key concepts and techniques. It is particularly useful for students who are new to data analytics.
Big Data: Second Edition
Paperback
Check
Big Data: Second Edition
Kindle Edition
Check
Cover image
Exam Ref AZ-305 Designing Microsoft Azure...
Save
A valuable resource for those planning to pursue the Azure Data Engineer certification, building on the foundational knowledge gained in this course.
Exam Ref AZ-305 Designing Microsoft Azure...
Paperback
$$
Exam Ref AZ-305 Designing Microsoft Azure...
Kindle Edition
$$
Cover image
Cloud Computing
Save
Provides comprehensive introductory material for students or industry professionals who are new to Cloud Computing. It is an excellent text for foundational knowledge.
Cloud Computing: Concepts, Technology &...
Hardcover
$$
(中文) Cloud Computing: Concepts. Technology and...
Paperback
$$
Cloud Computing: Concepts, Technology &...
Kindle Edition
$$
Cover image
Designing Data-Intensive Applications
Save
Offers a thorough and highly-regarded treatment of the key design principles and patterns for building modern data-intensive applications.
Designing Data-Intensive Applications: The Big...
Paperback
$$
Designing Data-Intensive Applications: The Big...
Kindle Edition
$$
Cover image
NoSQL Distilled
Save
Provides a concise overview of NoSQL databases. It good resource for learners who want to learn more about NoSQL databases and how they compare to traditional relational databases.
NoSQL Distilled: A Brief Guide to the Emerging...
Kindle Edition
$$
Cover image
The Data Warehouse Toolkit
Save
Provides a comprehensive guide to data warehousing concepts and techniques, complementing the course's exploration of data warehousing in Azure.
The Data Warehouse Toolkit
Paperback
Check
The Data Warehouse Toolkit
Kindle Edition
Check
Cover image
Understanding Big Data: Analytics for Enterprise...
Save
Provides a broad overview of big data technologies and applications, complementing the course's introduction to big data in Azure.
Understanding Big Data : Analytics for Enterprise...
Paperback
$$
Cover image
Database Systems: The Complete Book
Save
Provides a comprehensive and highly authoritative survey of database systems, addressing basic relational concepts as well as more advanced topics.
Database Systems: The Complete Book
Kindle Edition
$$$
Database Systems The Complete Book
Paperback
$$
Database Systems: The Complete Book
Hardcover
$$$$
Goal Student Access Code Card for Database Systems:...
Printed Access Code
$$
Cover image
Hadoop: The Definitive Guide
Save
Provides a comprehensive treatment of Apache Hadoop, the popular open-source framework for distributed data processing.
Hadoop: The Definitive Guide: Storage and Analysis...
Paperback
$$
Hadoop: The Definitive Guide
Kindle Edition
$$
Hadoop: The Definitive Guide
Paperback
$$
Hadoop: The Definitive Guide
Paperback
$$
Cover image
Spark: The Definitive Guide
Save
Provides a comprehensive treatment of Apache Spark, the popular open-source framework for large-scale data processing.
Spark: The Definitive Guide
Paperback
Check
Spark: The Definitive Guide
Kindle Edition
Check
Cover image
Data Science for Business
Save
Provides a good introduction to the core concepts of data science, covering key techniques and tools as well as applications.
Data Science for Business: What You Need to Know...
Paperback
$$
Data Science for Business: What You Need to Know...
Kindle Edition
$$
Cover image
Cloud Computing
Save
Provides a comprehensive overview of cloud computing, including its benefits, challenges, and technical foundations.
Cloud Computing: Concepts, Technology, Security &...
Kindle Edition
$
Cloud Computing: Concepts, Technology, Security,...
Kindle Edition
$$
Cover image
DAX Patterns
Save
Covers data visualization techniques and tools in Azure, complementing the course's coverage of data analysis and presentation.
DAX Patterns: Second Edition
Paperback
$$
DAX Patterns 2015
Paperback
$$
DAX Patterns: Second Edition
Kindle Edition
$$

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.
Preparing for DP-900: Microsoft Azure Data Fundamentals...
Most relevant
Preparing for the AZ-900 Microsoft Azure Fundamentals Exam
Most relevant
High Throughput Databases with Microsoft Azure Cosmos DB
Most relevant
Prepare for DP-203: Data Engineering on Microsoft Azure...
Most relevant
Process Data with Microsoft Azure Synapse Link for Cosmo...
Most relevant
Modern Data Warehouse Analytics in Microsoft Azure
Most relevant
Computer Vision in Microsoft Azure
Most relevant
Data Literacy: Understanding Data Warehousing with Azure
Most relevant
Microsoft Azure Cosmos DB
Most relevant
Course image
Time
1050 hours
Level
Intermediate
Via
Pluralsight
Instructor
Amy Coughlin
Language
English
Good to know
Develops core data concepts and applies them using Microsoft Azure data resources
Prepares learners to pass the DP-900 Microsoft Azure Data Fundamentals exam
Taught by Amy Coughlin, an experienced instructor in the field
Suitable for learners pursuing certifications in Azure Data Engineer or Azure Database Administrator
Suitable for individuals with experience in IT or programming
Requires foundational knowledge of cloud concepts and experience in the Azure Portal
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 - 2024 OpenCourser