IntermediateDBA SQL and NO-SQL project · about 12 hours

Backup, restore and performance tuning

Protect and tune the database: backups, restore drills, indexes and query plans.

The real-world brief

An online shop had a slow checkout and an untested backup.

What you will build

  • A backup schedule
  • A timed restore drill
  • Three tuned queries with before-and-after plans
  • A monitoring checklist

Skills you will practise

Backup and restoreQuery tuningMonitoringNoSQL design

Tools

MySQL or PostgreSQLMongoDBSQLDBeaver

Project tasks

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

1Back up Steps in portal
2Restore Steps in portal
3Tune Steps in portal
4Monitor 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 Backup, restore and performance tuning 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 8 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.