Microsoft / Data and analytics

Build your data foundations

Start with how data is stored and used before choosing a database or analytics specialization.

Target: DP-900Self-paced study route

Core learning · DP-900

Learn the role, one area at a time

Work through the official guide and its learning resources. Use these three study blocks to organize your notes; the official skills outline remains your complete coverage checklist.

  1. 1.Data types, workloads and data roles
  2. 2.Relational and non-relational storage
  3. 3.Analytics, ingestion and visualization concepts
Open the official DP-900 study guide ↗

Hands-on consolidation

Put it into practice

Model a small shop's orders and describe which questions need transactions, operational queries or analytics.

Ready to move on when…

You can distinguish a transactional database from an analytical workload and explain the choice.

Use a dedicated lab and synthetic data, never an employer's production environment. Check licensing and costs before provisioning; budget alerts do not stop spending. Remove resources when finished.

Review & exam planning

Find gaps with our DP-900 test

Try the test, explain each missed answer and return to the corresponding learning topic. Repeat the practical task where needed. A practice score is feedback, not proof of certification readiness.

Before booking, check the official page for current exam availability, any retirement or beta notice, and the credential's full requirements. This guide does not track completion or award a certificate.

Where these skills can lead

Choose a direction that fits your goal—not every path below.