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)

Lecture 16 - Query Processing and Optimization (cont.)

Go to the Course Home or watch other lectures:

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