DP-900: Microsoft Azure Data Fundamentals
80
Lessons
All
Skill Level
7:16h
course Duration
English
Audio
Eng
Subtitles
Share This Class:
Overview
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.
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.
Completing this course will help you:
- 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
Who is the course for?
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.
Learning Path
Using Azure and the SQL Language
- Let’s start using Microsoft Azure
- Creating SELECT statements
- Describe query techniques for data using SQL language
Relational data workloads and data services
- Describe relational data workloads
- Describe relational Azure data services – SQL Server
- Describe relational Azure data services – Other Azure relational Databases
- Identify basic management tasks for relational data
- Non-relational Data – Semi-structured Data
- Describe non-relational data offerings on Azure
- Identify basic management tasks for non-relational data
- Describe analytics workloads
- Describe the components of a modern data warehouse
- Describe data visualization in Microsoft Power BI
What people are saying
“This course helped a lot to understand relational and non relational database concepts along with Azure cloud products. Thanks a lot for creating such useful course along with practical demo.”
Sachin
“Phil is a great instructor. I’ve taken multiple classes and although I personally needed the assistance of practice exams above and beyond this course, I did pass my certification last week on my first time.”
Chris
“Enjoy this instructor. Well thought out material, step through examples. I appreciate the tips for the exam provided”
Megan
“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.”
Ankona
Previous
Next
Are You Ready To Start?
More Courses
You might also be interested in these courses
Database Fundamentals in 8 hours
Learning Database Fundamentals with Microsoft SQL Server
Microsoft SQL Server Reporting Services
Learn to create reports in SSRS