Clientele ➞

Certification BootCamp for Exam DP-900: Microsoft Azure Data Fundamentals

DP-900

Duration: 1 Day

Description

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.

Course Outline

  • Module 1: Describe Core Data Concepts
  • Module 2: Describe How to Work with Relational Data on Azure
  • Module 3: Describe How to work with non-relational Data on Azure
  • Module 4: Describe an Analytics Workload on Azure

To know more about the course outline, click here.

Why Choose CloudThat?

At CloudThat, we offer world-class teaching experienced catered to the diverse needs of technology professionals. From personalized mentoring to self-paced learning modules, we work towards providing a growth-oriented learning experience to nurture their future.

CloudThat has trained

...Read more

Objectives

  • 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

Prerequisites

  • 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

Questions?

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

Upcoming Batches

TBA

Quick Inquiry: Microsoft Azure Courses

Loading...





Favorite Courses
No Favourites added yet.

Our Partners