Gain a solid understanding of relational data workloads and relational Azure data services such as comparing PaaS, IaaS, and SaaS models by taking up this certification course
About This Video
Gain a solid understanding of relational data workloads and relational Azure data services such as comparing PaaS, IaaS, and SaaS models by taking up this certification course
About This Video
In Detail
DP-900 course is a fundamental course of Azure Data. The best part of this course is that there is no expiry to this course and doesn’t need recertification. You will identify basic management tasks for relational data including provisioning and deployment of relational data services and describing query techniques for data using SQL language.
Another significant factor that all candidates should consider for the successful training of the DP-900 exam is the overview of the exam skills. Applicants with a better understanding of the exam topics and weighting of the exam domains can gain a general impression of the exam prior to their preparation.
The domains include core data concepts; different approaches to work with relational data on Azure; approaches to work with non-relational data on Azure; and the description of an Azure analytics workload. You will also learn how to describe relational data workloads and relational Azure data services such as comparing PaaS, IaaS, and SaaS delivery models. Finally, you will learn data ingestion and processing on Azure and data visualization in Microsoft Power BI.
By the end of this course, you will be able to crack the DP – 900 certification exams.
Audience
This course is for those who want to pass the Microsoft exam DP-900 and for those who want to enter Azure Cloud data-related profiles such as data engineer, data scientist, and data analyst.
Chapter 1 : Introduction
Course Introduction
Everything You Need to Know about the Exam and Its Course
Chapter 2 : Azure Portal Introduction
Create Azure Free Subscription
Azure Portal Overview
Azure Sandbox - How to Use Azure Portal for Free
Chapter 3 : Describe Core Data Concepts
Introduction and Learning Objectives
Basic Core Data Concepts
Data Processing Solutions (OLTP Versus OLAP)
Basic Processing Versus Stream Processing
Characteristics of Relational Database
Describe the Concepts of Data Processing
Questions: ETL Versus ELT
Data Visualization and Chart Types
Data Analytics Techniques
Chapter 4 : Describe How to Work with Relational Data on Azure
Introduction and Learning Objectives
Describe Relational DB structures
PostgreSQL Versus MariaDB Versus MySQL
Provisioning and Deployment in Azure
Methods of Provisioning
IaaS Versus PaaS Versus SaaS
Why Choose SQL Database in Azure
Azure IaaS Versus PaaS Database Offerings
SQL Database PaaS Deployment Options
Azure SQL Server in Virtual Machine (IaaS)
Azure SQL Database Versus Data Warehouse
Azure Relational Database Security Layers
Demo: Azure Single SQL Server Database and Firewall Settings
Identify Query Tools
Introduction to SQL
Demo: SQL SELECT Query
Visual Studio Code
Azure Database for MariaDB
Azure Database for PostgreSQL
Azure Database for MySQL
Identify the Right Data Offering for a Relational Workload
Chapter 5 : Describe How to Work with Non-Relational Data on Azure
Introduction and Learning Objectives
Introduction to NoSQL
SQL Versus NoSQL
Four Types of NoSQL Databases
JSON File Structure
NoSQL Offerings by Microsoft Azure
Azure Storage Services Overview
Demo Provision Azure Storage Account
Data Redundancy Options
Azure Blob Storage
Azure Storage Access Tiers
Azure Table Storage
Azure Queue Storage
Azure File Share Storage
Demo Azure File Share Storage
Azure Disk Storage and Demo
Azure Blob and Data Lake Security Options
How Cosmos DB Evolved
Features of Cosmos DB
Cosmos DB Multi-Model 5 APIs
Provision Cosmos DB Account
NoSQL Deployment Options
Cosmos DB: Global Distribution
Cosmos DB: Multi-Master
Cosmos DB: Five Consistent Levels
Cosmos DB: Security
Demo: Insert and Query Data in Your cosmos DB
Chapter 6 : Describe an Analytics Workload on Azure
Introduction and Learning Objectives
What is Data Warehouse
Why We Need Data Warehouse
Transaction (OLTP) Versus Analytics (OLAP) Workload
Star Schema - Fact/Dimension
Why Warehousing in Cloud
Modern Data Warehouse Architecture
What is Azure Synapse Analytics Service
MPP Architecture - Synapse Analytics Service
Different Loading Methods
What is HDInsight
Batch Processing
Real Time Processing
What is Data Lake
Data Lake Gen2 Hierarchical Namespace
What is Data Factory
Provision Azure Data Factory Instance
Data Factory - Components
Data Factory Components Relation
Data Factory Triggers
What is Azure Databricks
Azure Data Service Architecture
Introduction to Power BI
Building Blocks of Power BI
Paginated Report
Interactive Report
Power BI: Role of Dashboard
Power BI: Workflow
Chapter 7 : Wrapping Up
What’s Next?