InfoCoBuild

Database Design

Database Design. Instructor: Prof. D. Janakiram and Dr. S. Srinath, Department of Computer Science and Engineering, IIT Madras. This course provides an introduction to database systems, covering topics: Semantic Database Design; Relational Model, Languages and Systems; Database Design using the Relational Model; Storage and Indexing Structures; Transaction Processing and Concurrency Control; Database Recovery Techniques; Query Processing and Optimization; Database Security and Authorization; Enhanced Data Models for Specific Applications; Distributed Databases and Issues. (from nptel.ac.in)

Introduction


Lecture 01 - Introduction to Database Management System
Lecture 01a - Conceptual Design using the ER (Entity Relationship) Model
Lecture 02 - Conceptual Design (cont.)
Lecture 03 - The Relational Model and Relational Algebra
Lecture 04 - The Relational Model and Relational Algebra (cont.)
Lecture 05 - Structured Query Language (SQL)
Lecture 06 - Structured Query Language (cont.)
Lecture 07 - ER Model to Relational Mapping
Lecture 08 - Functional Dependencies and Normal Forms
Lecture 09 - ER Model to Relational Model Mapping
Lecture 10 - Storage Structures
Lecture 11 - Indexing Techniques: Single Level
Lecture 12 - Indexing Techniques: Multi-Level and Dynamic Indexes
Lecture 13 - Constraints and Triggers
Lecture 14 - Query Processing and Optimization
Lecture 15 - Query Processing and Optimization (cont.)
Lecture 16 - Query Processing and Optimization (cont.)
Lecture 17 - Transaction Processing Concepts
Lecture 18 - Transaction Processing and Database Manager
Lecture 19 - Foundation for Concurrency Control
Lecture 20 - Concurrency Control, Part 1
Lecture 21 - Concurrency Control, Part 2
Lecture 22 - Concurrency Control, Part 3
Lecture 23 - Concurrency Control, Part 4
Lecture 24 - Distributed Transaction Models
Lecture 25 - Basic 2-Phase and 3-Phase Commit Protocol
Lecture 26 - Concurrency Control for Distributed Transaction
Lecture 27 - Introduction to Transaction Recovery
Lecture 28 - Recovery Mechanisms (cont.)
Lecture 29 - Recovery Mechanisms (cont.)
Lecture 30 - Introduction to Data Warehousing and OLAP
Lecture 31 - Introduction to Data Warehousing and OLAP (cont.)
Lecture 32 - DBMS Case Study: MySQL
Lecture 33 - DBMS Case Study: ORACLE and Microsoft Access
Lecture 34 - Data Mining and Knowledge Discovery
Lecture 35 - Data Mining and Knowledge Discovery (cont.)
Lecture 36 - Object Oriented Databases
Lecture 37 - Object Oriented Databases (cont.)
Lecture 38 - XML - Introductory Concepts
Lecture 39 - XML - Advanced Concepts
Lecture 40 - XML Databases and Managing Semi-structured Data
Lecture 41 - Case Study: Database Design, Part 1
Lecture 42 - Case Study: Database Design, Part 2

References
Database Design
Instructor: Prof. D. Janakiram and Dr. S. Srinath, Department of Computer Science and Engineering, IIT Madras. This course provides an introduction to database systems.