Data Base Management System

This NPTEL course from IIT Kharagpur takes a database from first principles. It opens with a course overview and an introduction to DBMS, then builds the relational model, the SQL language in three stages, and the formal query languages that sit underneath it.

From model to query

The middle of the course introduces the relational model and then works through intermediate and advanced SQL. Later lectures move to formal relational query languages and finish with the entity-relationship model, which is where most design decisions begin.

Who gets the most out of it

• Students who have only written simple SELECT statements and want the reasons behind joins and nested queries.
• Anyone preparing a database design for a project who needs the entity-relationship step explained clearly.
• Learners who plan to take GATE or a university exam that asks for relational algebra as well as SQL.