Practical SQL for MIS & Data Analysts — syllabus 2026
Twelve modules from database basics to window functions and CTEs, finishing with the SQL you actually write for MIS reports, KPIs and Power BI.
Module-wise syllabus
Tap a module to see every topic. The same syllabus is used in our classroom and live online batches.
01Introduction to Databases & SQL5 topics
- Databases, DBMS & RDBMS concepts
- Relational vs non-relational databases
- MySQL, SQL Server, Oracle, PostgreSQL
- Tables, records & fields
- Command types: DDL, DML, DQL, DCL, TCL
02Database & Table Management (DDL)5 topics
- Create, select & drop databases
- Creating tables & SQL data types
- Constraints: NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, DEFAULT
- ALTER: add, modify, rename & drop columns
- DROP vs TRUNCATE; schema & table-design best practices
03Data Manipulation (DML)5 topics
- INSERT single, multiple & from another table
- UPDATE with conditions & multiple columns
- DELETE specific & all records
- DELETE vs TRUNCATE vs DROP
- Handling NULLs; data consistency & integrity
04Data Retrieval with SELECT5 topics
- SELECT syntax, specific columns, DISTINCT
- WHERE with comparison & logical operators
- BETWEEN, IN, NOT IN, LIKE & wildcards
- ORDER BY, LIMIT / TOP / FETCH
- Aliases and expressions
05Functions in SQL5 topics
- String: UPPER, LOWER, LENGTH, SUBSTRING, TRIM
- Numeric: ROUND, CEILING, FLOOR
- Date: CURRENT_DATE, NOW, DATEADD / DATEDIFF
- Aggregates: COUNT, SUM, AVG, MIN, MAX
- GROUP BY, HAVING, and WHERE vs HAVING
06Joins & Relationships4 topics
- Primary vs foreign keys
- INNER, LEFT, RIGHT, FULL & SELF JOIN
- Joining multiple tables with conditions
- Real-world join scenarios & performance
07Subqueries & Nested Queries4 topics
- Single-row, multi-row & correlated subqueries
- Subqueries in SELECT, INSERT, UPDATE, DELETE
- IN, EXISTS, ANY, ALL
- Practical use cases
08Views, Indexes & Sequences3 topics
- Creating, updating & dropping views
- Types of indexes; when to use them
- Performance impact of indexes
09Transactions (TCL)3 topics
- What a transaction is; ACID properties
- COMMIT, ROLLBACK, SAVEPOINT
- Auto-commit vs manual commit
10Security & User Management (DCL)3 topics
- Creating users
- GRANT & REVOKE privileges
- Role management & security best practices
11Advanced SQL5 topics
- CASE and IF / ELSE logic
- Window functions: ROW_NUMBER, RANK, DENSE_RANK, OVER
- Common Table Expressions (CTE)
- Temporary tables & large datasets
- Query optimisation basics
12SQL for Data Analytics & MIS4 topics
- Queries for MIS reports & dashboards
- KPI calculations & time-based analysis
- Sales, finance & HR use cases
- SQL with Excel & Power BI
Projects & practice
Programmes that include SQL
| Programme | Duration | Fees |
|---|---|---|
| Basic MIS & Analytics | 3–4 months | ₹10,000 |
| Advance MIS & Analytics | 4–6 months | ₹20,000 |
| Professional MIS & Analytics + Job Placement | 6–8 months | ₹30,000 |
Learning only SQL? See the SQL course page or the local pages for Dwarka Uttam Nagar Janakpuri .
Frequently asked questions
Can I download the SQL syllabus as a PDF?
Yes. Use the “Download syllabus PDF” button on this page — enter your name and mobile number and the PDF opens instantly.
How long does the SQL course take?
It is taught inside our programmes: Basic MIS & Analytics (3–4 months, ₹10,000); Advance MIS & Analytics (4–6 months, ₹20,000); Professional MIS & Analytics + Job Placement (6–8 months, ₹30,000). Module-wise batches are also possible — ask the counsellor.
Is it online or classroom?
Both. Classroom batches run at our Dwarka, Uttam Nagar and Janakpuri branches, and live online batches are available.