DP-900 Azure Data Fundamentals Certification

DP-900 Azure Data Fundamentals Certification

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 6h 48m | 2.19 GB

Learn DP-900 Azure Data Fundamentals in 6 HOURS. Take your first step to Data Engineer.

Ace Exam DP-900: Microsoft Azure Data Fundamentals in less than 1 WEEK!

7 Things YOU need to know about this DP-900 Course

#1: BRAND NEW – Recorded in AUGUST 2021

#2: HANDS-ON – The best way to learn Azure Data Fundamentals is to get your hands dirty!

#3: Designed for ABSOLUTE BEGINNERS to Azure

#4: MULTI-CLOUD INSTRUCTOR – MORE THAN 100,000 Learners are learning AWS, Azure, and Google Cloud with us

#5: COMPLETE PREP for Azure Certification – DP-900 – Microsoft Azure Data Fundamentals

#6: FREE Downloadable PDF – Quickly Review for the exam

#7: FREE Practice Test – Test if you are ready for the exam

DP-900 Azure Data Fundamentals Exam tests your foundational knowledge of core data concepts and how they are implemented using Microsoft Azure data services.

DP-900 Azure Data Fundamentals Exam can be used to prepare for other Azure role-based certifications like Azure Database Administrator Associate or Azure Data Engineer Associate, but it’s not a prerequisite for any of them.

Helps you establish your knowledge of:

  • Core data concepts
  • Working with relational data on Azure
  • Working with non-relational data on Azure
  • Working with an analytics workload on Azure

Skills measured in DP-900 Azure Data Fundamentals:

  • Describe 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%)

Are you ready to get started on the amazing journey to achieve Azure Certification – DP-900 – Microsoft Azure Data Fundamentals?

Table of Contents

Azure Certification – DP 900 – Azure Data Fundamentals
1 Introduction – Azure Certification – DP 900 – Azure Data Fundamentals
2 Course Overview – Azure Certification – DP 900 – Azure Data Fundamentals
3 Course Downloads – DP 900 – Azure Data Fundamentals

Introduction to Azure for Azure Data Engineers
4 Step 01 – Getting started with Data in Azure
5 Step 02 – Getting Started with Cloud and Azure
6 Step 03 – Creating Azure Account
7 Step 04 – Why do we need Regions and AZs
8 Step 05 – Understanding Regions and Availability Zones in Azure

IaaS vs PaaS vs SaaS for Azure Data Engineers
9 Step 00 – IaaS vs PaaS vs SaaS for Azure Data Engineers
10 Step 01 – Getting started with Azure Virtual Machines
11 Commands executed in next steps – Azure VMs
12 Use SQL Server 2019 on Ubuntu2004 if you have problems
13 Step 02 – Playing with SQL Server on Azure VM
14 Step 03 – Problem with using VMs for Databases
15 Step 04 – Understanding IaaS (Infrastructure as a Service)
16 Step 05 – Understanding PaaS (Platform as a Service)
17 Step 06 – Playing with PaaS in Azure – Azure SQL Database
18 Step 07 – Getting Started with SAAS
19 Step 08 – Azure Cloud Service Categories – Scenarios
20 Do you want to help us

DP 900 – Azure Data Fundamentals – Exploring Data Formats & Data Stores
21 Step 01 – Data Formats & Data Stores – 10,000 Feet Overview
22 Step 02 – Exploring Structured Data – Relational Databases
23 Step 03 – Exploring OLAP Relational Databases
24 Step 04 – Exploring Semi Structured Data – Document
25 Step 05 – Exploring Semi Structured Data – Key Value,Graph,Column Family
26 Step 06 – Exploring Unstructured Data
27 Step 07 – Exploring Relational vs Non Relational Data – Azure Data Stores
28 Step 08 – Databases in Azure – Scenarios

DP 900 – Azure Data Fundamentals – Exploring Relational Databases
29 Step 01 – Getting Started with Relational Databases in Azure
30 Step 02 – Getting Started with Azure SQL Database
31 Course Downloads – Azure SQL Database
32 Step 03 – Playing with Azure SQL Database using Azure Data Studio
33 Step 04 – Exploring Tables and Relationships – Primary Key & Foreign Key
34 Step 05 – Exploring Structured Query Language
35 Step 06 – Exploring Clustered and Non Clustered Index
36 Step 07 – Exploring Views in Relational Databases
37 Step 08 – Understanding Normalization in Relational Databases
38 Step 09 – Quick Review of Transactions – ACID properties
39 Step 10 – Exploring Azure SQL Database – Purchase Models
40 Step 11 – Exploring Azure SQL Database – Important Features
41 Step 12 – Azure SQL Database – Remember
42 Step 13 – Getting Started with Azure SQL managed instance
43 Step 14 – Running SQL Server in Azure – A Quick Review
44 Step 15 – Exploring Other Azure Relational Databases – MySQL, MariaDB and Postgr
45 Step 16 – Exploring Scenarios for Relational Data

DP 900 – Azure Data Fundamentals – Exploring NoSQL Databases
46 Step 01 – Getting Started with Azure Cosmos DB
47 JSON Documents for next steps – Cosmos DB
48 Step 02 – Exploring Azure Cosmos DB – SQL API – Document Database
49 Step 03 – Exploring Azure Cosmos DB – MongoDB API – Document Database
50 Step 04 – Exploring Azure Cosmos DB – Table API – Key Value Database
51 Course Downloads – Cosmos DB Gremlin API
52 Step 05 – Exploring Azure Cosmos DB – Gremlin API – Graph Database
53 Step 07 – Understanding Azure Cosmos DB – What is Different
54 Step 08 – Exploring Structure of Cosmos DB
55 Step 09 – Understanding how Cosmos DB stores data – Logical & Physical Partition
56 Step 10 – Understanding Cosmos DB – Provisioned throughput vs Serverless
57 Step 11 – Exploring Scenarios for Azure Cosmos DB

DP 900 – Azure Data Fundamentals – Exploring Azure Storage
58 Step 01 – Getting Started with Azure Storage
59 Step 02 – Managed and UnManaged Block Storage in Azure
60 Step 03 – Getting Started with Azure File Storage – Azure Files
61 Step 04 – Quickly Exploring Azure File Storage – Azure Files
62 Step 05 – Understanding Azure Blob Storage and Tiers
63 Step 06 – Azure Storage – Important Things to Remember
64 Step 07 – Exploring Scenarios for Azure Storage

DP 900 – Azure Data Fundamentals – Exploring Data Analytics
65 Step 00 – DP 900 – Azure Data Fundamentals – Exploring Data Analytics
66 Step 01 – Getting Started with Data Analytics
67 Step 02 – Understanding Data Analysis Categories
68 Step 03 – Getting Started with Big Data – Terminology and Evolution
69 Step 04 – Understanding Data warehouse Best Practice – De normalized Star Schema
70 Step 05 – Getting started with Data Analytics in Azure – 3 Azure Services
71 Step 06 – Getting Started with Hadoop, Spark and Databricks
72 Step 07 – Understanding Apache Parquet
73 Step 08a – Running Hadoop and Spark workloads in Azure
74 Step 08b – Getting setup with Azure Databricks
75 Step 08c – Playing with Azure Databricks
76 Step 09 – Understanding Massive Parallel Processing (MPP)
77 Step 10 – Exploring Batch Pipelines in Azure
78 Step 11 – Exploring Streaming Pipelines in Azure
79 Step 12 – Comparing Stream vs Batch Processing
80 Step 13 – Comparing ETL vs ELT
81 Step 14 – Getting Started with Azure Synapse Analytics
82 Step 15 – Getting Started with Azure Data Factory
83 Step 16 – Playing with Azure Data Factory and Synapse Analytics
84 Step 17a – Exploring Azure Data Factory – Creating a Pipeline
85 Step 17b – Exploring Azure Data Factory – Components
86 Step 18a – Getting setup with Azure Synapse Analytics
87 Step 18b – Playing with Azure Synapse Analytics
88 Course Downloads – Power BI
89 Step 19a – Getting started with Power BI
90 Step 19b – Creating Power BI Reports
91 Step 19c – Creating Power BI Reports using AI
92 Step 19d – Exploring Power BI Components
93 Step 19e – Exploring Power BI Terminology
94 Step 20 – Data Analytics Work Flow – Quick Review
95 Step 21 – Exploring Scenarios for Azure Analytics

DP 900 – Azure Data Fundamentals – Things You Should Know
96 Step 01 – Exploring Database Tools in Azure
97 Step 02 – Exploring Roles in Data Engineering
98 Step 03 – Estimating price with Pricing Calculator
99 Step 04 – Automating resource provisioning with ARM Templates
100 Step 05 – Playing with Azure – Portal, PowerShell, CLI, Cloud Shell
101 Step 06 – Understanding Azure Resource Hierarchy
102 Step 07 – Playing with Azure Resource Hierarchy
103 Step 08 – Exploring Resource Groups, Subscriptions and Management Groups

DP 900 – Azure Data Fundamentals – Quick Review
104 Step 01 – Quick Review of Azure Database Services
105 Step 02 – Quick Review of Azure Storage Services
106 Step 03 – Quick Review of Azure Analytics Services

DP 900 – Azure Data Fundamentals – Congratulations
107 Step 01 – Getting Ready – Azure Certification – DP 900 – Azure Data Fundamentals
108 Congratulations – Azure Certification – DP 900 – Azure Data Fundamentals

Practice Test
109 Practice Test – 60+ Questions

Next Steps
110 Bonus Lecture

Homepage