NPTEL : Database Design (Computer Science and Engineering)

Co-ordinators : Dr. S. Srikanth, Prof. D. Janaki Ram


Lecture 1 - Introduction to Database Management System

Lecture 2 - Conceptual Designs

Lecture 3 - Conceptual Designs

Lecture 4 - Relational Model

Lecture 5 - Relational Model

Lecture 6 - Structured Query Language - I

Lecture 7 - Structured Query Language - II

Lecture 8 - ER Model to Relational Mapping

Lecture 9 - Functional Dependencies and Normal Form

Lecture 10 - ER Model to Relational Model Mapping

Lecture 11 - Storage Structures

Lecture 12 - Indexing Techniques Single Level

Lecture 13 - Indexing Techniques Multi Level

Lecture 14 - Constraints and Triggers

Lecture 15 - Query Processing and Optimization

Lecture 16 - Query Processing and Optimization - II

Lecture 17 - Query Processing and Optimization - III

Lecture 18 - Transaction Processing Concepts

Lecture 19 - Transaction Processing and Database Manager

Lecture 20 - Foundation for Concurrency Control

Lecture 21 - Concurrency Control Part - 1

Lecture 22 - Concurrency Control Part - 2

Lecture 23 - Concurrency Control Part - 3

Lecture 24 - Concurrency Control Part - 4

Lecture 25 - Distributed Transaction Models

Lecture 26 - Basic 2-Phase and 3-phase commit protocol

Lecture 27 - Concurrency Control for Distributed Transaction

Lecture 28 - Introduction to Transaction Recovery

Lecture 29 - Recovery Mechanisms - II

Lecture 30 - Recovery Mechanisms - III

Lecture 31 - Introduction to Data Warehousing and OLAP

Lecture 32 - Introduction to Data Warehousing and OLAP

Lecture 33 - Case Study : MySQL

Lecture 34 - Case Study ORACLE and Microsoft Access

Lecture 35 - Data Mining and Knowledge Discovery

Lecture 36 - Data Mining and Knowledge Discovery Part - II

Lecture 37 - Object Oriented Databases

Lecture 38 - Object Oriented Databases - II

Lecture 39 - XML - Introductory Concepts

Lecture 40 - XML - Advanced Concepts

Lecture 41 - XML - Databases

Lecture 42 - Case Study - Part One - Database Design

Lecture 43 - Case Study - Part Two - Database Design