Exam DP-900: Microsoft Azure Data Fundamentals Crash Course
Published by Pearson
Exam DP-900, Microsoft Azure Data Fundamentals, is the single requirement to earn the Microsoft Certified: Azure Data Fundamentals role-based certification. According to Microsoft, the exam "is intended for candidates beginning to work with data in the cloud."
This course is also appropriate for non-certification candidates who need a high-level grasp of data science and data engineering in a Microsoft Azure context.
What you’ll learn and how you can apply it
At course conclusion, you will be able to:
- Describe core data science/data engineering concepts
- Work with relational and non-relational data in Microsoft Azure
- Perform data analytics in Microsoft Azure
This live event is for you because...
The audience for this course consists of:
- Azure Data Fundamentals certification candidates
- Azure Data Engineer Associate certification candidates
- Azure Database Administrator Associate certification candidates
- IT industry newcomers or mid-career job changers who need to evaluate whether cloud computing and data engineering is the right fit for them
- IT professionals who need to learn how Microsoft Azure implements data engineering
Prerequisites
Exam DP-900 represents a beginner/fundamentals skill set. In fact, Microsoft aims all their -900-series certifications at both technical and non-technical audiences.
Thus, the core prerequisites are:
- Basic computing skills
- Basic database knowledge (even Microsoft Excel is okay, with Microsoft Access even better)
- Basic business knowledge (to understand the use cases)
Course Set-up
To follow along with the demonstrations and practice on his or her own, the learner should have the following environment available:
- Microsoft account to create an Azure trial subscription (free)
- Microsoft Azure 30-day trial (free)
The course files will be available at Tim's GitHub repository: https://github.com/timothywarner/dp900
Recommended Preparation
- Book: Microsoft Azure SQL Database Step by Step, by Lobel and Boyd
https://learning.oreilly.com/library/view/microsoft-azuretm-sql/9780133989380/
- Video: SQL Server Fundamentals for the Accidental DBA
https://learning.oreilly.com/videos/sql-server-fundamentals/9780321601421
Recommended Follow-up
- Book: Data Just Right - Introduction to Large-Scale Data & Analytics, by Manoocherhri
https://learning.oreilly.com/library/view/data-just-right/9780133359084/
- Video: Data Science Fundamentals Part 1 - Learning Basic Concepts, Data Wrangling, and Databases with Python, by Dinu
https://learning.oreilly.com/videos/data-science-fundamentals/9780134660141/
- Watch: Exam DP-900 Microsoft Azure Data Fundamentals, Chris Sorensen https://learning.oreilly.com/videos/exam-dp-900-microsoft/9780137576708/
Schedule
The time frames are only estimates and may vary according to how the class is progressing.
DAY 1 of 2 (3 hours)
Introduction (10 minutes)
Module 1: Describe Core Data Concepts (75 minutes)
- Describe ways to represent data
- Identify options for data storage
- Describe common data workloads
- Identify roles and responsibilities for data workloads
Break (10 minutes)
Module 2: Work with Relational Data on Azure (75 minutes)
- Describe relational concepts
- Describe relational Azure data services
Conclusion (10 minutes)
DAY 2 of 2 (3 hours)
Introduction (10 minutes)
Module 3: Work with Non-Relational Data on Azure (75 minutes)
- Describe capabilities of Azure storage
- Describe capabilities and features of Azure Cosmos DB
Break (10 minutes)
Module 4: Describe an Analytics Workload on Azure (75 minutes)
- Describe common elements of a modern data warehouse
- Describe consideration for real-time data analytics
- Describe data visualization in Microsoft Power BI
Conclusion (10 minutes)
Your Instructor
Tim Warner
Tim Warner has been a Microsoft MVP in Azure AI and Cloud/Datacenter Management for 6 years and a Microsoft Certified Trainer for more than 25 years. His O'Reilly Live Training classes on generative AI, GitHub, DevOps, data engineering, cloud computing, and Microsoft certification reach hundreds of thousands of students around the world. He's written for Microsoft Press, presented at Microsoft Ignite, and contributed to several Microsoft open-source projects. You can connect with Tim on LinkedIn: timw.info/li.