Clientele ➞

Microsoft Azure Certification BootCamp for DP-900 (Microsoft Azure Data Fundamentals)


Duration: 1 Day


DP-900 BootCamp course from CloudThat is designed to help candidates pass the Microsoft DP-900 certification exam. This exam is intended to help candidates beginning to work with data in the Cloud.

Azure Data Fundamentals 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.

Why should you get DP-900 certification?

  • By earning DP-900 certification, you will show your future or current employer that you have knowledge of database concepts in a Cloud environment and is capable of building cloud data solutions with Microsoft Azure.
  • With this certification, you will be trained in various methods and best practices in Cloud data services.
  • This course will help in unleashing the growing market opportunities waiting for Microsoft certified expert in Azure Data Fundamentals.

Why Microsoft Azure is the best certification?

The job market and opportunities for

...Read more


  • To understand and build AI solutions on Azure
  • To learn about various Azure Machine Learning services usage & integration
  • To understand the profound impacts Machine Learning is making in smart business decisions

Who Should Attend

  • Azure Database Administrator
  • Azure Data Engineer


  • Should have knowledge on concepts of relational and non-relational data
  • Should have knowledge on different types of data workloads such as transactional or analytical

Course Outline

Module 1: Describe Core Data Concepts

  • Describe Types of Core Data Workloads
    • Describe Batch Data
    • Describe Streaming Data
    • Describe the Difference between Batch and Streaming Data
    • Describe the Characteristics of Relational Data
  • Describe Data Analytics Core Concepts
    • Describe Data Visualization (e.g., Visualization, Reporting, Business Intelligence
    • Describe Basic Chart Types such as Bar Charts and Pie Charts
    • Describe Analytics Techniques (e.g., Descriptive, Diagnostic, Predictive, Prescriptive, Cognitive)
    • Describe ELT and ETL Processing
    • Describe the Concepts of Data Processing

Module 2: Describe How to Work with Relational Data on Azure

  • Describe Relational Data Workloads
    • Identify the right Data Offering for a Relational Workload
    • Describe Relational Data Structures (e.g., tables, index, views)
  • Describe Relational Azure Data Services
    • Describe and compare PaaS, IaaS, and SaaS Delivery Models
    • Describe Azure SQL Database
    • Describe Azure Synapse Analytics
    • Describe SQL Server on Azure Virtual Machine
    • Describe Azure Database for PostgreSQL, Azure Database for MariaDB, and Azure
  • Database for MySQL
    • Describe Azure SQL Managed Instance
  • Identify Basic Management Tasks for Relational Data
    • Describe Provisioning and Deployment of Relational Data Services
    • Describe Method for Deployment Including ARM Templates and Azure Portal
    • Identify Data Security Components (e.g., Firewall, Authentication)
    • Identify Basic Connectivity Issues (e.g., Accessing from On-premises, Access with Azure
  • VNets, Access from Internet, Authentication, Firewalls)
    • Identify Query Tools (e.g., Azure Data Studio, SQL Server Management Studio, sqlcmd Utility, etc.)
  • Describe Query Techniques for Data using SQL Language
    • Compare DDL Versus DML
    • query relational Data in PostgreSQL, MySQL, and Azure SQL Database

Module 3: Describe How to work with non-relational Data on Azure

  • Describe Non-Relational Data Workloads
    • Describe the Characteristics of Non-Relational Data
    • Describe the Types of Non-Relational and NoSQL Data
    • Recommend the Correct Data Store
    • Determine When to use Non-Relational Data
  • Describe non-relational Data Offerings on Azure
    • Identify Azure Data Services for Non-Relational Workloads
    • Describe Azure Cosmos DB APIs
    • Describe Azure Table Storage
    • Describe Azure Blob Storage
    • Describe Azure File Storage
  • Identify Basic Management Tasks for Non-Relational Data
    • Describe Provisioning and Deployment of Non-Relational Data Services
    • Describe Method for Deployment Including ARM Templates and Azure Portal
    • Identify Data security components (e.g., Firewall, Authentication)
    • Identify Basic Connectivity Issues (e.g., Accessing from On-Premises, Access with Azure VNets, Access from Internet, Authentication, Firewalls)
    • Identify Management Tools for Non-Relational Data

Module 4: Describe an Analytics Workload on Azure

  • Describe Analytics Workloads
    • Describe Transactional Workloads
    • Describe the Difference Between a Transactional and an Analytics Workload
    • Describe the Difference between Batch and Real Time
    • Describe Data Warehousing Workloads
    • Determine when a Data Warehouse Solution is Needed
  • Describe the components of a Modern Data Warehouse
    • Describe Azure Data Services for Modern Data Warehousing such as Azure Data Lake, Azure Synapse Analytics, Azure Databricks, and Azure HDInsight
    • Describe Modern Data Warehousing Architecture and Workload
  • Describe Data Ingestion and Processing on Azure
    • Describe Common Practices for Data Loading
    • Describe the Components of Azure Data Factory (e.g., Pipeline, Activities, etc.)
    • Describe Data Processing Options (e.g., HDI, Azure Databricks, Azure Synapse Analytics, Azure Data Factory)
  • Describe Data Visualization in Microsoft Power BI
    • Describe the Role of paginated Reporting
    • Describe the Role of Interactive Reports
    • Describe the Role of Dashboards
    • Describe the Workflow in Power BI

About the Trainer

A Certified Microsoft Azure Trainer

Other Details


For latest batch dates, fees, location and general inquiries, contact our sales team at: +91 8880002200 or email at

Upcoming Batches


Quick Inquiry: Microsoft Azure Courses

Favorite Courses
No Favourites added yet.

Our Partners