Beginner Level

1. Intro to SQL & Databases

RDBMS, Tables, SQL syntax, CRUD overview

2. Creating Tables & Data Types

CREATE TABLE, PRIMARY KEY, NOT NULL, data types

3. Inserting & Selecting Data

INSERT INTO, SELECT, aliases

4. Filtering & Sorting

WHERE, AND/OR, ORDER BY, BETWEEN, IN

5. Functions

String, numeric, date functions

6. Update & Delete

UPDATE, DELETE, TRUNCATE

Intermediate Level

7. Aggregate Functions & Grouping

SUM, AVG, COUNT, GROUP BY, HAVING

8. Joins

INNER, LEFT, RIGHT, FULL OUTER, CROSS JOIN

9. Subqueries

In SELECT, WHERE, correlated subqueries, EXISTS

10. Set Operations

UNION, UNION ALL, INTERSECT, EXCEPT

Adanced Level

11. Window Functions

ROW_NUMBER(), RANK(), PARTITION BY

Practical & Final Week

12.  Stored Procedures (optional)

CREATE PROCEDURE, input/output parameters

13. Case Studies & Practice

Real-world queries where I'll be guiding you through how to answer in interviews what are the questions usually asked in interviews

13.2 Mock test :- I'll be taking two mock test/ interview.

14. Mini Projecet:- One mini project will start once the whole topics are covered. This will be done by students only, I'll be guiding how to do and what to do exactly that will improve there resume also.