โ† Full Stack Web Development learning path
Full Stack Web Development ยท Module 6 of 10

Databases

Store and query application data.

๐Ÿ“– Key ideas

  1. Relational (MySQL, PostgreSQL) for structured data with SQL.
  2. NoSQL (MongoDB, Firestore) for flexible documents.
  3. CRUD: Create, Read, Update, Delete.
  4. ORMs/ODMs: Prisma, Sequelize, Mongoose.
  5. Indexes speed queries; parameterised queries prevent injection.
๐Ÿ’ก Real-life example: The database is the pantry: organised shelves so the kitchen finds ingredients fast.
SQLLanguage for relational databases
NoSQLNon-relational databases
CRUDCreate, Read, Update, Delete
ORMObject-Relational Mapper