Dp900: Azure Data Fundamentals Certification Preparation

Dp-900: Azure Data Fundamentals Certification Preparation
Published 3/2025
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz

DP-900 Certification – FULL Coverage of the LATEST Syllabus with Practical Labs with Beginner-Friendly Content!

What you’ll learn

Understand the Importance and Value of Data

Differentiate Between Relational and Non-Relational Databases

Explore Azure Relational Database Services

Apply SQL Fundamentals for Data Querying

Optimize Relational Databases with Indexes, Views, and Stored Procedures

Leverage Azure Services for Open-Source Databases

Implement and Query Non-Relational Databases in Azure

Utilize Azure Storage Services for Data Management

Differentiate OLTP and OLAP Systems

Understand Data Warehousing Architecture

Explore Data Integration Solutions

Explore Azure Synapse Analytics, Delta Lake, Data Lakehouse, Azure Stream Analytics and Microsoft Fabric to analyze data.

Visualize Data Insights with Power BI

Requirements

No prerequisites needed. You will learn everything you need to know.

Description

Overview

Section 1: Introduction

Lecture 1 Course Introduction of DP-900

Section 2: Understanding Value, Formats, and Storage of Data

Lecture 2 The Importance of Data in Modern Business

Lecture 3 Data Formats

Lecture 4 Data Storage

Section 3: Databases

Lecture 5 Introduction to Databases

Section 4: Relational Database Services in Cloud – Azure SQL Services

Lecture 6 Cloud Service Models (IaaS and PaaS)

Lecture 7 Azure SQL Services

Lecture 8 Azure Virtual Machines (VMs)

Lecture 9 Azure SQL Managed Instance

Lecture 10 Azure SQL Database

Lecture 11 Azure Free Subscription

Lecture 12 Create Azure Free Account

Lecture 13 Lab – Create Azure SQL Database in Azure cloud

Lecture 14 Overview of SQL

Section 5: SQL Fundamentals with Azure SQL Database

Lecture 15 Lab – SELECT Statement

Lecture 16 Lab – WHERE Statement

Lecture 17 Lab – ORDER BY Statement

Lecture 18 Lab – DISTINCT Statement

Lecture 19 Lab – CASE Statement

Lecture 20 Lab – Aggregations

Lecture 21 Lab – GROUP BY Statement

Lecture 22 Lab – HAVING Statement

Lecture 23 Lab – JOINS in SQL

Lecture 24 Lab – Sub Queries

Lecture 26 Lab – Create Table using an Existing Table

Lecture 27 Lab – CREATE TABLE and INSERT INTO

Lecture 28 Lab – UPDATE Statement

Section 6: The Role of Indexes, Views and Stored Procedures of a relational database

Lecture 29 What is an SQL INDEX?

Lecture 30 Lab – Understand and Create Clustered Index

Lecture 31 Lab – Understand and Create Non-Clustered index

Lecture 32 What is a SQL View?

Lecture 33 Create a SQL View

Lecture 34 What is a SQL Stored Procedure?

Lecture 35 Lab – Create a SQL Stored Procedure

Section 7: Azure Services for Open-Source Databases

Lecture 0 What are MySQL, MariaDB, and PostgreSQL?

Lecture 36 Azure Database for MySQL

Lecture 37 Azure Database for MariaDB

Lecture 38 Azure Database for PostgreSQL

Lecture 39 Connecting and Quering MySQL and PostgreSQL Databases of Azure

Lecture 40 Lab Exercise – Provision Azure Database for MySQL

Lecture 41 Lab Exercise – Query Azure Database for MySQL

Lecture 42 What’s happening to Azure Database for MariaDB?

Lecture 43 Lab Exercise – Provision Azure Database for PostgreSQL

Lecture 44 Lab Exercise – Query Azure database for PostgreSQL

Section 8: Non-relational Databases

Lecture 45 Non-relational Databases /NoSQL Databases

Lecture 46 Introduction to Azure Cosmos DB

Lecture 47 Introduction to Azure Cosmos DB APIs

Section 9: Azure Storage Services

Lecture 48 Azure File Stores

Lecture 49 Azure Blob Storage

Lecture 50 Azure Data Lake Gen 2

Lecture 51 Access Control Lists of ADLS Gen 2

Lecture 52 Azure Data Lake Gen 2 Access tiers

Lecture 53 Azure Files

Lecture 54 Azure Tables

Section 10: OLTP and OLAP Systems

Lecture 55 OLTP vs OLAP

Lecture 56 OLTP Systems

Lecture 57 OLAP Systems

Section 11: Data Warehousing Architecture

Lecture 58 Primary key Vs Foreign key

Lecture 59 Dimension Tables and Fact Tables

Lecture 60 Data Warehousing Schema Designs

Lecture 61 Data Loading Processes in Data Warehousing

Lecture 62 Batch Processing and Stream Processing

Lecture 63 Full Loads in Data Warehousing

Lecture 64 Incremental Loads in Data Warehousing

Lecture 65 Full Load vs. Incremental Load

Section 12: Azure Data Factory

Lecture 66 Introduction to Azure Data Factory

Lecture 67 Lab – Create Azure Data Factory Account

Lecture 68 Introduction to Triggers

Lecture 69 Deepen Your Knowledge of Azure Data Factory

Section 13: Analytical Data Stores in Azure

Lecture 70 Azure Synapse Analytics

Lecture 71 Azure Synapse Analytics Components

Lecture 72 Delta Lake

Lecture 73 Data Lakehouse

Lecture 74 Azure Stream Analytics

Lecture 75 Deepen Your Knowledge

Lecture 76 Microsoft Fabric

Section 14: Micrososft Power BI

Lecture 77 What is Microsoft Power BI?

Lecture 78 Analytical modeling in Microsoft Power BI

Lecture 79 Data Visualization with Power BI

Section 15: End of Course

Lecture 80 Congratulations!

Azure DP 900 Exam Seekers,Azure DP-203 Exam Seekers (DP-900 is a Prerequisite for DP-203),Junior Data Engineers,Junior Database Administrators,Junior Data Analysts,Cloud Solution Architects (Entry-Level),Business Analysts,College/University Students,Recent Graduates