🔰 SQL Fundamentals

What is SQL & where it is used

Databases vs DBMS

Relational databases overview

SQL syntax & conventions

🏗 Database Basics

Tables, rows, columns

Primary key & foreign key

Data types (INT, VARCHAR, DATE, etc.)

Creating databases & tables

📝 Data Definition Language (DDL)

CREATE

ALTER

DROP

TRUNCATE

Constraints (NOT NULL, UNIQUE, CHECK, DEFAULT)

✏️ Data Manipulation Language (DML)

INSERT

UPDATE

DELETE

SELECT basics

WHERE clause

🔍 Data Querying & Filtering

SELECT with conditions

AND / OR / NOT

BETWEEN

IN

LIKE

IS NULL

📐 Sorting & Limiting Data

ORDER BY

LIMIT / OFFSET

DISTINCT

🔗 SQL Joins (Very Important)

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL JOIN

Self Join

Join multiple tables

📊 Aggregate Functions

COUNT

SUM

AVG

MIN / MAX

GROUP BY

HAVING

🧠 Subqueries & Nested Queries

Subqueries in SELECT

Subqueries in WHERE

Correlated subqueries

🧾 Views & Indexes

Creating & using views

Indexes & performance basics

When to use indexes

🔐 Constraints & Keys

Primary key

Foreign key

Unique constraints

Referential integrity

🔄 Transactions

COMMIT

ROLLBACK

SAVEPOINT

ACID properties

⚙️ Advanced SQL Concepts

CASE statements

COALESCE & NULL handling

Window functions (ROW_NUMBER, RANK, DENSE_RANK)

Common Table Expressions (CTEs – WITH clause)

⚡ Performance & Optimization (Intro)

Query execution basics

Index usage

Writing efficient queries

🧑‍💻 SQL with Real-World Scenarios

Employee & company databases

E-commerce use cases

Analytics-style queries

🎯 Interview Preparation

Most-asked SQL interview questions

Query-writing practice

Problem-solving approach

SQL tricks used in interviews

🏆 Bonus (Career Support)

SQL for backend developers

SQL for data roles

Resume & LinkedIn guidance

How SQL is used in real companies

🔰 Module 1: Programming & Database Fundamentals

What is programming?

What is Python & SQL

How Python and SQL work together

Real-world use cases

🐍 Module 2: Python Basics

Python installation & setup

Variables & data types

Input / Output

Type casting

Operators

🔁 Module 3: Control Flow in Python

if / else / elif

for & while loops

break, continue, pass

Nested logic

📦 Module 4: Python Data Structures

Strings & methods

Lists

Tuples

Sets

Dictionaries

Mutable vs immutable

🧠 Module 5: Functions in Python

Creating functions

Parameters & return values

Default & keyword arguments

*args and **kwargs

Lambda functions

⚠️ Module 6: Exception Handling

try / except

finally

Custom exceptions

🧩 Module 7: Object-Oriented Programming (OOP)

Classes & objects

Constructors

Inheritance

Polymorphism

Encapsulation

Abstraction

📂 Module 8: File Handling & Data Handling

Reading & writing files

CSV & text files

JSON basics

📊 Module 9: SQL Basics

What is SQL & DBMS

Tables, rows, columns

Data types

Creating databases & tables

📝 Module 10: SQL Queries (Core)

SELECT

INSERT

UPDATE

DELETE

WHERE clause

AND / OR / IN / BETWEEN / LIKE

🔗 Module 11: SQL Joins & Relationships

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL JOIN

Joining multiple tables

📐 Module 12: Aggregations & Analysis

COUNT, SUM, AVG

GROUP BY

HAVING

ORDER BY

LIMIT

🧠 Module 13: Advanced SQL

Subqueries

CASE statements

NULL handling

Window functions (intro)

CTEs (WITH clause – intro)

🔄 Module 14: Python + SQL Integration

Connecting Python with database

Executing SQL queries using Python

CRUD operations using Python

Real-world backend logic

🧑‍💻 Module 15: Mini Projects

Student management system

Employee database system

Data-driven Python scripts

🎯 Module 16: Interview & Career Preparation

Python + SQL interview questions

Query-solving practice

Resume & LinkedIn optimisation

How to apply for jobs

How to get referrals

🔰 Phase 1: Core Python (Mandatory for All)

Python basics → advanced

Variables, data types & operators

Conditions & loops

Data structures (list, dict, set, tuple)

Functions & modules

Exception handling

Object-Oriented Programming (OOP)

File handling & JSON

Writing clean & reusable code

📊 Phase 2: SQL for Backend Developers

Database concepts & relational models

SQL basics (SELECT, INSERT, UPDATE, DELETE)

Filtering & sorting data

Joins (INNER, LEFT, RIGHT)

Grouping & aggregations

Subqueries & optimization basics

How backend services use databases

⚙️ Phase 3: Backend Development (Choose ONE Path)

🔹 Option 1: Django + Django REST Framework (DRF)

Django project structure

Models & ORM

Views & serializers

REST APIs using DRF

Authentication & authorization

CRUD APIs

Pagination & filtering

Backend best practices

🔹 Option 2: FastAPI

FastAPI fundamentals

API routing & request handling

Pydantic models

Async APIs

Database integration

Authentication basics

High-performance API design

🔹 Option 3: Flask

Flask basics & app structure

Routing & request handling

REST API creation

Database integration

Authentication basics

Lightweight backend development

🔗 Phase 4: Python + Database Integration

Connecting backend with SQL database

Writing CRUD APIs

Handling real-world backend logic

Error handling & validations

🧑‍💻 Phase 5: Projects (Hands-On)

Backend CRUD project

API-based application

Real-world backend scenarios

Clean code & structure review

🎯 Phase 6: Interview & Career Preparation

Python backend interview questions

SQL interview questions

API & backend system questions

Resume & LinkedIn optimisation

Job application strategy

How to get referrals

🔰 Phase 1: Web Fundamentals

How the web works

Client–server architecture

HTTP & request–response cycle

Basics of web applications

🎨 Phase 2: Frontend Development

🔹 HTML (Structure)

HTML basics

Semantic HTML

Forms & inputs

Accessibility basics

🔹 CSS (Styling)

CSS fundamentals

Box model

Flexbox & Grid

Responsive design

Basic animations

🔹 JavaScript (Logic)

JavaScript fundamentals

Variables & data types

Conditions & loops

Functions

DOM manipulation

Event handling

Form validation

Fetch API (intro)

🐍 Phase 3: Python Programming

Python basics → advanced

Data types & data structures

Functions & modules

Exception handling

Object-Oriented Programming (OOP)

File handling & JSON

Writing clean & reusable code

📊 Phase 4: SQL & Databases

Database concepts

Relational database design

SQL basics (SELECT, INSERT, UPDATE, DELETE)

Filtering & sorting

Joins & relationships

Grouping & aggregations

Subqueries (intro)

⚙️ Phase 5: Backend Development with Django

Django fundamentals

Project & app structure

Models & ORM

Views & templates

Forms & validations

Authentication & authorization

Admin panel usage

🔌 Phase 6: APIs with Django REST Framework (DRF)

REST API concepts

Serializers

API views & viewsets

CRUD APIs

Authentication (JWT / token basics)

Pagination & filtering

API best practices

🔗 Phase 7: Frontend + Backend Integration

Connecting frontend with Django backend

Handling forms & API responses

Full stack request flow

Error handling

🧑‍💻 Phase 8: Projects (Hands-On)

Full stack CRUD application

User authentication system

Database-driven web app

Real-world project structure

🎯 Phase 9: Interview & Career Preparation

Full stack interview questions

Django & SQL interview prep

Resume & LinkedIn optimisation

Job application strategy

How to get referrals

Industry best practices