Dp-900 Microsoft Azure Data Fundamentals Certification 2022

DP-900 Azure Data Fundamentals Exam Preparation Course

What you'll learn

Students will be better prepared for the DP-900 certification exam

Students will learn the important aspects for what is required from an exam perspective

Requirements

Students should have prior knowledge on databases and data

Students should have some prior knowledge on basic concepts on processing data

Description

Version 3.0 - Nov 2022Carried out a major refresh of the course. The major refresh includes updating all of the videos to reflect the newer changes to Azure services. This refresh was also done to align with the newer exam objectives.Version 2.0 - Feb 2021Added chapters on Azure SQL Managed InstanceAzure Cosmos DB - Mongo DB APIAzure Cosmos DB - Gremlin APIRevised chapters on Azure DatabricksUpdated chapters on Azure Synapse Analytics to reflect recent changes in Azure on this serviceAdded a completely NEW SECTION. This section includesWorking with SQL commands on dataWorking with data in Power BIAdditional aspects related to Azure Data FactoryThis course is designed for students who want to attempt the Exam DP-900: Microsoft Azure Data FundamentalsThis course has contents for the Exam DP-900The objectives covered in this course areDescribe core data concepts (15-20%)Describe how to work with relational data on Azure (25-30%)Describe how to work with non-relational data on Azure (25-30%)Describe an analytics workload on Azure (25-30%)The following key aspects are covered in this courseWorking with SQL databases - Here we will see how to work with SQL databases using Microsoft SQL Server on an Azure virtual machine.We will then explore the Azure SQL database serviceWe will look at non-relational data stores such as Azure Storage accounts and Azure Cosmos DBWe will look at Analytical services such as Azure SynapseWe will see how to use Azure Data Factory as an ETL toolThis course has a number of videos that will help the student be prepared for the DP-900 exam. Right from the basics on understanding the different data services to knowing how they can work together.

Overview

Section 1: Describe core data concepts

Lecture 1 Slides and Diagrams download

Lecture 2 Important Course instructions

Lecture 3 Ways to represent data

Lecture 4 Common data workloads

Lecture 5 Data storage options

Lecture 6 Quick overview on roles

Lecture 7 Overview of Azure services

Lecture 8 Section Summary

Section 2: Identify considerations for relational data on Azure

Lecture 9 Section Introduction

Lecture 10 Understanding relational data

Lecture 11 Database Normalization

Lecture 12 Database Engine

Lecture 13 Why choose a cloud platform

Lecture 14 Azure Free account

Lecture 15 Creating an Azure Free Account

Lecture 16 Quick view of the Azure Portal

Lecture 17 Concepts in Azure

Lecture 18 Different options for hosting a database

Lecture 19 Lab - Creating a virtual machine

Lecture 20 Lab - Installing Microsoft SQL Server

Lecture 21 Lab - Working with the SQL Server Instance

Lecture 22 Lab - Working with the SQL Server Instance - Resources

Lecture 23 Connecting to the SQL Server VM from your machine

Lecture 24 Connecting to the SQL Server VM from your machine - Resources

Lecture 25 Lab - Using SQL Server template

Lecture 26 Azure SQL Database

Lecture 27 Lab - Creating an Azure SQL Database

Lecture 28 Type of SQL statements

Lecture 29 Lab - Working with statements

Lecture 30 Lab - Working with statements - Resources

Lecture 31 Lab - Table Relationships

Lecture 32 Lab - Table Relationships - Resources

Lecture 33 Lab - Creating another Azure SQL database

Lecture 34 Lab - SQL - WHERE Clause

Lecture 35 Lab - SQL - WHERE Clause - Resources

Lecture 36 Lab - SQL - ORDER BY Clause

Lecture 37 Lab - SQL - ORDER BY Clause - Resources

Lecture 38 Lab - SQL - GROUP BY Clause

Lecture 39 Lab - SQL - GROUP BY Clause - Resources

Lecture 40 Lab - SQL - JOIN Clause

Lecture 41 Lab - SQL - JOIN Clause - Resources

Lecture 42 Lab - Table Views

Lecture 43 Lab - Table Views - Resources

Lecture 44 Indexes in tables

Lecture 45 Lab - Working with Indexes

Lecture 46 Lab - Working with Indexes - Resources

Lecture 47 Lab - Stored Procedure

Lecture 48 Lab - Stored Procedure - Resources

Lecture 49 Azure SQL Managed Instance

Lecture 50 Different options for hosting SQL databases

Lecture 51 Lab - Azure Data Studio

Lecture 52 Lab - Using Visual Studio Code

Lecture 53 Lab - Using sqlcmd

Lecture 54 Lab - Using sqlcmd - Resources

Lecture 55 Lab - Using ARM Templates

Lecture 56 Lab - Using ARM Templates - Resources

Lecture 57 Lab - Using Azure PowerShell

Lecture 58 Lab - Using Azure PowerShell - Resources

Lecture 59 Lab - Azure Database for MySQL

Lecture 60 Lab - Azure Database for MySQL - Resources

Lecture 61 Lab - Azure Database for PostgreSQL

Lecture 62 Lab - Azure Database for PostgreSQL - Resources

Lecture 63 Azure SQL Encryption

Lecture 64 Azure SQL - Read Replica

Lecture 65 Azure SQL Database - Azure AD Integration

Lecture 66 Lab - Azure SQL Database - Firewall

Lecture 67 Section Summary

Section 3: Describe how to work with non-relational data on Azure

Lecture 68 Azure Storage Accounts - Introduction

Lecture 69 Lab - Azure Storage Accounts - Creating a storage account

Lecture 70 Lab - Azure Storage Account - Blob service

Lecture 71 Storage Accounts - Data Redundancy

Lecture 72 Azure Storage Accounts - Access tiers

Lecture 73 Lab - Azure Blob storage - Access tiers

Lecture 74 Lab - Azure Storage Account - Table service

Lecture 75 Lab - Azure Storage Account - File service

Lecture 76 Azure Storage Explorer

Lecture 77 Lab - Azure Storage Account - Firewall

Lecture 78 Non-relational data

Lecture 79 Non-relational data stores

Lecture 80 Azure Cosmos DB

Lecture 81 Lab - Creating an Azure Cosmos DB account

Lecture 82 About JSON

Lecture 83 Lab - Azure Cosmos DB - Adding data

Lecture 84 Lab - Azure Cosmos DB - Adding data - Resources

Lecture 85 Azure Cosmos DB - More on Partitions

Lecture 86 Lab - Azure Cosmos DB - MongoDB API

Lecture 87 Lab - Azure Cosmos DB - Gremlin API

Lecture 88 Lab - Azure Cosmos DB - Gremlin API - Resources

Lecture 89 Azure Cosmos DB - High Availability

Lecture 90 Azure Storage Account and Azure Cosmos DB - Azure CLI

Lecture 91 Azure Storage Account and Azure Cosmos DB - Azure CLI - Resources

Lecture 92 Section Summary

Section 4: Describe an analytics workload on Azure

Lecture 93 Recap on the common data workloads

Lecture 94 Data Processing

Lecture 95 Extract, transform and load

Lecture 96 Lab - Azure Data Lake Storage

Lecture 97 Azure Stream Analytics

Lecture 98 Lab - Azure Stream Analytics

Lecture 99 Lab - Azure Stream Analytics - Resources

Lecture 100 About ETL and ELT

Lecture 101 Azure Data Factory

Lecture 102 Lab - Azure Data Factory

Lecture 103 Lab - Azure Data Factory - Mapping Data Flow

Lecture 104 Lab - Azure Data Factory - Mapping Data Flow - Resources

Lecture 105 Parquet-based file format

Lecture 106 Using the parquet file

Lecture 107 Azure Data Factory - Triggers

Lecture 108 Azure Synapse Analytics

Lecture 109 Lab - Azure Synapse - Creating a workspace

Lecture 110 Azure Synapse - Dedicated SQL pool

Lecture 111 Azure Synapse - Fact and Dimension tables

Lecture 112 Azure Synapse - SQL Architecture

Lecture 113 Lab - Azure Synapse - Serverless SQL pool

Lecture 114 Lab - Azure Synapse - Serverless SQL pool - Resources

Lecture 115 Azure Synapse - Spark pool

Lecture 116 Azure Synapse - Spark pool - Resources

Lecture 117 Azure Synapse - Data Explorer

Lecture 118 Azure Synapse - Data Explorer - Resources

Lecture 119 What is Azure Databricks

Lecture 120 Azure Databricks - Creating a cluster

Lecture 121 Azure Databricks - Reading data

Lecture 122 Azure Databricks - Reading data - Resources

Lecture 123 Microsoft Power BI

Lecture 124 Installing Power BI Desktop

Lecture 125 Lab - Power BI Desktop - Azure Data Lake Gen2

Lecture 126 Lab - Power BI Desktop - Azure SQL Database

Lecture 127 Power BI Desktop - Removing Null values

Lecture 128 Lab - Power BI Desktop - Adding other datasets

Lecture 129 Lab - Power BI Desktop - Creating a calculated column - Power Query Editor

Lecture 130 Lab - Power BI Desktop - Creating a calculated column - DAX Expression

Lecture 131 Lab - Power BI Desktop - Table Visualization

Lecture 132 Lab - Power BI Desktop - Clustered Column Chart

Lecture 133 Why consider the Power BI Web service

Lecture 134 Publishing to Power BI

Lecture 135 Quick Note - Power Report Builder

Lecture 136 Note on other Power BI Visuals

Lecture 137 Note on Azure HDInsight

Lecture 138 Quick look at Microsoft Purview

Lecture 139 Data Analytics

Lecture 140 Section Summary

Section 5: Mini-Project

Lecture 141 What are we going to implement

Lecture 142 Azure Event Hubs

Lecture 143 Lab - Deploying an Azure Web App

Lecture 144 Lab - Deploying an Azure Event Hub

Lecture 145 Lab - Azure Web - Enabling Diagnostic setting

Lecture 146 Lab - Streaming our data

Lecture 147 Lab - Streaming our data - Resources

Lecture 148 Lab - Power BI Reports

Section 6: Practice Section

Lecture 149 Going through the sample questions

Lecture 150 Bonus Lecture

Those who want to pursue the Microsoft Azure Data Fundamentals Certification,Those who want to pass the Microsoft exam DP-900