Module 05: Databases

Learning Outcomes

• Schema modeling
• Indexed query design
• Migration and seeding discipline

Execution Tasks

• Model ecommerce-like data
• Implement search/filter with indexes
• Write migration and seed scripts

Expected Deliverable

Database-backed app with efficient queries

Quality Verification

• Feature works in happy and failure paths
• Setup steps are reproducible on clean machine
• README explains design decisions briefly

Common Mistakes

• Skipping edge-case testing
• No documentation of assumptions
• Pushing unfinished code without cleanup

Curated References

• https://www.postgresql.org/docs/
• https://www.mongodb.com/docs/
• https://use-the-index-luke.com/