Database Management System

Lecture -1 Introduction to Database Management System

Lecture -1a Conceptual Designs

Lecture -2 Conceptual Designs

Lecture - 3 Relational Model

Lecture - 4 Relational Model 2

Lecture - 5 Structured Query Language

Lecture - 6 Structured Query Language II

Lecture - 7 ER Model to Relational Mapping

Lecture - 8 Functional Dependencies and Normal Form

Lecture - 9 ER Model to Relational Model Maping

Lecture - 10 Storage Structures

Lecture - 11 Indexing Techniques Single Level

Lecture - 12 Indexing Techniques Multi-Level

Lecture - 13 Constraints and Triggers

Lecture - 14 Query Processing and Optimization

Lecture -15 Query Processing and Optimization II

Lecture - 16 Query Processing and Optimization - III

Lecture - 17 Transaction Processing Concepts

Lecture - 18 Transaction Processing and Database Manager

Lecture - 19 Foundation for Concurrency Control

Lecture - 20 Concurrency Control Part - I

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 II

Lecture - 29 Recovery Mechanisms III

Lecture - 30 Introduction to Data Warehousing and OLAP 1

Lecture - 31 Introduction to Data Warehousing and OLAP 2

Lecture - 32 Case Study : MYSQL

Lecture - 33 Case Study ORACLE and Microsoft Access

Lecture - 34 Data Mining and Knowledge Discovery

Lecture - 35 Data Mining and Knowledge Discovery Part II

Lecture - 36 Object Oriented Databases

Object Oriented Databases II

XML - Introductory Concepts

XML Advanced Concepts

XML Databases

Case Study - Part One Database Design

Case Study - Part 2 Database Design