Microsoft DP-900 Training Course

In the exam preparation course, students can understand the fundamental application and analysis of cloud data. They will know the differences and applications of relational data and non-relational data. Students can obtain the globally recognized Microsoft DP-900 Certificate exam upon course completion. *All courses must be completed within one year 

From this course, you will learn…

This course is suitable for…

Remarks:

Course Content

Introduce data and how it is related to daily life

  • Learn the definition of data and analytical system
  • Describe transactional workloads (ACID)
  • Understand batch and streaming data

Learn the job roles in the world of data, including:

  • Job duties of these roles
  • Tools that they help with their tasks

Understand concepts of relational data

  • Understand the characteristics of relational data and SQL (Explore relational database use cases?)
  • Experience the use of SQL (Hands-on)
  • Compare on-premises hosting to the cloud
  • Understand IaaS and PaaS

Understand concepts of non-relational data

  • Understand the characteristics of non-relational data (Explore relational database use cases?)
  • Learn the types of non-relational data and unstructured data
  • Describe types of non-relational and NoSQL databases

Describe data ingestion and processing

  • Understand what is data processing and types of data processing (ETL/ELT)
  • Explore data visualisation
  • Explore data analytics

Explore relational Azure data services

  • SQL Server on Azure virtual machines
  • Introduce Azure SQL Database and its managed instance
  • Azure data service and provisioning for other SQL databases
  • SQL and Azure SQL Database tutorial

Explore non-relational Azure data services

  • Explore Azure Table, Blob, File storage
  • Experience the Azure Cosmos DB
  • Azure data service and provisioning for non-relational databases
  • Query Azure Cosmos DB

Explore modern data warehouse analytics

  • Examine components of modern data warehouse
  • Learn data loading and ingestion
  • Explore data storage and processing in Azure
  • Get started building with Power BI

  • 60mins – Mock Exam
  • 60mins – Explanation

Introduce data and how it is related to daily life

  • Learn the definition of data and analytical system
  • Describe transactional workloads (ACID)
  • Understand batch and streaming data

Learn the job roles in the world of data, including:

  • Job duties of these roles
  • Tools that they help with their tasks

Understand concepts of relational data

  • Understand the characteristics of relational data and SQL (Explore relational database use cases?)
  • Experience the use of SQL (Hands-on)
  • Compare on-premises hosting to the cloud
  • Understand IaaS and PaaS

Understand concepts of non-relational data

  • Understand the characteristics of non-relational data (Explore relational database use cases?)
  • Learn the types of non-relational data and unstructured data
  • Describe types of non-relational and NoSQL databases

Describe data ingestion and processing

  • Understand what is data processing and types of data processing (ETL/ELT)
  • Explore data visualisation
  • Explore data analytics

Explore relational Azure data services

  • SQL Server on Azure virtual machines
  • Introduce Azure SQL Database and its managed instance
  • Azure data service and provisioning for other SQL databases
  • SQL and Azure SQL Database tutorial

Explore non-relational Azure data services

  • Explore Azure Table, Blob, File storage
  • Experience the Azure Cosmos DB
  • Azure data service and provisioning for non-relational databases
  • Query Azure Cosmos DB

Explore modern data warehouse analytics

  • Examine components of modern data warehouse
  • Learn data loading and ingestion
  • Explore data storage and processing in Azure
  • Get started building with Power BI

  • 60mins – Mock Exam
  • 60mins – Explanation

Feedback

no feedback

FAQ

Students need to login both Microsoft Teams and Una Platform for learning and coding, but it is unnecessary to use the same device.

  1. Microsoft Teams: Please download Microsoft Teams here and find out the detail of device requirements.
  2. Una Platform: Student can login Una with an internet-accessible computer, laptop or iPad, using Google Chrome or Microsoft Edge up-to-date browsers.

Important Notes for Login Una:

  1. Smartphone is not supported
  2. For iPad users, it requires iPadOS 14.5 or above
  3. Login with computer or laptop, using normal mode on the browser (NOT Incognito Mode), can enjoy a better user experience
  1. When we receive your registration, we will send you Una Platform login instruction.
  2. Once you receive login instruction, before the class, please visit https://app.una.study/ and see if you can login Una successfully. Otherwise, please change your device or update your browser prior class to ensure we can start the lesson on time and smoothly.

Microsoft DP-900 Training Course

HKD 6,615 (USD 870)