DP-900: Microsoft Azure Data Fundamentals (Aug 2023 version)
What you'll learn
- Understand types of core data workloads and data analytics core concepts
- Understand how to work with relational data on Azure, including Azure SQL Database and Managed Instance
- Understand how to work with non-relational data on Azure, including Cosmos DB APIs, Table, Blob and File storage
- Describe analytics workloads, including data warehouses, data ingestion and processing on Azure
- Describe data visualization in Microsoft Power BI, including reports and dashboards
Requirements
- You need to know how to use a computer, and hopefully know how to use a spreadsheet.
- No prior knowledge of databases required.
- All of the programs used can be installed on Windows, and some can be installed on macOS.
- There is a 30-day refund guarantee of this Udemy course (see Udemy's refund policy).
- Why not have a look at the curriculum below and see what you can learn?
Description
This course is the foundation for the Microsoft Certificate DP-900 "Azure Data Fundamentals", and focuses on relational and non-relational data, together with analytics workloads. It is updated in line with the exam updates as of August 4, 2022, with the minor update as of August 4, 2023.
What do people like you say about this course?
Girma says: "Great! – Azure would never be difficult (as most of us think) after thoroughly going through this course."
Ankona says: "Very good course. Philip proves why is indeed the go to guy for everything to do with databases. I have taken a couple of his courses on various aspects of databases and he never disappoints."
Karen says: "This course helped me to clear the exam with 903."
We'll start off with looking at relational data. We'll create an Azure account, install an Azure SQL Database and query it. We'll then look at the 6 different clauses of the SELECT statement - SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY. After this, we'll have a look at other relational databases, including Azure Databases for PostgreSQL, MariaDB and MySQL.
After that, we'll look at non-relational data using semi-structured and non-structured data. We'll look at the five different Cosmos DB database interfaces or APIs, and which one you should use for your particular needs. We'll also look at Table, Blob and File storage.
We'll then look at analytics workloads, including Azure data services for modern data warehouses such as Azure Data Lake, Synapse Analytics, Databricks and HDInsight.
Finally, we'll look at Microsoft Power BI and how to create basic reports and dashboards.
No prior knowledge is required - we'll even see how to get a free Azure trial!
There are regular quizzes to help you remember the information, so you can be sure that you are learning.
Once you have finished this course, you will have a good introductory knowledge of core data concepts and how they are implemented using Microsoft Azure data services. And with some practice, you could even go for an official Microsoft certification - wouldn't that look good on your CV or resume? And if you are an American college student, you might even get college credit for passing that exam.
Who this course is for:
- This course is for you if you use data, and want to understand what is available on Azure.
- By the end of this course, after entering the official Practice Tests, you could enter (and hopefully pass) Microsoft's official DP-900 exam.
- Wouldn't the "Microsoft Certified: Azure Data Fundamentals" certification look good on your CV or resume?
Instructors
- 4.6 Instructor Rating
- 110,142 Reviews
- 684,017 Students
- 50 Courses
Hi. I'm Phillip, and I'm proud to Teach with Udemy as a Udemy Instructor Partner. I have been teaching on Udemy since 2015, and I have over 630,000 students and more than 40 video courses, including over a dozen Bestseller courses.
My courses include Power BI, Tableau, SQL Server, Power Platform (Power Apps, Power Automate, etc.), Azure, Microsoft Office, and more. Many of my courses follow requirements for official Microsoft certifications - so with a bit of practice, you could enter the exam and put it on your CV or resume.
I have been a Computing Consultant providing expert services in the development of computer systems and data analysis. I am one of 9 award winning Experts for Experts Exchange's 11th Annual Expert Awards. My interests are working with data, including Microsoft Power BI, Excel, Access, SQL Server, and the Power Platform.
- 4.6 Instructor Rating
- 92,828 Reviews
- 674,080 Students
- 39 Courses
I Do Data is dedicated to creating video courses on Udemy in a variety of computer-related topics, such as SQL in its different dialects and Microsoft Office.
Are you wanting to learn a new skill from the beginning? Or are you wanting to build on an existing skill? In either case, welcome.
Our courses are available on Udemy at any time, so you can watch them whenever you like, as often as you like.
For many of our courses, if you master the skills taught, you are able (if you wish) to take (and hopefully pass) the official certification offered by Microsoft, Tableau or other companies.
That would look good on your CV or resume? It could make the difference between getting a promotion, or a more rewarding job.
I Do Data courses are dedicated to enabling you to succeed.