Fundamentals of Database Systems

Taught at IIT Kanpur

Prof. Arnab Bhattacharya of IIT Kanpur teaches this NPTEL course across 48 lectures. Its lecture list moves from the relational data model to a full run through SQL and normalization.

The lecture arc

1. Relational algebra, from basic operators to extended forms
2. Database modifications within relational algebra
3. SQL, from data definition and basic queries to joins, views and triggers
4. Normalization theory, from motivation through 1NF, 2NF, 3NF and BCNF

Who it is for

Because the course treats relational algebra before SQL, it reads like a formal path into the subject. It suits learners who want the theory behind query languages as well as the syntax.