Module 11: Databases (PostgreSQL + MongoDB)

Estimated Time: 40 hours

Status: ☐ Not Started

🎯 Objectives

• Understand the difference between relational (SQL) and non-relational (NoSQL) databases
• Write SQL queries to create, read, update, and delete data
• Learn schemas, relationships, indexing, and normalization
• Use MongoDB to store unstructured documents
• Connect your Node.js backend to a real database

🔗 Resources

1. SQLBolt

   Interactive lessons for SQL basics (schema, joins, filtering, queries)

2. MongoDB University – Introduction to MongoDB Course

   Free official course with guided videos and exercises

3. ✅ The Odin Project – Only These Lessons

   • Introduction to Databases
   • Introduction to MongoDB
   • Project: Blog API – Connect to MongoDB

✅ Projects

• [ ] PostgreSQL Practice with SQLBolt
  • Complete all interactive lessons (1–13)
  • Create a mock users and posts schema
  • Write sample queries to simulate a real blog or app
• [ ] MongoDB + Blog API
  • Replace file-based blog storage with MongoDB
  • Use mongoose to define schemas and connect to your MongoDB database
  • Deploy with a cloud DB provider (MongoDB Atlas)
• [ ] (Bonus) Add filtering, sorting, and pagination to one of your endpoints