Introduction to Database Systems

Lectures from IIT Madras

This NPTEL course is taught by Prof. Sreenivasa Kumar of IIT Madras across 43 lectures. The sequence starts with database architecture and RDBMS structure before moving into conceptual design.

Topics in the lecture list

• The entity-relationship model, including weak entities and design choices
• The relational data model and the notion of keys
• Relational algebra, renaming, joins and division
• Converting an ER model into a relational one
• Tuple relational calculus and example queries
• Data definition using SQL

Where to start

The lectures build on each other, from modeling to querying. It suits someone wanting a structured introduction from an IIT course, and the lecture list makes it easy to pick out one topic at a time.