Udemy

Platform

English

Language

IT Certification

Category

DP-900: Microsoft Azure Data Fundamentals - UPDATED 2021

DP-900 Azure Data Fundamentals Exam Preparation Course - Includes 150+ practice questions

4.56 (406 reviews)

2757

Students

10 hours

Content

Mar 2021

Last Update
$94.99
Regular Price


What you will 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


Description

Version 2.0 - Feb 2021

  • Added chapters on

    • Azure SQL Managed Instance

    • Azure Cosmos DB - Mongo DB API

    • Azure Cosmos DB - Gremlin API

  • Revised chapters on Azure Databricks

  • Updated chapters on Azure Synapse Analytics to reflect recent changes in Azure on this service

  • Added a completely NEW SECTION. This section includes

    • Working with SQL commands on data

    • Working with data in Power BI

    • Additional aspects related to Azure Data Factory

This course is designed for students who want to attempt the Exam DP-900: Microsoft Azure Data Fundamentals

This course has contents for the Exam DP-900

The objectives covered in this course are

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

The following key aspects are covered in this course

  • Working 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 service

  • We will look at non-relational data stores such as Azure Storage accounts and Azure Cosmos DB

  • We will look at Analytical services such as Azure Synapse

  • We will see how to use Azure Data Factory as an ETL tool

This course includes around 150 practice questions. These practice questions will help students be better prepared to take on the DP-900 exam.


Screenshots

DP-900: Microsoft Azure Data Fundamentals - UPDATED 2021
DP-900: Microsoft Azure Data Fundamentals - UPDATED 2021
DP-900: Microsoft Azure Data Fundamentals - UPDATED 2021
DP-900: Microsoft Azure Data Fundamentals - UPDATED 2021

Content

Introduction

Important Course instructions

How are we going to approach the exam objectives

Introduction to data

Different types of data

Types of systems

Notes on Types of systems

Describe how to work with relational data on Azure

Overview of storing and accessing relational data

Relationships between tables

Introduction to relational database software

Why Azure?

Concepts in Azure

Azure Free account

Quick view of the Azure Portal

About Azure Active Directory

Deploying Microsoft SQL Server on Azure

Lab - Creating a virtual machine

Lab - Installing Microsoft SQL Server

Lab - Connecting to Microsoft SQL Server

Lab - Using SQL Server template

Lab - Creating an Azure SQL Database

IaaS vs PaaS

Deleting Azure resources

Type of SQL statements

Lab - Azure SQL Database - Working with data

Lab - Azure SQL Database - Working with data - Foreign keys

Lab - Azure SQL Database - Working with data - Resources

Lab - Additional SQL statements

Lab - Creating another Azure SQL database

Lab - Table Views

Lab - Table Views - Resources

Indexes in tables

Different ways to deploy Azure resources - Overview

Lab - Creating an Azure SQL Database - PowerShell

Lab - Creating an Azure SQL Database - Azure CLI

Lab - Creating Azure SQL Databases - ARM Templates

Creating Azure SQL Databases - Resources

Roles and tools

Lab - Azure Data Studio

Using Visual Studio Code

Lab - Using sqlcmd

Lab - Using sqlcmd - Resources

Lab - Azure Database for MySQL

Lab - Azure Database for MariaDB

Lab - Azure Database for PostgreSQL

Commands for other databases

Azure SQL Encryption

Azure SQL - Read Replica

Azure SQL Database - Adding SQL users

Azure SQL Database - Adding SQL users - Resources

Azure SQL Database - Azure Active Directory

Lab - Azure SQL Database - Firewall

Quiz

Describe how to work with non-relational data on Azure

Non-relational data

Different types of non-relational data stores

Azure Storage Accounts - Introduction

Lab - Azure Storage Account - Blob service

Lab - Azure Storage Account - Table service

Lab - Azure Storage Account - File service

Azure Storage Explorer

Storage Accounts - Data Redundancy

Lab - Azure Blob storage - Service tiers

Lab - Azure Storage Account - Firewall

Lab - Azure Cosmos DB

Lab - Azure Cosmos DB - Working with data

Lab - Azure Cosmos DB - Working with data - Resource

The different API's in Azure Cosmos DB

Lab - Azure Cosmos DB - Table API

Azure Cosmos DB - High Availability

Azure Storage Account - Azure CLI

Azure Cosmos DB - Azure CLI

Azure CLI - Commands

Quiz

Describe an analytics workload on Azure

Ingesting data

Azure Data Lake Storage

Lab - Azure Data Lake Storage

Lab - Azure Event Hubs

Lab - Azure Event Hubs - Azure Data Lake Storage

Lab - Azure Stream Analytics

Lab - Azure Databricks

Lab - Azure Databricks - Resources

Azure Synapse Analytics - SQL Data warehouse

Lab - Azure Synapse Analytics - SQL Data warehouse

About ETL and ELT

Azure Data Factory

Lab - Azure Data Factory

Data Analytics

Batch and stream processing

Points on Batch Processing

A look at PowerBI Desktop

A look at powerbi.com

Performing Predictive Analysis

Section - Notes

Quiz

Practice Section

My Experience giving the exam

Practice Test 1

Practice Test 2



Reviews

E
Eduardo25 March 2021

It goes beyond the theory and concepts. It shows step by step how to actually do the things in Azure, which helps to consolidate the concepts.

C
Cristian9 March 2021

I've just cleared the DP-900 exam. This course was, without any doubt, an invaluable resource for my preparation. The practice section was spot on.

T
Tarun22 February 2021

Very slow in teaching process ,lengthy course material which is not required. But very good Questions.

T
Tracey30 January 2021

Alan goes above and beyond in preparing us not just for a certification but also to be a valuable employee!! Thank you

J
Joni22 January 2021

Its a good introduction course to take. The questions -Practice Tests are highly relevant for the exam.

B
Brian17 January 2021

Course was excellent as always from this instructor. Once again the exams were very helpful in helping me prepare for and pass this certification exam.

A
Adnan16 January 2021

Sub topics are split into separate chapters/videos so we can easily jump to any topic easily to review them again

S
Sadiq15 January 2021

Instructor did very well. Good course with good experience and knowledge gained. I received lots of information and lots of useful strategies .

D
Damian30 December 2020

I have passed the exam with 870 points after taking this course and supplementing this content with Microsoft Documentation. Please make a preparation course for DP-300. Thank you!

A
Amit24 December 2020

Question 83, on practice test 2: OLTP - answer should be Schema on Write instead of Schema on Read. Refer :https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction-processing

D
Deepak15 December 2020

Hi Alan, I cleared the DP-900 exam today with a score of 916 !!! I would like to take this opportunity to thank you for the great course content and your excellent teaching style. The Labs really helped a lot in remembering many key concepts. The practice tests were very helpful. I am looking forward to taking more of your Azure related advanced courses. Thanks, Deepak Holla.

V
Vinicius5 December 2020

I passed in DP-900 exam! This course help me a lot. Thanks Alan Rodrigues for this top course. The course is very complete and high level details about all exam. I recommend this course. It worked for me.

N
Nate4 December 2020

Terrific course. Lots of great hands-on demonstrations rather than just endless Powerpoint slides. Demonstrations are not rushed. Easy to follow along step by step.



3611140

Udemy ID

11/3/2020

Course created date

11/21/2020

Course Indexed date
Bot
Course Submitted by