Microsoft Azure Data Fundamentals (DP-900) Online Course
The DP-900 course provides a solid foundation in Azure Data fundamentals, making it ideal for those new to cloud-based data solutions. A key advantage of this certification is that it does not expire and requires no recertification.
In this course, you'll explore core concepts such as relational data workloads, provisioning and deploying relational data services, and using SQL for querying data. You’ll also gain insight into managing both relational and non-relational data in Azure, along with understanding key elements of Azure’s analytics capabilities.
To support your success on the DP-900 exam, the course offers a comprehensive overview of the exam domains, including:
- Core data concepts
- Working with relational data on Azure
- Working with non-relational data on Azure
- Describing an Azure analytics workload
You’ll also learn to compare service models like PaaS, IaaS, and SaaS, as well as understand data ingestion, processing in Azure, and data visualization using Microsoft Power BI.
Table of Contents
Introduction
- Course Introduction
- Everything You Need to Know about the Exam and Its Course
Azure Portal Introduction
- Create Azure Free Subscription
- Azure Portal Overview
- Azure Sandbox - How to Use Azure Portal for Free
Describe Core Data Concepts
- Introduction and Learning Objectives
- Basic Core Data Concepts
- Data Processing Solutions (OLTP Versus OLAP)
- Basic Processing Versus Stream Processing
- Characteristics of Relational Database
- Describe the Concepts of Data Processing
- Questions: ETL Versus ELT
- Data Visualization and Chart Types
- Data Analytics Techniques
Describe How to Work with Relational Data on Azure
- Introduction and Learning Objectives
- Describe Relational DB structures
- PostgreSQL Versus MariaDB Versus MySQL
- Provisioning and Deployment in Azure
- Methods of Provisioning
- IaaS Versus PaaS Versus SaaS
- Why Choose SQL Database in Azure
- Azure IaaS Versus PaaS Database Offerings
- SQL Database PaaS Deployment Options
- Azure SQL Server in Virtual Machine (IaaS)
- Azure SQL Database Versus Data Warehouse
- Azure Relational Database Security Layers
- Demo: Azure Single SQL Server Database and Firewall Settings
- 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
Describe How to Work with Non-Relational Data on Azure
- Introduction and Learning Objectives
- Introduction to NoSQL
- SQL Versus NoSQL
- Four Types of NoSQL Databases
- JSON File Structure
- NoSQL Offerings by Microsoft Azure
- Azure Storage Services Overview
- Demo Provision Azure Storage Account
- Data Redundancy Options
- Azure Blob Storage
- Azure Storage Access Tiers
- Azure Table Storage
- Azure Queue Storage
- Azure File Share Storage
- Demo Azure File Share Storage
- Azure Disk Storage and Demo
- Azure Blob and Data Lake Security Options
- How Cosmos DB Evolved
- Features of Cosmos DB
- Cosmos DB Multi-Model 5 APIs
- Provision Cosmos DB Account
- NoSQL Deployment Options
- Cosmos DB: Global Distribution
- Cosmos DB: Multi-Master
- Cosmos DB: Five Consistent Levels
- Cosmos DB: Security
- Demo: Insert and Query Data in Your cosmos DB
Describe an Analytics Workload on Azure
- Introduction and Learning Objectives
- What is Data Warehouse
- Why We Need Data Warehouse
- Transaction (OLTP) Versus Analytics (OLAP) Workload
- Star Schema - Fact/Dimension
- Why Warehousing in Cloud
- Modern Data Warehouse Architecture
- What is Azure Synapse Analytics Service
- MPP Architecture - Synapse Analytics Service
- Different Loading Methods
- What is HDInsight
- Batch Processing
- Real Time Processing
- What is Data Lake
- Data Lake Gen2 Hierarchical Namespace
- What is Data Factory
- Provision Azure Data Factory Instance
- Data Factory - Components
- Data Factory Components Relation
- Data Factory Triggers
- What is Azure Databricks
- Azure Data Service Architecture
- Introduction to Power BI
- Building Blocks of Power BI
- Paginated Report
- Interactive Report
- Power BI: Role of Dashboard
- Power BI: Workflow
Wrapping Up
- What's Next?