Microsoft Azure Data Fundamentals (DP-900) Online Course

Microsoft Azure Data Fundamentals (DP-900) Online Course

DP-900 course is a fundamental course of Azure Data. The best part of this course is that there is no expiry to this course and doesn’t need recertification. You will identify basic management tasks for relational data including provisioning and deployment of relational data services and describing query techniques for data using SQL language.

Another significant factor that all candidates should consider for the successful training of the DP-900 exam is the overview of the exam skills. Applicants with a better understanding of the exam topics and weighting of the exam domains can gain a general impression of the exam prior to their preparation. The domains include core data concepts; different approaches to work with relational data on Azure; approaches to work with non-relational data on Azure; and the description of an Azure analytics workload.

You will also learn how to describe relational data workloads and relational Azure data services such as comparing PaaS, IaaS, and SaaS delivery models. Finally, you will learn data ingestion and processing on Azure and data visualization in 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?