HTML (HyperText Markup Language)

Introduction to HTML:

• HTML Document Structure (( , html ,head, body tags))
• Headings, Paragraphs, Line Breaks, Horizontal Lines
• Lists: Ordered, Unordered, Definition Lists
• Links: Anchor Tag, External/Internal, Email, Tel links
• Images and Image Maps
• Tables (rows, columns, rowspan, colspan)
• Forms and Input Types (text, radio, checkbox, etc.)
• Semantic HTML Tags (article, section, nav, header, footer)
• Iframes and Media Embeds (YouTube, Maps)
• HTML5 Audio and Video
• Meta Tags, Favicon, SEO basics

CSS (Cascading Style Sheets):

• What is CSS? Types (Inline, Internal, External)
• CSS Selectors (class, id, element, universal, child)
• Box Model (margin, border, padding, content)
• Styling Text, Fonts, Colors
• Positioning (static, relative, absolute, fixed, sticky)
• Display & Visibility (block, inline, inline-block, none)
• Flexbox Layout (axis, alignment, wrapping)
• Grid Layout (rows, columns, gap, area)
• Pseudo-classes and Pseudo-elements
• Media Queries (Responsive Design)
• Transitions, Transform, Animations (basics)
• Custom Properties (CSS Variables)

JavaScript (ES6+):

• Introduction & History
• Variables (var, let, const)
• Data Types and Type Conversion
• Operators (Arithmetic, Logical, Comparison)
• Conditional Statements (if, else, switch)
• Loops (for, while, do-while, for...of, for...in)
• Functions (declaration, expression, arrow)
• Arrays and Array Methods (map, filter, reduce)
• Objects and Object Methods
• DOM Manipulation (selectors, events, innerHTML, classList)
• Event Handling (click, mouse, keyboard, form)
• Form Validation (basic)
• ES6 Features: Destructuring, Spread/Rest, Template Literals
• Promises, Async/Await
• Fetch API (GET/POST)
• LocalStorage & SessionStorage
• Error Handling (try-catch, finally)
• Modular JS (import/export)

React (Latest Version):

• Introduction to React, SPA Concept
• Creating React App (CRA / Vite)
• JSX Syntax & Rules
• Components (Functional vs Class)
• Props and State
• Event Handling in React
• Conditional Rendering
• Lists and Keys
• Forms and Controlled Components
• Forms and Controlled Components
• React Hooks:
• useState
• useEffect
• useRef
• useRef
• useReducer (basic)
• Router DOM (react-router-dom):
• Routes, Link, useNavigate
• React Project Structure Best Practices
• API Integration with fetch() / axios
• Styling in React: CSS Modules, Tailwind CSS (optional)
• Custom Hooks (intro)
• Context API for State Management
• Basic Deployment (Netlify / Vercel)
• Bonus: Basic Testing (Jest / React Testing Library)

Module 1:

Introduction to Databases & MySQL

• What is a Database?
• Types of Databases (Relational vs Non-Relational)
• Introduction to MySQL
• MySQL Architecture and Installation
• MySQL Workbench and CLI Tools

Module 2:

SQL Basics:

• Database and Table Creation
• Data Types in MySQL
• CREATE, USE, SHOW, DESCRIBE Commands
• Inserting Data (INSERT INTO)
• Retrieving Data (SELECT, WHERE, ORDER BY, LIMIT)
• Updating and Deleting Records (UPDATE, DELETE)

Module 3:

Advanced Querying:

• DISTINCT, IN, BETWEEN, LIKE, IS NULL
• Aggregate Functions (COUNT, SUM, AVG, MIN, MAX)
• Grouping Data (GROUP BY, HAVING)
• Sorting Data (ORDER BY, ASC, DESC)
• Aliases (AS)

Module 4:

Joins and Subqueries:

• Joins and Subqueries
• INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
• Self Joins
• Nested Queries / Subqueries
• EXISTS, ANY, ALL usage

Module 5:

Table Management:

• Modifying Table Structure (ALTER TABLE)
• Adding, Dropping, and Modifying Columns
• Data Constraints: PRIMARY KEY, UNIQUE, NOT NULL, DEFAULT
• Foreign Key Constraints (REFERENCES, ON DELETE, ON UPDATE)
• Dropping and Renaming Tables

Module 6:

Data Integrity and Constraints:

• Referential Integrity
• Domain Integrity
• Entity Integrity
• Auto-Increment
• ENUM and SET

Module 7:

Views, Indexes, and Stored Procedures:

• Creating and Using Views
• Indexing for Performance (CREATE INDEX, DROP INDEX)

Module 1: Core Python Programming (3–4 Weeks)

Python Basics:

• What is Python? Applications and Use Cases
• Variables, Data Types
• Operators and Expressions
• Input/Output, Type Casting

Control Flow:

• if, elif, else
• Loops: for, while
• Loop Control: break, continue, pass

Functions:

• Defining Functions
• Arguments & Return Values
• Lambda Functions
• Recursion

Data Structures:

• Lists, Tuples, Sets, Dictionaries
• List/Dict Comprehensions
• map(), filter(), zip(), enumerate()

String Handling:

• String Methods
• String Slicing, Formatting

Modules & File Handling:

• Import, Custom Modules
• Working with Files (Text, CSV, JSON)

Exception Handling:

• try/except/finally
• raise, Custom Exceptions

Object-Oriented Programming:

• Classes & Objects
• Constructors, self
• Inheritance, Method Overriding
• Encapsulation, Polymorphism

Module 2: FastAPI - Modern Python Web Framework (4-5 Weeks)

FastAPI Introduction:

• What is FastAPI and Why?
• FastAPI vs Flask vs Django
• Install FastAPI + Uvicorn

FastAPI Basics:

• Creating your first API
• Path Parameters & Query Parameters
• Request and Response Models
• Pydantic: Data Validation & Type Hints

CRUD with FastAPI:

• HTTP Methods: GET, POST, PUT, DELETE
• In-Memory Storage (initially)
• JSON Response Handling
• Status Codes and Response Models

Request Body & Validation:

• Handling JSON Requests
• Pydantic Models with Validation
• Optional & Default Values

Response Handling:

• Custom Response Codes
• Custom Error Handling
• Return JSONResponse, RedirectResponse

Path & Query Parameters:

• Optional Parameters
• Validating & Using Parameters

Exception Handling:

• try/except/finally
• raise, Custom Exceptions

Object-Oriented Programming:

• Classes & Objects
• Constructors, self
• Inheritance, Method Overriding
• Encapsulation, Polymorphism

Module 3: Database Integration (1.5-2 Weeks)

Using SQLite / PostgreSQL / MySQL:

• SQLAlchemy ORM Basics
• Connecting DB with FastAPI
• Defining Models and Tables
• CRUD Operations via ORM
• Alembic for Migrations (Intro)

Module 4: Testing, Docs & Deployment (1 Week)

Automatic API Docs:

• Swagger UI (/docs)
• ReDoc UI (/redoc)
• How FastAPI Auto-generates Docs

API Testing with Postman:

• Sending GET/POST Requests
• Testing Auth, Headers, Status Codes

Unit Testing (Intro):

• Using pytest for basic API tests

Deploying FastAPI App:

• Using Uvicorn/Gunicorn
• Deploy on: PythonAnywhere, Railway / Render, Docker + AWS EC2

Module 1: Core Java (Java SE) Duration: 3–4 Weeks

Java Basics:

• JDK, JRE, and JVM
• Data Types, Variables, Operators
• Type Casting
• Control Flow: if, switch, for, while, do-while
• Method Basics and Parameter Passing

Object-Oriented Programming in JavaClass and Object:

• Constructor, this and super keyword
• Inheritance
• Method Overloading and Overriding
• Abstraction: Abstract Class & Interface
• Encapsulation and Access Modifiers
• Polymorphism: Compile-Time & Runtime

Exception Handling:

• try, catch, finally, throw, throws
• Custom Exceptions

Java Strings:

• String vs StringBuilder vs StringBuffer
• Common String Methods
• String Immutability

Collections Framework:

• List: ArrayList, LinkedList
• Set: HashSet, LinkedHashSet, TreeSet
• Map: HashMap, LinkedHashMap, TreeMap
• Iterators, for-each, Stream API basics
• Comparable vs Comparator

Multithreading & Concurrency:

• Thread Creation: Thread class & Runnable
• Thread Lifecycle & Methods
• Synchronization, wait() / notify()
• ExecutorService (Intro)

File I/O and Serialization:

• FileReader / FileWriter
• BufferedReader / BufferedWriter
• Object Serialization

Lambda Expressions & Functional Interfaces:

• Introduction to Functional Programming in Java
• Built-in Functional Interfaces: Predicate, Function, Consumer, Supplier
• Stream API (filter, map, reduce, collect)

Module 2: Spring Framework (Spring Core + Boot) (6–8 Weeks)

Spring Core:

• Introduction to Spring & Dependency Injection
• Spring Container and Bean Lifecycle
• Types of Dependency Injection (Constructor, Setter)
• Bean Scopes, Autowiring
• Java-based and Annotation-based Configuration

Spring AOP (Aspect-Oriented Programming):

• Concepts: Aspect, Advice, Pointcut, JoinPoint
• Using @AspectJ for Logging, Transactions

Spring Boot:

• Spring Boot Overview & Benefits
• Creating a Project using Spring Initializr
• @SpringBootApplication, Auto Configuration
• Properties and YAML Configuration
• DevTools & Hot Reload

Spring MVC with REST APIs:

• @RestController, @RequestMapping, @GetMapping, etc.
• @PathVariable, @RequestParam, @RequestBody
• ResponseEntity & Status Codes
• Exception Handling: Custom + Global

Spring Data JPA:

• Entity Class and Repository Interfaces
• CrudRepository, JpaRepository
• Custom Finder Methods and JPQL
• Pagination and Sorting
• Entity Relationships: OneToOne, OneToMany, ManyToOne

Validation:

• Hibernate Validator (JSR 380)
• @Valid, @NotNull, @Size, etc.
• Custom Validation Errors

Connecting Spring Boot to Database:

• MySQL or PostgreSQL Configuration
• Spring Boot + H2 (in-memory DB for testing)
• Connection Pooling with HikariCP