SQL and Database Design
Design a transaction-safe order database for a fictional retailer.
SQL and Database Design develops practical capability through six curriculum modules combining focused lessons, guided activities and assessed deliverables. Design a transaction-safe order database for a fictional retailer. The six-week outline is an estimated learning sequence, not a confirmed cohort timetable; tutors and administrators configure actual dates separately.
Learning outcomes
- Model retailer entities.
- Answer order and inventory questions.
- Normalize an order schema.
- Implement stock allocation transactions.
- Optimize a slow reporting query.
Who it's for
Developers and analysts
Prerequisites
Basic analytical reasoning
Learning tools
PostgreSQL and SQL editor
Estimated learning time
42 hours · 6 curriculum modules
Curriculum
Final project
Design a transaction-safe order database for a fictional retailer.
Completion & certificates
- Complete each published lesson.
- Submit every practical assignment and the final project.
- Satisfy the published assessment criteria in tutor or administrator review.
- Receive administrator completion review before certificate eligibility.
Certificate eligibility requires verified completion and administrator review. No certificate has been issued for this course.
Cohorts & class dates
No cohort dates have been confirmed. The curriculum sequence is not a scheduled class timetable.