Model, create and load a normalised database and answer business questions with SQL.
A retail chain needs a clean database for orders, customers and products.
The detailed steps, checklists and trainer review open in the SOTT student portal for enrolled students.
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.
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.
About 12 hours of hands-on work, and it fits best after week 4 of the DBA SQL and NO-SQL course.
Enrolled students get every task with steps, "done when" checks, the submission form and a trainer review in the SOTT student portal.