Module 1: Introduction to Full Stack Development (Week 1)
-
What is Full Stack?
-
Overview of Frontend vs Backend
-
Why PERN over MERN?
-
Setting up the development environment (Node, npm, VSCode, pgAdmin)
Module 2: PostgreSQL – Relational Database (Week 2)
-
Introduction to PostgreSQL
-
Basic SQL Queries (SELECT, INSERT, UPDATE, DELETE)
-
Table relationships, joins, indexes
-
Designing normalized schema for real apps
-
Using
pgAdminand connecting PostgreSQL with Node.js
Module 3: Node.js and Express.js – Backend API (Week 3-4)
-
What is Node.js? Async programming, modules
-
Express.js setup and folder structure
-
REST API development
-
CRUD operations
-
PostgreSQL integration using
pgorsequelize -
Environment variables, routing, and error handling
-
Middleware, JWT Authentication
Module 4: React.js – Frontend Interface (Week 5-6)
-
Setting up React app with Vite
-
React hooks, state management, routing with React Router
-
Creating reusable components
-
Form handling and validations
-
Consuming REST APIs with Axios/Fetch
-
UI/UX design with Tailwind CSS or Material UI
Module 5: Full Stack Integration (Week 7)
-
Connecting Frontend to Backend
-
JWT Auth in frontend (protected routes)
-
LocalStorage/Auth context
-
Optimizing API calls and UI updates
-
Debugging and testing full-stack apps
Module 6: Deployment & Hosting (Week 8)
-
Backend hosting (Render / Railway / DigitalOcean)
-
Frontend hosting (Vercel / Netlify)
-
PostgreSQL hosting (ElephantSQL / Supabase)
-
Environment config for production
-
GitHub repo best practices
Capstone Project:
Learning Outcomes
By the end of this course, students will be able to:
-
Develop secure, scalable full-stack applications
-
Model complex relational data using PostgreSQL
-
Implement RESTful APIs with Express.js
-
Design responsive UI using React and Tailwind
-
Host and deploy apps for real-world usage
-
Collaborate using GitHub & follow SDLC best practices
Tools & Technologies
-
PostgreSQL, pgAdmin
-
Node.js, Express.js
-
React, Vite, Tailwind CSS
-
JWT, Bcrypt
-
Git, GitHub
-
Hosting: Vercel, Render


