IntermediateDBA SQL and NO-SQL project · about 12 hours

Design and build a sales database on MySQL and MongoDB

Model, create and load a normalised database and answer business questions with SQL.

The real-world brief

A retail chain needs a clean database for orders, customers and products.

What you will build

  • An ER diagram
  • Tables with keys and constraints
  • Sample data loaded
  • Ten business queries

Skills you will practise

Data modellingSQLConstraintsIndexing

Tools

MySQL or PostgreSQLMongoDBSQLDBeaver

Project tasks

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

1Model Steps in portal
2Create Steps in portal
3Load Steps in portal
4Query Steps in portal

How companies use DBA SQL and NO-SQL

E-commerce: Checkout that stays fast at sale time. Slow queries made checkout time out during sales. Indexes, query tuning and read replicas for reports. Checkout stayed fast through the biggest sale.

Banking: No data lost in an outage. Nobody had tested restoring the core database. Automated backups, point-in-time restore and regular restore drills. A restore drill met the agreed recovery time.

SaaS: Secure customer data. Every developer could read production data. Least-privilege roles, encryption, masking and auditing. Access is limited and audited.

Questions

Can I add the Design and build a sales database on MySQL and MongoDB 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 12 hours of hands-on work, and it fits best after week 4 of the DBA SQL and NO-SQL 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.