Microsoft Azure Data Fundamentals (DP-900) Crash Course
Published by O'Reilly Media, Inc.
To tackle data in the cloud, you’ll need a solid understanding of core data concepts like relational data, nonrelational data, big data, and analytics, as well as familiarity with the roles, tasks, and responsibilities for those working with data and data analytics. Getting certification might be the key to proving you have this foundational knowledge.
Microsoft Azure Data Fundamentals will validate your foundational knowledge of core data concepts and how they’re implemented using Azure data services. It also provides a foundation as you prepare for other Azure role-based certifications, like Azure Database Administrator Associate, Azure Data Engineer Associate, and Data Analyst Associate.
Join expert Emilio Melo to learn what to expect on Exam DP-900: Microsoft Azure Data Fundamentals—and how to best prepare for it. You’ll walk away with a game plan on how to study for your exam and jumpstart your career into one of the most exciting areas of IT at the moment.
APAC friendly time
What you’ll learn and how you can apply it
By the end of this live online course, you’ll understand:
- The most appropriate workloads for data platforms and modern data warehouses
- The core concepts and domains being tested by Microsoft Azure Data Fundamentals (DP-900) exam
- How to work toward the Azure Data Fundamentals certification
- The fundamental principles of data workloads on Microsoft Azure, including core data concepts, relational database workloads in Azure, Azure offerings for nonrelational databases, modern data warehouse technologies for ingestion, storage, and analytical processing, how to ingest, store, and analyze data on Azure, and the reporting capabilities available on Power BI
And you’ll be able to:
- Pinpoint the most appropriate data platform solutions for a certain customer requirement
- Describe the features of modern data warehouse technologies on Azure
- Identify gaps in your own Azure knowledge
- Effectively prepare for the Microsoft Azure Data Fundamentals (DP-900) exam
This live event is for you because...
- You’re a business or IT professional who wants to become more familiar with data platform workloads, and see the DP-900 certification as a good stepping stone to prove your value.
- You work with data workloads (on-premises or in the cloud, Microsoft or open source) and need to certify your knowledge of the area.
- You want to earn the Azure Data Fundamentals certification.
Prerequisites
- Familiarity with data and cloud solutions (useful but not required)
Recommended preparation:
- Watch the “Cloud and Azure Overview” section in Azure Overview: Introduction for Beginners (video)
Recommended follow-up:
- Take Exam DP-200: Implementing an Azure Data Solution Crash Course (live online training course with Reza Salehi)
- Take Exam DP-201: Designing an Azure Data Solution Crash Course (live online training course with Reza Salehi)
- Watch Professional Azure SQL Database Administration (video, 4h 58m)
- Watch Getting Started with Microsoft Cosmos DB Using C#: Cloud Database Support for .NET Applications (video, 1h 2m)
- Watch Learning Microsoft Power BI (video, 3h 55m)
- Watch Create an Azure SQL Data Warehouse in Minutes (video, 1h 22m)
- Watch Information Management Using Azure Data Factory (video, 1h 16m)
Schedule
The time frames are only estimates and may vary according to how the class is progressing.
Overview of the DP-900 exam (20 minutes)
- Presentation: What to expect from the DP-900 exam
- Q&A
Introduction to data platform technologies (30 minutes)
- Presentation: Core data concepts, such as batch, streaming, analytics, and relational and nonrelational databases
- Hands-on exercise: Navigate the Azure Portal interface
- Q&A
Exploring relational database offerings on Azure (45 minutes)
- Presentation: What are relational databases?; available options to create one on Azure
- Hands-on exercise: Work with Azure SQL Database
- Q&A
- Break (5 minutes)
Exploring non-relational database offerings on Azure (40 minutes)
- Presentation: Nonrelational database; how they compare to relational data; the offerings available on Azure
- Hands-on exercise: Work with Azure Tables
- Q&A
Modern data warehouse technologies on Azure (45 minutes)
- Presentation: Azure’s streaming, ETL/ELT, and analytics capabilities
- Hands-on exercise: Work with Azure Analytics solutions
- Q&A
- Break (5 minutes)
Introduction to Power BI (50 minutes)
- Presentation: The evolution of reporting tools; how Power BI interactive dashboards can help increase productivity
- Hands-on exercise: Navigate a Power BI dashboard
- Q&A
Your Instructor
Emilio Melo
Emilio Melo is a globe-trotting IT professional with projects in over 15 countries, mostly focused on Microsoft software. After 15 years of on-premises experience in infrastructure, data, and collaboration, he became fascinated by cloud technologies and the incredible transformation potential they bring.