SQL & Databases
The DB in our name — schema, keys, joins, and reports you can defend in a viva.
Syllabus
This is the course the rest of the institute leans on. In two months you learn to see a problem as tables, keys, and the questions those tables can answer. You write SELECT until joins are boring, then GROUP BY, subqueries, and views until a report is a statement, not a screenshot. Normalization is practiced on messy college data — students, courses, marks, fees — until repeating groups make you itch. Transactions and constraints are taught as promises the database keeps when the app does not. You design a college schema, a retail inventory with stock movements, and a library model that survives a viva. Mentors ask “what happens if this row is deleted?” until you have an answer. Offline and live-online students query the same sample databases. You leave able to open a blank SQL tab and not panic — which is the DB Madeez edge, written down.
What you leave with
- Draw a schema before you write an INSERT
- Join and aggregate without guessing
- Defend keys and constraints in a viva
Three projects
01
College schema + mark reports
Students, courses, internals, and the queries a class tutor would actually run.
02
Retail inventory
Stock movements, low-stock views, and constraints that stop impossible rows.
03
Normalized library
Members, copies, loans — designed so a delete does not take the catalogue with it.