+- Softwarez.Info - Software's World! (https://softwarez.info)
+-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone)
+--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials)
+--- Thread: Dp-900 Microsoft Azure Data Fundamentals Certification 2022 (/Thread-Dp-900-Microsoft-Azure-Data-Fundamentals-Certification-2022)
Dp-900 Microsoft Azure Data Fundamentals Certification 2022 - AD-TEAM - 12-21-2024
![[Image: a166fb8897abaed6374adbad20f4070b.jpg]](https://i124.fastpic.org/big/2024/1222/0b/a166fb8897abaed6374adbad20f4070b.jpg)
Dp-900 Microsoft Azure Data Fundamentals Certification 2022
Last updated 12/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.73 GB | Duration: 8h 58m
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
![[Image: ENBydzM3_o.jpg]](https://images2.imgbox.com/5a/a7/ENBydzM3_o.jpg)