Dp-900: Azure Data Fundamentals Certification Preparation

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

Unlock the power of data and build a strong foundation in Microsoft Azure with this comprehensive DP-900: Azure Data Fundamentals course. Whether you're a beginner exploring data concepts or a professional looking to validate your skills in Azure, this course provides the essential knowledge and hands-on experience to prepare for the DP-900 certification exam.Through real-world examples and practical exercises, you’ll learn the fundamentals of data concepts, explore Azure data services, and gain confidence in querying and managing data. From relational and non-relational databases to data storage, integration, and analytics, this course covers everything you need to know to get started with Azure data solutions.Understand the Importance and Value of DataGrasp the role of data in modern businesses, recognize different data formats, and identify suitable storage solutions.Differentiate Between Relational and Non-Relational DatabasesCompare the structures, use cases, and benefits of relational databases versus non-relational (NoSQL) databases.Explore Azure Relational Database ServicesLearn about Azure SQL offerings, including Virtual Machines, Managed Instances, and Azure SQL Database, and create a free Azure subscription to deploy an Azure SQL Database.Apply SQL Fundamentals for Data QueryingWrite SQL queries using SELECT, WHERE, GROUP BY, joins, subqueries, and other clauses to manipulate and analyze data stored in Azure SQL Databases.Optimize Relational Databases with Indexes, Views, and Stored ProceduresUnderstand how clustered and non-clustered indexes improve performance, create SQL views, and automate repetitive tasks using stored procedures.Leverage Azure Services for Open-Source DatabasesWork with MySQL, MariaDB, and PostgreSQL on Azure, including deploying and querying databases using Azure Data Studio.Implement and Query Non-Relational Databases in AzureUnderstand NoSQL database concepts, work with Azure Cosmos DB, and perform hands-on exercises with Cosmos DB APIs.Utilize Azure Storage Services for Data ManagementExplore and configure Azure Blob Storage, ADLS Gen 2, Azure Files, and Azure Tables for managing unstructured and semi-structured data.Differentiate OLTP and OLAP SystemsUnderstand the characteristics of OLTP and OLAP systems and their roles in transaction processing and analytical workflows.Explore Azure Data Warehousing and Integration SolutionsGain a solid understanding of data warehousing concepts, including schema design, dimension and fact tables, and data loading processes. Learn how to build and manage data pipelines in Azure Data Factory, and streamline data integration and orchestration with hands-on exercises.Explore Azure Analytical SolutionsGet an overview by delving into advanced analytical tools in Azure, including Synapse Analytics, Delta Lake, Data Lakehouse, Azure Stream Analytics, and Microsoft Fabric. Visualize Data Insights with Power BILearn the basics of Microsoft Power BI, including creating and sharing data visualizations and dashboards to support decision-making.Why Take This Course?Comprehensive Coverage: Covers the DP-900 exam objectives in-depth, ensuring you’re well-prepared to pass the certification.Hands-On Labs: Gain practical experience by working on real-world Azure data solutions.Beginner-Friendly: Designed for those new to data concepts or cloud computing, no prior experience required.Step-by-Step Guidance: Follow a structured learning path with clear explanations and practical examples.By the end of this course, you will possess a comprehensive understanding of Azure data services and the necessary skills to confidently succeed in the DP-900 certification exam. This achievement will serve as a gateway to diverse and rewarding data-focused roles within the dynamic cloud ecosystem.

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 25 Lab - PARTITION BY Statement

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