Microsoft Azure Data Fundamentals (DP-900) Online Course

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.

Who should take this Course?

The Microsoft Azure Data Fundamentals (DP-900) Online Course is ideal for beginners, students, business decision-makers, and IT professionals who want to gain foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services. It’s also suitable for individuals preparing for the DP-900 certification exam and those looking to explore relational, non-relational, big data, and analytics solutions without requiring prior technical experience.

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?