NPTEL : NOC:Data Base Management System (Computer Science and Engineering)

Co-ordinators : Prof. Partha Pratim Das


Lecture 1 - Course Overview

Lecture 2 - Introduction to DBMS/1

Lecture 3 - Introduction to DBMS/2

Lecture 4 - Introduction to Relational Model/1

Lecture 5 - Introduction to Relational Model/2

Lecture 6 - Introduction to SQL/1

Lecture 7 - Introduction to SQL/2

Lecture 8 - Introduction to SQL/3

Lecture 9 - Intermediate SQL/1

Lecture 10 - Intermediate SQL/2

Lecture 11 - Advanced SQL

Lecture 12 - Formal Relational Query Languages

Lecture 13 - Entity-Relationship Model/1

Lecture 14 - Entity-Relationship Model/2

Lecture 15 - Entity-Relationship Model/3

Lecture 16 - Relational Database Design

Lecture 17 - Relational Database Design (Continued...)

Lecture 18 - Relational Database Design/3

Lecture 19 - Relational Database Design (Continued...)

Lecture 20 - Relational Database Design/5

Lecture 21 - Application Design and Development/1

Lecture 22 - Application Design and Development/2

Lecture 23 - Application Design and Development/3

Lecture 24 - Storage and File Structure/1: Storage

Lecture 25 - Storage and File Structure/2: File Structure

Lecture 26 - Indexing and Hashing/1 : Indexing/1

Lecture 27 - Indexing and Hashing/2 : Indexing/2

Lecture 28 - Indexing and Hashing/3 : Indexing/3

Lecture 29 - Indexing and Hashing/4 : Hashing

Lecture 30 - Indexing and Hashing/5 : Index Design

Lecture 31 - Transactions/1

Lecture 32 - Transactions/2 : Serializability

Lecture 33 - Transactions/3 : Recoverability

Lecture 34 - Concurrency Control/1

Lecture 35 - Concurrency Control/2

Lecture 36 - Recovery/1

Lecture 37 - Recovery/2

Lecture 38 - Query Processing and Optimization/1 : Processing

Lecture 39 - Query Processing and Optimization/2 : Optimization

Lecture 40 - Course Summarization

Lecture 41 - Live Session

Lecture 42 - Live Session - 2