DP-900: Microsoft Azure Data Fundamentals Video Course + Practise Questions

DP-900: Microsoft Azure Data Fundamentals Video Course + Practise Questions

by Eshant Garg
Released March 2022
Publisher(s): Packt Publishing
ISBN: 9781803231778

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

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.

What You Will Learn

  • Learn all about analytics workloads and components of a modern data warehouse
  • Learn data ingestion and processing on Azure
  • Describe data visualization in Microsoft Power BI, including reports and dashboards
  • Explore relational Azure data services such as comparing PaaS, IaaS, and SaaS delivery models
  • Identify basic management tasks for relational data
  • Understand the types of core data workloads

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.

About The Author

Eshant Garg: Eshant Garg has 16 years of extensive professional experience with expertise in database and business intelligence solutions, advanced analytics, design and solution architecture, reporting, and cloud computing technologies (Azure and AWS). He loves to explain complicated things in a simple and effective way. As a developer and architect, he has worked closely with customers, users, and colleagues to support business solutions across a variety of industries including healthcare, insurance, finance, and government ranging from small companies to Fortune 500 companies.

Outside of the technical world, he loves yoga and meditation. He is a student of the ancient yogic text, the Bhagavad Gita, and loves to discuss and practice philosophical teachings.

Table of contents

  1. Chapter 1 : Introduction
    1. Course Introduction
    2. Everything You Need to Know about the Exam and Its Course
  2. Chapter 2 : Azure Portal Introduction
    1. Create Azure Free Subscription
    2. Azure Portal Overview
    3. Azure Sandbox - How to Use Azure Portal for Free
  3. Chapter 3 : Describe Core Data Concepts
    1. Introduction and Learning Objectives
    2. Basic Core Data Concepts
    3. Data Processing Solutions (OLTP Versus OLAP)
    4. Basic Processing Versus Stream Processing
    5. Characteristics of Relational Database
    6. Describe the Concepts of Data Processing
    7. Questions: ETL Versus ELT
    8. Data Visualization and Chart Types
    9. Data Analytics Techniques
  4. Chapter 4 : Describe How to Work with Relational Data on Azure
    1. Introduction and Learning Objectives
    2. Describe Relational DB structures
    3. PostgreSQL Versus MariaDB Versus MySQL
    4. Provisioning and Deployment in Azure
    5. Methods of Provisioning
    6. IaaS Versus PaaS Versus SaaS
    7. Why Choose SQL Database in Azure
    8. Azure IaaS Versus PaaS Database Offerings
    9. SQL Database PaaS Deployment Options
    10. Azure SQL Server in Virtual Machine (IaaS)
    11. Azure SQL Database Versus Data Warehouse
    12. Azure Relational Database Security Layers
    13. Demo: Azure Single SQL Server Database and Firewall Settings
    14. Identify Query Tools
    15. Introduction to SQL
    16. Demo: SQL SELECT Query
    17. Visual Studio Code
    18. Azure Database for MariaDB
    19. Azure Database for PostgreSQL
    20. Azure Database for MySQL
    21. Identify the Right Data Offering for a Relational Workload
  5. Chapter 5 : Describe How to Work with Non-Relational Data on Azure
    1. Introduction and Learning Objectives
    2. Introduction to NoSQL
    3. SQL Versus NoSQL
    4. Four Types of NoSQL Databases
    5. JSON File Structure
    6. NoSQL Offerings by Microsoft Azure
    7. Azure Storage Services Overview
    8. Demo Provision Azure Storage Account
    9. Data Redundancy Options
    10. Azure Blob Storage
    11. Azure Storage Access Tiers
    12. Azure Table Storage
    13. Azure Queue Storage
    14. Azure File Share Storage
    15. Demo Azure File Share Storage
    16. Azure Disk Storage and Demo
    17. Azure Blob and Data Lake Security Options
    18. How Cosmos DB Evolved
    19. Features of Cosmos DB
    20. Cosmos DB Multi-Model 5 APIs
    21. Provision Cosmos DB Account
    22. NoSQL Deployment Options
    23. Cosmos DB: Global Distribution
    24. Cosmos DB: Multi-Master
    25. Cosmos DB: Five Consistent Levels
    26. Cosmos DB: Security
    27. Demo: Insert and Query Data in Your cosmos DB
  6. Chapter 6 : Describe an Analytics Workload on Azure
    1. Introduction and Learning Objectives
    2. What is Data Warehouse
    3. Why We Need Data Warehouse
    4. Transaction (OLTP) Versus Analytics (OLAP) Workload
    5. Star Schema - Fact/Dimension
    6. Why Warehousing in Cloud
    7. Modern Data Warehouse Architecture
    8. What is Azure Synapse Analytics Service
    9. MPP Architecture - Synapse Analytics Service
    10. Different Loading Methods
    11. What is HDInsight
    12. Batch Processing
    13. Real Time Processing
    14. What is Data Lake
    15. Data Lake Gen2 Hierarchical Namespace
    16. What is Data Factory
    17. Provision Azure Data Factory Instance
    18. Data Factory - Components
    19. Data Factory Components Relation
    20. Data Factory Triggers
    21. What is Azure Databricks
    22. Azure Data Service Architecture
    23. Introduction to Power BI
    24. Building Blocks of Power BI
    25. Paginated Report
    26. Interactive Report
    27. Power BI: Role of Dashboard
    28. Power BI: Workflow
  7. Chapter 7 : Wrapping Up
    1. What's Next?

Product information

  • Title: DP-900: Microsoft Azure Data Fundamentals Video Course + Practise Questions
  • Author(s): Eshant Garg
  • Release date: March 2022
  • Publisher(s): Packt Publishing
  • ISBN: 9781803231778