DP-900: Microsoft Azure Data Fundamentals Course - Feb 2024

DP-900: Microsoft Azure Data Fundamentals || 10+ hrs of videos || 100% Syllabus Covered || 200+ Ques + 2 Practice Tests

4.65 (4389 reviews)
Udemy
platform
English
language
IT Certification
category
DP-900: Microsoft Azure Data Fundamentals Course - Feb 2024
16,313
students
11 hours
content
Jan 2024
last update
$94.99
regular price

What you will learn

Students will be prepared for the DP-900 certification exam

Learn types of core data workloads concepts

Learn basics of 4 types of NoSQL databases and implementation NoSQL on Azure Platform (Cosmos DB APIs, Table, Blob and File storage)

Learn diff Relational databases and implementation on Azure (Azure SQL Database and Managed Instance)

Learn analytics workloads, including data warehouses, data ingestion and processing on Azure

Describe data visualization in Microsoft Power BI, including reports and dashboards

Description

The Microsoft Azure DP-900 exam is the best example of a basic level of qualification to prove your knowledge of core data services and Microsoft Azure data services. Applicants are looking for accurate information on the preparation of DP-900 exams due to the favorable job opportunities associated with Microsoft Azure details.

  1. Exam Name:  Exam DP-900: Microsoft Azure Data Fundamentals

  2. Exam Duration 60 Minutes

  3. Exam Type Multiple Choice Examination

  4. Number of Questions 40 - 60 Questions

  5. Exam Fee $99 (Depends on Country)

  6. Eligibility/Pre-requisite None

  7. Exam validity Lifetime

  8. Exam Languages English, Japanese, Korean, and Simplified Chinese

Areas Covered

  • Describe types of core data workloads, batch and streaming data, and core concepts of data analytics.

  • Describe relational data workloads, relational Azure data services such as comparing PaaS, IaaS, and SaaS delivery models.

  • Identify basic management tasks for relational data including provisioning and deployment of relational data services and describing query techniques for data using SQL language.

  • Describe non-relational data workloads and non-relational data offerings on Azure and describe provisioning and deployment of non-relational data services.

  • Describe analytics workloads and components of a modern data warehouse

  • Describe data ingestion and processing on Azure and data visualization in Microsoft Power BI


Domains Covered in DP-900 Exam

Another significant factor that all candidates should consider for the successful training of the DP-900 exam is the overview of the exam skills. Applicants with a better understanding of the exam topics and weighting of the exam domains can gain a general impression of the exam prior to their preparation. The following topics can be found in the DP-900 certification test.

  • Describing core data concepts- 15% to 20%

  • Describe the approaches to work with relational data on Azure- 25% to 30%

  • Describing approaches to work with non-relational data on Azure- 25% to 30%

  • Description of an Azure analytics workload- 25% to 30%

The preparation guide for the DP-900 exam can become better with an outline of the subtopics covered in each domain. Here is a reflection on the subtopics you can find in different domains of the DP-900 certification exam.

Domain 1: Describing core data concepts

The subtopics in this domain are,

  • Describing types of core data workloads.

  • Describing core concepts of data analytics.

Domain 2: Describe the approaches to work with relational data on Azure

The subtopics in this domain are,

  • Description of relational data workloads.

  • Description of relational Azure data services.

  • Identification of basic management tasks for relational data.

  • Description of query techniques for data by leveraging SQL language.

Domain 3: Describing approaches to work with non-relational data on Azure

The subtopics in this domain are,

  • Describing non-relational data workloads.

  • Describing non-relational data offerings on Azure.

  • Identification of basic management tasks for non-relational data.

Domain 4: Description of an Azure analytics workload

The subtopics in this domain are,

  • Describing analytics workloads.

  • Describing the components of a modern data warehouse.

  • Description of data ingestion and processing on Azure.

  • Describing data visualization in Microsoft Power BI.

Content

Introduction

Introduction
IMPORTANT: Everything you need to know about exam and this course
PPT and Demo Resources
Before you start...

Introduction to Cloud Computing for absolute Beginners

What is cloud computing
IaaS vs PaaS vs SaaS
Create Azure Free Subscription
Azure Portal Overview
Azure Sandbox - How to use Azure Portal for absolutely free
How to get FREE credits for Azure Portal
Further Reading

Describe core data concepts

Basic Core Data Concepts
Data Processing Solutions (OLTP vs OLAP)
Batch Processing vs Stream Processing
Characteristics of Relational Data
Describe the concepts of Data Processing
ETL vs ELT
Data Visualization and Chart Types
Data Analytics Techniques
Further Study Material
Question [Level: Close to Real Exam]
Question [Level: Close to Real Exam]
Questions [Level: Actual exam questions]

Describe how to work with relational data on Azure

Describe Relational DB structures
PostgreSQL vs MariaDB vs MySQL
Provisioning and Deployment in Azure
Methods of Provisioning
Why choosing SQL Server in Azure
Azure IaaS vs PaaS database offerings
SQL Server PaaS Deployment Options
Azure SQL Server in Virtual Machine (IaaS)
Azure Database Security Layers
Demo: Azure Single SQL Server Provisioning and Firewall Settings
Azure SQL Database vs Data Warehouse
Identify Query Tools
Introduction to SQL
Demo: SQL SELECT Query
Visual Studio Code
Azure Database for MariaDB
Azure Database for PostgreSQL
Azure Database for MySQL
Identify the right data offering for a relational workload
Further Study Material
Question [Level: Close to Real Exam]
Question [Level: Close to Real Exam]
Questions [Level: Actual exam questions]

Describe how to work with non-relational data on Azure

Introduction to NoSQL
SQL vs NoSQL
4 types of NoSQL Databases
NoSQL Offerings by Microsoft Azure
Demo Part 1 - Provision Azure Storage Account
Demo Part 2 - Replication
Demo Part 3 - Continue Provisioning Storage account
Azure Table Storage
Azure File Storage
Azure Blob and Data Lake Security Options
How Cosmos DB evolved?
Cosmos DB Features
Cosmos DB Multi Model 5 APIs
Provision Cosmos DB Account
Cosmos DB: Globally Distribution
Cosmos DB: Multi Master
Cosmos DB: 5 consistent level
Cosmos DB: Security
Demo: Insert and query data in Your cosmos DB
Further Study Material
Question [Level: Close to Real Exam]
Question [Level: Close to Real Exam]
Questions [Level: Actual exam questions]

Describe an analytics workload on Azure

What is Data Warehouse
Why we need Data Warehouse
Transaction (OLTP) vs Analytics (OLAP) workload
Why Warehousing in Cloud
Modern Data Warehouse Architecture
What is Azure Synapse Analytics Service
Azure Synapse Architecture
Different loading methods
Batch Processing
Real Time Processing
What is Data Lake
What is Data Factory
Provision Azure Data Factory Instance
Data Factory - Components
What is HDInsight
What is Azure Databricks
Azure Data Service Architecture
Introduction to PowerBI
Building Blocks of Power BI
Paginated Report
Interactive Report
PowerBI: Role of Dashboard
Power BI: Workflow
Further Study Material
Question [Level: Close to Real Exam]
Question [Level: Close to Real Exam]
Questions [Level: Actual exam questions]

Practice Tests

Practice Test 1
Practice Test 2

Congratulations and Bonus

Bonus

Reviews

Amrith
October 15, 2023
It would be better if at the end of the video there is a summary of what we have learnt or else after every module if there is a text file to read just the important things it would make this course much better. And yes some topics need much more clarity.
Łukasz
October 2, 2023
I am happy to have bought this course because it offers deep insight into key data concepts. Every one of them is clearly and in detail explained, so the whole course is adequate for all students interested in data analytics and data engineering.
Giwa
September 15, 2023
Just passed my Azure Data Fundamentals with a 916 score and I can tell you that a few questions came out from the first practice test I took. Kudos to the tutor.
Ishan
September 9, 2023
Thank you so much for preparing such a detailed informative course. This is not only just to pass the certification exam, but it also helps a lot to understand concepts related to data fundamentals which is really good.
Amol
August 29, 2023
Thank you Eshan. Completed the course and Certification with score of 900. Looking forward for DP-203
Mini
July 31, 2023
This is an excellent course. The instructor goes above and beyond that was needed to pass the DP900 exam.
Vineed
July 27, 2023
Very good delivery and ideal pace to follow for someone who has just started. Though some of the slides have old content, eg - SQL DW mentioned at multiple places. But not a turn-off as the course more than compensates for the small oversight
Aashima
May 27, 2023
Thank you so much for preparing a very informative course. I passed my DP-900 MS exam using this course. I'm so motivated to do another certification in MS Azure thanks to the trainer Eshant Garg. Thanks a lot for helping IT community to become experts in MS Azure.
Matthias
May 20, 2023
The course covers a lot of material that is not in the official course material but is relevant for the certification. And it does it very well. Importantly the material in the deprecated course section (still available with this course) was also relevant for the certification as of May 2023 (although it is not part of the official curriculum). The included practice tests helped but I strongly recommend also going through publicly available practice test questions. Small minus points: Not all of the terminology is up to date and some of the videos in main course section refer back to videos in the deprecated section. The most confusing terminology change not reflected in the course is that (Synapse) Data Warehouses are now called '(Synapse) SQL Pools' (a central concept in the course). To the author: Please make that name change more transparent. Then, it should be easier for certification takers to follow along.
Lim
March 19, 2023
Amazing detail course and well explain from trainer but the course is too lengthy. If best reduce that information but focus on the exam information will do.
Adithi
March 9, 2023
This is really a good course, I came from a non-IT background and after 2 weeks of preparation, I scored 90%. I'm aiming for the second certification now. Thankyou for such an informative course.
Martin
February 18, 2023
Very well-designed course. Engaging content and excellent teaching. I passed my exam with 900 points!! 90% as guaranteed at the start of the course :)
Nabeel
February 7, 2023
The course helped me pass exam with 933 score. This covers most that is required to pass the exam although due to my professional experience many topics were easy for me. The sample tests included are of good quality and many questions came in the exam with different wordings. I will recommend this course.
Suyash
February 4, 2023
Eshan has simply done an amazing job with this course. What I liked was that he explained things to cement the fundamentals to use in practice and did not keep it just exam centric. I especially liked the analytics section where he included the reference diagrams of which service fits where in the lifecycle of data processing. There is so much overlap in these services that it can be confusing to understand which one to use for a particular scenario. Thank you! As for the certification, the practice tests at the end are more than enough to clear in first attempt.
Arpit
January 26, 2023
As of now, course seems to be very informative, let's move further and then it could be more understandable how actually this course is helpful!!

Charts

Price

DP-900: Microsoft Azure Data Fundamentals Course - Feb 2024 - Price chart

Rating

DP-900: Microsoft Azure Data Fundamentals Course - Feb 2024 - Ratings chart

Enrollment distribution

DP-900: Microsoft Azure Data Fundamentals Course - Feb 2024 - Distribution chart

Related Topics

3644002
udemy ID
11/18/2020
course created date
11/26/2020
course indexed date
Bot
course submited by