Database Design


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