Advanced Diploma in Full Stack Java Development with MERN

Durations – 240/300Hrs

Modules

Database

Front-End Application Development

Front-End Application Development

RDBMS(MySql) – 4 days
Introduction to RDBMS	DBMS VS RDBMS	ACID Properties
MySQL Features	MySQL Data Types	MySQL Variables
MySQL Database	Tables	Views
MySQL Queries	Indexes (Cluster and Non-Cluster)	Clauses
Control Flow Functions	MySQL Condition	Joins
Key Constraint	Triggers	Aggregate Functions
Procedures	Functions	Sub Queries

Core Java (Java SE 9) — 7 days
Introduction to Core Java	Features of Java	C++ VS Java
Hello Program and Structure	Environment Setup	JDK, JRE and JVM
Variables	Data Types	Operators
Control Statements	Oops and Object class	Arrays
Static, this, super keyword	Inheritance	Abstraction and Encapsulation
Polymorphism	String	StringBuffer and StringBuilder
Exception Handling	Multi-Threading	Java Inner Class
Collection	Lambda	Java I/O
JDBC — 4 days
Introduction to JDBC	JDBC Driver	Driver Manager
Connectivity with MySql	Connection	Statement
ResultSet	Prepared Statement	ResultSet MetaData
Callable Statement	Transaction Management
MongoDB — 4 Days
Mongo DB: Introduction To MongoDB, Advantages over RDBMS, MongoDB Data Types	Install MongoDB MongoDB Data Modeling	MongoDB Operators
Query & Projection Operator	MongoDB Update Operator	Aggregation Pipeline Stages
MongoDB limit ()	MongoDB sort ()	Database, Create Database, Drop Database
Collection, Create Collection, Drop Collection	CRUD: Documents	Query Documents SQL to MongoDB Mapping MongoDB text search
React JS - 7 Days
React Fundamentals + JSX + Components	What is React? Why React? SPA concept Setting up React with create-react-app or Vite	Folder structure walkthrough State and useState hook, Event handling (onClick, onChange), Conditional rendering (if, ternary, &&) Hands-on:

Lists, Forms, and Two-Way Binding	Rendering lists with .map() Keys in React Controlled components: input, textarea, select Form handling basics	Lifting state up Simple validation techniques
useEffect + API Integration + Component Communication	useEffect: Basic to advanced usage Lifecycle analogy in functional components Fetching data with fetch / axios Managing loading and error state	Component communication (Parent-Child) Props drilling vs context (brief int)
Node JS - 4 Days
Introduction To Node JS Why use Node JS What Can Node.js Do?	Install Node JS, Classes and Objects Global Objects Functions in Node	Node JS Modules, File System
Core Modules in Node JS, Node JS NPM	Events in Node JS, Event Emitter Object in Node JS	Node JS Upload files Node JS Email
Express JS - 4 days
Introduction to Express.JS Why use Express JS How does Express look like	Install Express JS, Postman Tool	Http Methods, Post, Get, Put and Delete
Routing, Router, Dynamic Routes, Wild card Routes	URL Building, Middleware, Express Generator	Static Files, Templating, Form Data
Final Project + State Management + Deployment