Please follow the steps to complete your e-attendance

  • Course Pre-requisite
    • Better if you have good knowledge on Azure Services (AZ-900)
  • Get your e-books
    • Go to Skillpipe
    • Create an account 
    • Redeem your License Code (Click  for Code) and get your e-copy of the DP-900 Student Book

Module 1 Explore core data concepts

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

Module 2 Explore relational data in Azure

  • Explore relational data offerings in Azure
  • Explore provisioning and deploying relational database offerings in Azure
  • Query relational data in Azure

Module 3 Explore non-relational data in Azure

  • Explore non-relational data offerings in Azure
  • Explore provisioning and deploying non-relational data services in Azure
  • Manage non-relational data stores in Azure

Module 4 Explore modern data warehouse analytics

  • Examine components of a modern data warehouse
  • Explore large-scale data analytics
  • Get started building with Power BI


  • Explore Azure Services here
  • Deep dive through Azure Fundamentals
  • Microsoft Azure Blog. Keep current on what’s happening in Azure, including what’s now in preview, generally available, news & updates, and more.
  • Azure Newsletter. Stay informed on the latest Azure features, events, and community activities. Browse through past newsletters or subscribe and get the latest Azure news delivered to your inbox.

You can find all Lab Files and Instructions here.

Instructions for starting Lab:  

Go to

First time users:

    1. Click the Register with Training Key button
    2. Input your training key in the Register with a Training Key field
    3. Click Register
    4. This opens a registration page to create a user account. Input your registration information, and then click Save
    5. Saving your user registration opens your enrollment

Returning users:

    1. Click the Sign In button
    2. Input username and password
    3. Click Sign in
    4. Logging in opens your Current Training page
    5. Click the Redeem Training Key link
    6. Input the Training Key supplied and click the Redeem Training Key button
    7. This opens your enrollment

Please launch a test lab to check for connectivity issues and read through the instructions in the lab interface to become familiar with using it. Once class starts Launch buttons will appear beside the lab modules. For assistance anytime, click the Contact link on our website or click here to go to the page now.


Topic 1: Describe core data concepts

1.1 Describing types of core data workloads

1.2 Describing data analytics core concepts

Topic 2: Describe how to work with relational data on Azure

2.1 Describe relational data workloads

  • identifying the right data offering for a relational workload (Microsoft Documentation: Azure databases)
  • describe relational data structures (e.g., tables, index, views)

2.2 Describe relational Azure data services

2.3 Identify basic management tasks for relational data

2.4 Describe query techniques for data using SQL language

Topic 3: Describe how to work with non-relational data on Azure

3.1 Describe non-relational data workloads

  • describe the characteristics of non-relational data
  • describe the types of non-relational and NoSQL data (Microsoft Documentation: Non-relational data and NoSQL)
  • recommend the correct datastore (Microsoft Documentation: Typical requirements)
  • determine when to use non-relational data

3.2 Describe non-relational data offerings on Azure

3.3 Identify basic management tasks for non-relational data

Topic 4: Describe an analytics workload on Azure

4.1 Describe analytics workloads

  • describe transactional workloads (Microsoft Documentation: Online transaction processing (OLTP))
  • describing the difference between a transactional and an analytics workload
  • describe the difference between batch and real-time (Microsoft Documentation: Real-time processing)
  • describe data warehousing workloads
  • determine when a data warehouse solution is needed

4.2 Describe the components of a modern data warehouse

4.3 Describe data ingestion and processing on Azure

4.4 Describe data visualization in Microsoft Power BI