Microsoft DP-900 - Azure Data Fundamentals
Hours: 30 / Access Length: 12 Months / Delivery: Online, Self-Paced
Online Hours: 30
Retail Price: $734.00
Course Overview:
If you’ve ever wanted to get ahead in cloud data without breaking a sweat, our Microsoft Certified Azure Data Fundamentals (exam DP-900) certification guide is the perfect start. You’ll learn the difference between relational and non-relational databases, explore Azure Synapse Analytics for end-to-end data solutions, and get hands-on with tools like Power BI for reporting. This beginner-friendly course makes mastering Azure data workloads and modern data warehouses a breeze.
Students will:
- Learn to describe core data workloads such as transactional and analytical workloads, and their key differences
- Manage and work with relational databases using tools like Azure SQL Databases, Azure Database for PostgreSQL, and Azure SQL Managed Instance
- Gain hands-on experience with Azure Cosmos DB and Azure Table Storage for managing nonrelational data, including key-value, column-family, and document data models
- Understand the fundamentals of data analytics such as batch processing, stream processing, and real-time analytics
- Learn to work with modern data warehouse solutions and implement en-to-end analytics using Azure Synapse Analytics
- Develop skills in managing and storing data using Azure Blob Storage, Data Lakes, and other Azure Storage options
- Sharpen your SQL skills by learning query techniques for managing and retrieving data from relational databases on Azure
- Deploy and manage databases and resources using Azure Resource Manager (ARM) templates
- Create HDInsight clusters and Azure Databricks for big data processing to manage Azure workloads.
This course prepares a student to take the Microsoft DP-900 - Azure Data Fundamentals national certification exam.
Course Outline:
Lesson 1: Introduction
- Who Should Read This Course?
- DP-900 Exam Objectives
- Domain 1: Describe Core Data Components
- Domain 2: Describe How to Work with Relational Data on Azure
- Domain 3: Describe How to Work with Nonrelational Data on Azure
- Domain 4: Describe an Analytics Workload on Azure
Lesson 2: Core Data Concepts
- Describe Types of Core Data Workloads
- Describe Data Analytics Core Concepts
- Summary
- Exam Essentials
Lesson 3: Relational Databases in Azure
- Relational Database Features
- Relational Database Offerings in Azure
- Management Tasks for Relational Databases in Azure
- Query Techniques for SQL
- Summary
- Exam Essentials
Lesson 4: Nonrelational Databases in Azure
- Nonrelational Database Features
- Azure Cosmos DB
- Management Tasks for Azure Cosmos DB
- Summary
- Exam Essentials
Lesson 5: File, Object, and Data Lake Storage
- File and Object Storage Features
- Azure Storage
- Management Tasks for Azure Storage
- Summary
- Exam Essentials
Lesson 6: Modern Data Warehouses in Azure
- Analytical Workload Features
- Modern Data Warehouse Components
- End-to-End Analytics with Azure Synapse Analytics
- Summary
- Exam Essentials
Lesson 7: Reporting with Power BI
- Power BI at a Glance
- Summary
- Exam Essentials
All necessary course materials are included.
Certification(s):
This course prepares a student to take the Microsoft DP-900 - Azure Data Fundamentals national certification exam.
System Requirements:
Internet Connectivity
- Connection Type: Broadband (Cable, Fiber, DSL) or LEO Satellite (e.g., Starlink)
- Minimum Speed: 10 Mbps download / 5 Mbps upload
Note: While cellular hotspots may allow basic access, high latency and fluctuating speeds can cause disconnects during videos, quizzes, or live sessions. Cellular hotspots are not recommended as a primary connection.
Hardware
- Processor: Dual-core 2.0 GHz or higher
- Memory (RAM): 8 GB or higher (4 GB minimum)
- Display Resolution: 1280 x 720 minimum (1920 x 1080 recommended)
- Audio/Video: Speakers or headphones; microphone and webcam (recommended for Live Online sessions)
Operating Systems
- Windows: Windows 10 or Windows 11
- Mac: macOS 13 (Ventura) or newer
- ChromeOS / Linux: Latest supported release
Note: While courses may load on iOS and Android devices, phones and small tablets are not recommended. Their smaller screen sizes and mobile browsers do not provide an optimal environment for coursework or live online sessions.
Web Browsers
- Google Chrome (Latest version — Recommended)
- Mozilla Firefox (Latest version)
- Microsoft Edge (Latest version)
- Apple Safari (Latest version)
Tip: Ensure JavaScript and cookies are enabled, and pop-up blockers are disabled for the learning portal.
Recommended Software
The following software is recommended for viewing and completing general course materials (individual courses may require additional software as noted in the course outline above):
- Productivity Suite: Microsoft 365/Office, Google Workspace, or LibreOffice
- PDF Reader: Adobe Acrobat Reader, Foxit PDF Reader, or a built-in browser PDF viewer
** The course outlines displayed on this website are subject to change at any time without prior notice. **