New

LEARN, LEVEL UP, LEAD. Upto 88% off on courses for a limited time. View Courses

DP-900: Microsoft Azure Data Fundamentals Video Course + Qus

DP-900: Microsoft Azure Data Fundamentals Video Course + Qus (WC – 1000)

Beginner
4.7 (2,886 Ratings) 11,041 Students enrolled English

What will i learn?

  • Students will be prepared for the DP-900 certification exam
  • Learn types of core data workloads concepts
  • Learn basics of 4 types of NoSQL databases and implementation NoSQL on Azure Platform (Cosmos DB APIs, Table, Blob and File storage)
  • Learn diff Relational databases and implementation on Azure (Azure SQL Database and Managed Instance)
  • Learn analytics workloads, including data warehouses, data ingestion and processing on Azure
  • Describe data visualization in Microsoft Power BI, including reports and dashboards
Requirements
  • This is basic course and so no prerequisite is required
  • However previous database knowledge or experience would help student to understand course quickly
Curriculum for this course
91 Lessons 10:38:54 Hours
  • Introduction and Learning Objectives
    00:03:45
  • Describe Relational DB structures
    00:12:18
  • PostgreSQL vs MariaDB vs MySQL
    00:08:00
  • Provisioning and Deployment in Azure
    00:04:50
  • Methods of Provisioning
    00:09:50
  • IaaS vs PaaS vs SaaS
    00:06:17
  • Why choosing SQL Database in Azure
    00:02:58
  • Azure IaaS vs PaaS database offerings
    00:09:22
  • SQL Database PaaS Deployment Options
    00:03:50
  • Azure SQL Server in Virtual Machine (IaaS)
    00:01:57
  • Azure SQL Database vs Data Warehouse
    00:02:33
  • Azure Relational Database Security Layers
    00:08:11
  • Demo: Azure Single SQL Server Database and Firewall Settings
    00:15:37
  • Identify Query Tools
    00:12:39
  • Introduction to SQL
    00:05:58
  • Demo: SQL SELECT Query
    00:07:08
  • Visual Studio Code
    00:09:03
  • Azure Database for MariaDB
    00:13:18
  • Azure Database for PostgreSQL
    00:17:12
  • Azure Database for MySQL
    00:13:12
  • Identify the Right Data Offering for a Relational Workload
    00:06:43
  • Introduction and Learning Objectives
    00:02:51
  • Introduction to NoSQL
    00:09:23
  • SQL vs NoSQL
    00:04:21
  • 4 types of NoSQL Databases
    00:09:24
  • JSON File Structure
    00:02:45
  • NoSQL Offerings by Microsoft Azure
    00:08:23
  • Azure Storage Services Overview
    00:06:02
  • Demo Provision Azure Storage Account
    00:05:13
  • Data Redundancy Options
    00:06:01
  • Azure Blob Storage
    00:06:14
  • Azure Storage Access Tiers
    00:04:51
  • Azure Table Storage
    00:05:05
  • Azure Queue Storage
    00:02:46
  • Azure File Share Storage
    00:05:35
  • Demo Azure File Share Storage
    00:03:50
  • Azure Disk Storage and demo
    00:08:19
  • Azure Blob and Data Lake Security Options
    00:20:52
  • How Cosmos DB evolved?
    00:02:38
  • Cosmos DB Features
    00:11:24
  • Cosmos DB Multi Model 5 APIs
    00:12:20
  • Provision Cosmos DB Account
    00:10:34
  • No SQL Deployment Options
    00:02:32
  • Cosmos DB: Globally Distribution
    00:13:23
  • Cosmos DB: Multi Master
    00:02:57
  • Cosmos DB: 5 consistent level
    00:14:16
  • Cosmos DB: Security
    00:11:33
  • Demo: Insert and query data in Your cosmos DB
    00:12:41
  • Introduction and Learning Objectives
    00:02:24
  • What is Data Warehouse
    00:01:35
  • Why we need Data Warehouse
    00:02:48
  • Transaction (OLTP) vs Analytics (OLAP) workload
    00:02:26
  • Star Schema - Fact/Dimension
    00:04:58
  • Why Warehousing in Cloud
    00:02:48
  • Modern Data Warehouse Architecture
    00:14:24
  • What is Azure Synapse Analytics Service
    00:07:46
  • MPP Architecture - Synapse Analytics Service
    00:01:46
  • Different loading methods
    00:02:38
  • What is HDInsight
    00:02:57
  • Batch Processing
    00:09:14
  • Real Time Processing
    00:04:55
  • What is Data Lake
    00:03:54
  • Data Lake Gen2 Hierarchical namespace
    00:05:24
  • What is Data Factory
    00:04:39
  • Provision Azure Data Factory Instance
    00:08:02
  • Data Factory - Components
    00:07:11
  • Data Factory Components Relation
    00:01:39
  • Data Factory Triggers
    00:01:53
  • What is Azure Databricks
    00:08:58
  • Azure Data Service Architecture
    00:05:41
  • Introduction to PowerBI
    00:02:34
  • Building Blocks of Power BI
    00:07:38
  • Paginated Report
    00:02:33
  • Interactive Report
    00:03:27
  • PowerBI: Role of Dashboard
    00:02:08
  • Power BI: Workflow
    00:05:28
  • Course Introduction
    Preview 00:07:16
  • Important - Everything you need to know about exam and this course
    00:13:08
  • Before you start...
    00:01:29
  • Create Azure Free Subscription
    00:06:13
  • Azure Portal Overview
    00:14:45
  • Azure Sandbox - How to use Azure Portal for absolutely free
    00:04:49
  • Introduction and Learning Objectives
    00:02:24
  • Basic Core Data Concepts
    00:05:26
  • Data Processing Solutions (OLTP vs OLAP)
    00:05:36
  • Batch Processing Vs Stream Processing
    00:09:58
  • Chracteristics of Relational Database
    00:15:31
  • Describe the Concepts of Data Processing
    00:08:24
  • Questions: ETL vs ELT
    00:06:43
  • Data Visualization and Chart Types
    00:14:12
  • Data Analytics Techniques
    00:10:18
icon

Get Certifications

+ View more
Course overview

The course will teach you the basics of 4 types of NoSQL databases and their implementation over Azure Platform (Cosmos DB APIs, Blob and File storage, Table). In addition, you'll learn about the various forms of concepts in core data workloads. Finally, the course will also teach you about analytics workloads that involve data ingestion and processing over Azure and data warehouses.

 

The course focuses on relational and non-relational data types along with analytics workloads. The Azure Data Fundamentals Video Course begins with relational data. But you need an Azure account to install the Azure SQL Database and place your query.

 

The next focus will be on the non-relational data that uses non-structured and semi-structured data. You’ll learn about the five various Cosmos DB database interfaces and how each pertains to individual requirements. You’ll learn about File storage, Blob and Table.

 

This course will also teach you analytics workloads like HDInsight, Databricks, Synapse Analytics and Azure Data Lake. You'll also learn about Microsoft Power BI and how you'll make dashboards and basic reports. You'll also find regular quizzes to help you remember the information and keep track of your progress.     

 

Why Should You Learn DP-900: Microsoft Azure Data Fundamentals from MyAssignmenthelp.com?

 

MyAssignmenthelp.com is the best online service available where you can get the best courses. Their wallet-friendly prices are unmatched in this segment. You can also access detailed materials written by over 4500 PhD expert writers in their specialized fields. MyAssignmenthelp.com guarantees the top-quality resources to help you in your Microsoft Azure Data Fundamentals.

 

Let's look at the core features you can avail yourself –

 

(i) Guidance from experts

(ii) Easy to access videos

(iii) Best market price

(iv) Safe payment options

(v) Live doubt-solving sessions

(vi) Round-the-clock support

 

You can also access several papers without additional charges to learn about DP-900 Microsoft Azure Data Fundamentals. So what are you waiting for? Seize your opportunity now and get the best Microsoft Azure Data Fundamentals resources.

 

What is the Importance of DP-900: Microsoft Azure Data Fundamentals in Your Career?

 

The course will help you prepare for the DP-900 certificate examination. You’ll learn about analytics workloads involving ingestion and warehouses on data. You’ll also learn about the processing operations on Azure. The course will teach you to describe visual data over dashboard reports in Microsoft Power BI.

 

The course will describe the core data analytics concepts, including core data workloads and batch and streaming data. In addition, you'll learn to describe data workloads and use Azure data services that compare delivery models on IaaS, PaaS and SaaS.    

 

The course will help you understand how to work with non-relational data over Azure. You'll work with File storage, Cosmos DB APIs, Table and more. By completing this course, you will have higher chances of getting into a better career with higher salaries and pay scales.   

 

Modules of the DP-900: Microsoft Azure Data Fundamentals Course

 

Analytics workloads - The course will offer a detailed description of the analytics workloads, including the components of the modern data warehouse. It'll help you describe data visualizations using Microsoft Power BI and Azure's data ingestion and processing.

  • Data warehouses – The course will teach you the modern components in a data warehouse like cloud, multi-cloud and other hybrid solutions.
  • Data ingestion – This course will also teach you how data is sourced and imported for instant use and storage within a database.
  • Data Processing on Azure – You’ll learn about the live and real-time data processing that includes minimum latency for real-time report generation or automated responses.

 

Who is the Course for?

 

This course best suits candidates who wish to pass their Microsoft exam DP-900. Students who prefer to enter into the Azure Cloud Data-related profiles such as Data Analyst, Data Engineer or Data Science can also apply for this course. Anybody who is passionate about learning more on this course can apply for it. You can apply for this course if you want to learn more about Azure. If you’re looking for a bright career opportunity in data, you can always choose this course to move forward.  

 

What Will You Learn from the Course?

 

The DP – 900 Microsoft Azure Data Fundamentals Video Course will teach you the fundamentals of 4 types of NoSQL on databases and their implementation. You'll also learn about File storage and Blob along with Table, DB APIs and Cosmos. The course will teach you about the main workload concepts on data. You'll learn to express data visualization techniques using Microsoft Power BI, including dashboards and reports. This course will teach you how to manage Microsoft's official DP-900 examination. The course will teach you basic data analytics concepts. You'll learn to work with Azure's non-relational data like Blob and File storage, Cosmos DB APIs, and Table.

 

Know Your Instructor

 

Eshant Garg is a Danish data expert who has been in this field for the past eight years. Very few people like her have complete knowledge about using Microsoft Azure Data Fundamentals to their full potential.   Darcy loves to read new fiction books.

 

+ View more
Other related courses
07:32:29
819 0 $30 $5
16:12:52
208 0 $30 $5
11:28:15
382 0 $30 $5
06:35:25
1,157 0 $30 $5
22:25:41
5,461 0 $30 $5
About instructor

Eshant Garg | AWS Certified Cloud Practitioner | LearnCloud.Info | 100,000+ Enrollments .

19,419 Reviews | 92,883 Students | 9 Courses
I love to explain complicated things in a simple and effective way.I have 16 years of extensive professional experience with expertise in Database and Business Intelligence Solutio...

Reviews

  • RK
    Rohit K.
    27/04/2022
    Passed exam today with 986/1000 marks. All Thanks to this wonderful course and its practice tests. I am from a non-database background, still the way Eshant has curated this course, it all looked so easy to me during the exam. Also, this is the 2nd course I took after AI 900 by Eshant, and I must say, I am really grateful to Eshant for creating such awesome courses for people like me. Thank you Eshant. You Rock !!
  • SS
    Satyaprakash S.
    27/04/2022
    Took my DP900 exam today and scored 960. Thanks a lot Eshant for creating this course and explaining the fundamentals very clearly.
  • S
    Shubham
    27/04/2022
    The overall content of the course is quite good and have covered every topics, that too in details appropriate for the exam. The only thing I didn't like the lack of explanation to the wrong answers in practice sets. Yet I will recommend this course for DP-900 as it has served the main purpose, that is, quality content. Edit : I took this course and passed with 869 score. The questions in the exam matched with many of the practice sets. Previously I gave 4, but now increasing .5 for this. But I will still emphasize on providing detailed description for wrong answers.
  • SL
    Silas L.
    27/04/2022
    I wrote my exam today and obtained 920 points pass mark, this is amazing course with excellent supporting documents and exam practice papers.
  • NH
    Nu Htet W.
    27/04/2022
    Thank you so much Eshant...I passed DP900 exam today Feb 06 2022 with 934 scores. Explanation are very clear and easy to understand.
$5 $30 83.33% off
Includes:

Frequently Asked Questions

The Microsoft Azure Data Fundamentals Video Course + Qus remain valid for life. It does not expire.

The time period of the course is only around 4.5 hours.

The passing score for DP-900 is 700

The course will teach you the basics of NoSQL databases over Azure Platform, Relational databases and implementation on Azure, data workload concepts and more.

There are no prior requirements to learn this course. But, prior knowledge and experience with databases can help you learn in less time.
callback request mobile callback request mobile Chat Now