Full Stack Architecture & MongoDB Schema Design Explained | Placement Cell Portal|OJT Week 2 Video 1
Welcome to Video 1 of 5 of our Full Stack Placement Cell Portal series — built as part of Week 2 of our On-the-Job Training program! 🚀
In this video, we cover the full stack architecture, project requirements, user roles, database schema design, MongoDB Atlas setup, and two live coding sessions — all from scratch!
🧠 What You'll Learn:
→ Full Stack Architecture — Frontend, Backend & Database layers explained
→ What the Placement Cell Portal is and what problems it solves
→ 5 modules — Student, Company, Application, Admin & Auth
→ User roles — Admin, Student, Company & Mentor and what each can do
→ REST API design — GET, POST, PUT, DELETE with consistent response formats
→ Why you must plan your database schema BEFORE writing a single line of code
→ MongoDB vs SQL — Embedding vs Referencing explained
→ 5 collection schemas — Students, Companies, Jobs, Applications & Users
→ Key relationships — One student has many applications, one company posts many jobs
→ Mongoose schema definition — required, unique, min/max, timestamps
→ Live Coding Session 1 — Project setup, folder structure & MongoDB Atlas connection
→ Live Coding Session 2 — Building all Mongoose models & verifying via MongoDB Compass
→ How to fix the VPN + MongoDB Atlas IP whitelist connection issue
💡 Key Concepts Covered:
→ What is an ODM (Object Document Mapper) and why Mongoose is used
→ Why dot env is critical — never commit secrets to source code
→ Why nodemon is installed as a dev dependency
→ How timestamps: true automatically adds createdAt and updatedAt
→ How to verify a MongoDB collection insert via MongoDB Compass
📂 Project Folder Structure:
placement-portal/
├── config/ (db.js + .env)
├── models/ (all Mongoose schemas)
├── routes/ (one file per resource)
├── middleware/ (auth logic)
└── server.js (entry point)
🎬 Full Series — OJT Week 2:
→ Video 1 — Architecture & Database Design ✅ (You are here)
→ Video 2 — REST APIs with Express & Postman Testing
→ Video 3 — Frontend Integration
→ Video 4 — Authentication & JWT
→ Video 5 — Demo & Deployment
📖 Part of the Wadia College On-the-Job Training Program
⏱️ Chapters:
00:00 Introduction
00:29 What we cover in this video?
01:22 Full-stack architecture
02:50 Project: Placement Cell Portal
04:15 Requirements & User Roles
05:09 REST API - connecting frontend & backend
06:40 Database design
08:16 Schema reference table
09:29 Collection relationships - how data links together
10:07 LIVE CODE #1
10:40 Step 1: Create project directory
11:24 Step 2: Run npm init
12:08 Step 3: npm install
13:40 Step 4: note on npm install -D (developer dependency)
14:49 Step 5: Create folders
15:44 Step 6: Create db configuration file
16:01 Step 7: Create server.js
16:37 Project folder structure
17:48 Create Student Collection
23:14 Student Activity: To create remaining collections
23:28 Logic: MongoDB connection
25:56 MongoDB Atlas setup
31:09 Logic: Server.js file
32:10 Note on express-generator (Express.js framework)
33:36 Dotenv: Loadig env vars
35:06 Fix: Database connection issue
42:37 Student Activity: LIVE CODE #2
43:38 Inserting a record in Student Collection
48:20 Common Errors & Fixes
48:25 Video Recap
🔔 Like, Share & Subscribe for more full stack development tutorials and OJT sessions!
#fullstackdevelopment #mongodb #nodejs #expressjs #MongooseODM #databasedesign #mongodbatlas #placementportal #ojt #onjobtraining #wadiacollege #webdevelopment #restapi #jwt #javascript #SchemaDesign #backenddevelopment #programming #ittraining #studentprojects #crud #github #MongoDBCompass #webdev #tech