*Friday CLOSED

Timings 10.00 am - 08.00 pm

Call : 021-3455-6664, 0312-216-9325 DHA 021-35344-600, 03333808376, ISB 03333808376

DP-900 – Microsoft Azure Data Fundamentals

Be the first to rate DP-900 – Microsoft Azure Data Fundamentals
Or log in to access your purchased courses
by fatima
Price: 80,000
2 Months
0 Lessons

DP-900 - Microsoft Azure Data Fundamentals

DP-900 – Microsoft Azure Data Fundamentals

DP-900: Microsoft Azure Data Fundamentals is a course designed to help learners become proficient in working with and managing data in the Azure cloud platform. The course provides a thorough exploration of how data management works in the Azure environment, and how users can create and utilize resources in Azure to optimize their data management operations. Through the course, learners will gain an understanding of how to effectively manage and analyze data using Azure, as well as best practices for using data resources in Azure.

What you’ll 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

Course Content:

Module1: Azure Portal Introduction

  • Create Azure Free Subscription
  • Azure Portal Overview
  • IaaS vs PaaS vs SaaS
  • Azure Sandbox – How to use Azure Portal for absolutely free
  • How to get FREE credits for Azure Portal

Module2: Describe Core Data Concepts

  • Explore core data concepts
  • Explore roles and responsibilities in the world of data
  • Describe concepts of relational data
  • Explore concepts of non-relational data
  • Explore concepts of data analytics

Module 3: How to work with rational data on Azure

  •  Relational Database
  • Describe Relational DB structure
  • Provisioning and Deployment in Azure
  • Methods of Provisioning
  • Why choosing SQL Database in Azure
  • Azure IaaS vs PaaS database offerings
  • SQL Database PaaS Deployment Options
  • Azure SQL Server in Virtual Machine (IaaS)
  • Azure SQL Database vs Data Warehouse
  • Azure Single SQL Server Database and Firewall Settings
  • Open Source DB: PostgreSQL, MariaDB and MySQL
  • Identify Query Tools
  • Introduction to SQL
  • Demo: SQL SELECT Query
  • Identify the right data offering for a relational workload

Module 4: How to work with  non rational data on Azure

  • Introduction and Learning Objectives
  • Introduction to NoSQL
  • SQL vs NoSQL
  • 4 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 File Share Storage
  • Demo Azure File Share Storage
  • How Cosmos DB evolved?
  • Cosmos DB Features
  • Cosmos DB Multi Model 5 APIs
  • Provision Cosmos DB Account
  • Cosmos DB: Globally Distribution

Module5:  Explore analytics workload on Azure

  • Introduction and Learning Objectives
  • What is Data Warehouse
  • Why we need Data Warehouse
  • Star Schema – Fact/Dimension
  • Why Warehousing in Cloud
  • Modern Data Warehouse Architecture
  • What is Azure Synapse Analytics Service
  • What is HDInsight
  • Batch Processing
  • Real Time Processing
  • Azure Stream Analytics
  • Batch Processing vs Stream Processing
  • What is Data Lake
  • Data Lake Gen2 Hierarchical namespace
  • What is Data Factory
  • Provision Azure Data Factory Instance08:02
  • Data Factory – Components
  • Data Factory Components Relation
  • Data Factory Triggers
  • What is Azure Data bricks
  • Azure Data Service Architecture
  • Introduction to PowerBI
  • Building Blocks of Power BI
  • PowerBI: Role of Dashboard
  • Power BI: Workflow
  • Data Visualization and Chart Types
  • Further Study Material

Who this course is for:
  • Those who want to pass the Microsoft exam DP-900
  • Those who want to enter in to Azure Cloud Data related profiles like Data Engineer, Data Scientist, Data Analyst etc

Course Prerequisite

  • This is basic course and so no prerequisite is required
  • However previous database knowledge or experience would help student to understand course quickly

Free Exam Practice Test: 

 Microsoft DP-900 Microsoft Azure Data Fundamentals

International Student Fee  500 USD

Flexible Class Options

  • Week End Classes For Professionals  SAT | SUN
  • Corporate Group Trainings Available
  • Online Classes – Live Virtual Class (L.V.C), Online Training

Related Courses

Microsoft Azure Training

Microsoft Azure Fundamentals – AZ-900 Exam Preparation

Microsoft Azure Developer Associate – AZ-204 Exam

Designing a Microsoft Azure Architecture – AZ-304 Exam

AWS Developer Training Course

DP-100 – Designing and Implementing a Data Science Solution on Azure


Flexible Classes Schedule

Online Classes for out of city / country students

Unlimited Learning - FREE Workshops

FREE Practice Exam

Internships Available

Free Course Recordings Videos

Register Now


Or log in to access your purchased courses

OMNI ACADEMY & CONSULTING is one of the most prestigious Training & Consulting firm, founded in 2010, under MHSG Consulting Group aim to help our customers in transforming their people and business - be more engage with customers through digital transformation. Helping People to Get Valuable Skills and Get Jobs.

Read More

Contact Us

Get your self enrolled for unlimited learning 1000+ Courses, Corporate Group Training, Instructor led Class-Room and ONLINE learning options. Join Now!
  • Head Office: A-2/3 Westland Trade Centre, Shahra-e-Faisal PECHS Karachi 75350 Pakistan Call 0213-455-6664 WhatsApp 0334-318-2845, 0336-7222-191, +92 312 2169325
  • Gulshan Branch: A-242, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, Karachi-75300, Call/WhatsApp 0213-498-6664, 0331-3929-217, 0334-1757-521, 0312-2169325
  • ONLINE INQUIRY: Call/WhatsApp +92 312 2169325, 0334-318-2845, Lahore 0333-3808376, Islamabad 0331-3929217, Saudi Arabia 050 2283468
  • DHA Branch: 14-C, Saher Commercial Area, Phase VII, Defence Housing Authority, Karachi-75500 Pakistan. 0213-5344600, 0337-7222-191, 0333-3808-376
  • info@omni-academy.com
  • FREE Support | WhatsApp/Chat/Call : +92 312 2169325

  • Monday10.00am - 7.00pm
  • Tuesday10.00am - 7.00pm
  • Wednesday10.00am - 7.00pm
  • Thursday10.00am - 7.00pm
  • FridayClosed
  • Saturday10.00am - 7.00pm
  • Sunday10.00am - 7.00pm
WhatsApp Us