DP-900 – Microsoft Azure Data Fundamentals

DP-900: Microsoft Azure Data Fundamentals is a course designed to help learners become proficient in working with and managing data in the Azure cloud platform. The course provides a thorough exploration of how data management works in the Azure environment, and how users can create and utilize resources in Azure to optimize their data management operations. Through the course, learners will gain an understanding of how to effectively manage and analyze data using Azure, as well as best practices for using data resources in Azure.

What you’ll learn

Students will be prepared for the DP-900 certification exam
Learn types of core data workloads concepts
Learn basics of 4 types of NoSQL databases and implementation NoSQL on Azure Platform (Cosmos DB APIs, Table, Blob and File storage)
Learn diff Relational databases and implementation on Azure (Azure SQL Database and Managed Instance)
Learn analytics workloads, including data warehouses, data ingestion and processing on Azure
Describe data visualization in Microsoft Power BI, including reports and dashboards

Course Content:

Module1: Azure Portal Introduction

Create Azure Free Subscription
Azure Portal Overview
IaaS vs PaaS vs SaaS
Azure Sandbox – How to use Azure Portal for absolutely free
How to get FREE credits for Azure Portal

Module2: Describe Core Data Concepts

Explore core data concepts
Explore roles and responsibilities in the world of data
Describe concepts of relational data
Explore concepts of non-relational data
Explore concepts of data analytics

Module 3: How to work with rational data on Azure

Relational Database
Describe Relational DB structure
Provisioning and Deployment in Azure
Methods of Provisioning
Why choosing SQL Database in Azure
Azure IaaS vs PaaS database offerings
SQL Database PaaS Deployment Options
Azure SQL Server in Virtual Machine (IaaS)
Azure SQL Database vs Data Warehouse
Azure Single SQL Server Database and Firewall Settings
Open Source DB: PostgreSQL, MariaDB and MySQL
Identify Query Tools
Introduction to SQL
Demo: SQL SELECT Query
Identify the right data offering for a relational workload

Module 4: How to work with non rational data on Azure

Introduction and Learning Objectives
Introduction to NoSQL
SQL vs NoSQL
4 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 File Share Storage
Demo Azure File Share Storage
How Cosmos DB evolved?
Cosmos DB Features
Cosmos DB Multi Model 5 APIs
Provision Cosmos DB Account
Cosmos DB: Globally Distribution

Module5: Explore analytics workload on Azure

Introduction and Learning Objectives
What is Data Warehouse
Why we need Data Warehouse
Star Schema – Fact/Dimension
Why Warehousing in Cloud
Modern Data Warehouse Architecture
What is Azure Synapse Analytics Service
What is HDInsight
Batch Processing
Real Time Processing
Azure Stream Analytics
Batch Processing vs Stream Processing
What is Data Lake
Data Lake Gen2 Hierarchical namespace
What is Data Factory
Provision Azure Data Factory Instance08:02
Data Factory – Components
Data Factory Components Relation
Data Factory Triggers
What is Azure Data bricks
Azure Data Service Architecture
Introduction to PowerBI
Building Blocks of Power BI
PowerBI: Role of Dashboard
Power BI: Workflow
Data Visualization and Chart Types
Further Study Material

Who this course is for:

Those who want to pass the Microsoft exam DP-900
Those who want to enter in to Azure Cloud Data related profiles like Data Engineer, Data Scientist, Data Analyst etc

Course Prerequisite

This is basic course and so no prerequisite is required
However previous database knowledge or experience would help student to understand course quickly

Free Exam Practice Test:

Microsoft DP-900 Microsoft Azure Data Fundamentals

International Student Fee 500 USD

Job Interview Preparation (Soft Skills Questions & Answers)