IntermediateMicrosoft Azure Data Fundamentals project · about 6 hours

Relational and non-relational data on Azure

Create an Azure SQL database and a Cosmos DB container and compare them.

The real-world brief

A startup is choosing where to store orders and product reviews.

What you will build

  • A SQL table of orders
  • A Cosmos DB container of reviews
  • Sample queries in both
  • A comparison note

Skills you will practise

Relational dataNon-relational dataQueryingChoosing a store

Tools

Azure SQL DatabaseAzure Cosmos DBAzure portal

Project tasks

The detailed steps, checklists and trainer review open in the SOTT student portal for enrolled students.

1SQL Steps in portal
2NoSQL Steps in portal
3Compare Steps in portal
4Clean up Steps in portal

How companies use Microsoft Azure Data Fundamentals

Retail: One view of sales. Sales, stock and online data sat in separate systems. Pipelines load all sources into one warehouse with cleaned, modelled tables. Everyone uses the same numbers.

Logistics: Live delivery tracking. Delivery status updated once a day. Streaming events land in the data platform within seconds and feed dashboards. Customer service sees each parcel in real time.

Healthcare: Governed patient data. Analysts copied sensitive data into spreadsheets. Access controls, masking and lineage in a governed platform. Analysts get the data they need without uncontrolled copies.

Questions

Can I add the Relational and non-relational data on Azure project to my resume?

Yes. Once your trainer approves it, list it under Projects with the tools you used, one line on the problem it solves and a link to your repository and demo video.

How long does this project take?

About 6 hours of hands-on work, and it fits best after week 4 of the Microsoft Azure Data Fundamentals course.

Where do I get the step-by-step tasks?

Enrolled students get every task with steps, "done when" checks, the submission form and a trainer review in the SOTT student portal.