|
Module 1 - The Relational Model & Normalization
|
|
|
|
Mod 1 - Lecture 1 - Introduction to DBMS and Relational Model
|
|
|
|
Notes - Mod 1 Lecture 1 - Introduction to DBMS and Relational Model Annotated Notes
(68 pages)
|
|
|
|
Mod 1 - Lecture 2 - The Relational Model
|
|
|
|
Notes - Mod 1 Lecture 2 - The Relational Model Annotated Notes
(120 pages)
|
|
|
|
Mod 1 - Lecture 3 - Questions Candidate Keys, Super Keys
27:00
|
|
|
|
Mod 1 - Lecture 4 - Integrity Constraints in Relational Model, Foreign Key
27:00
|
|
|
|
Notes - Mod 1 Lecture 4 - Integrity Constraints in Relational Model Annotated Notes
(161 pages)
|
|
|
|
Mod 1 - Lecture 5 - Functional Dependency
234:00
|
|
|
|
Notes - Mod 1 Lecture 5 - Functional Dependency Annotated Notes
(154 pages)
|
|
|
|
Mod 1 - Lecture 6 - Normal Forms 1NF, 2NF
|
|
|
|
Mod 1 - Lecture 7 - Normal Forms 3NF
130:00
|
|
|
|
Mod 1 - Lecture 8 - BCNF Normal Forms & Practice Questions
105:00
|
|
|
|
Notes 6,7,8 - Mod 1 - Lecture 6,7,8 - Normal Forms Annotated Notes
(340 pages)
|
|
|
|
Mod 1 - Lecture 9 - Decomposition and Normalization
|
|
|
|
Mod 1 - Lecture 10 - Decomposition and Normalization Part 2
|
|
|
|
Notes 9,10 - Mod1 - Lecture 9,10 - Decomposition, Normalization Annotated Notes
(201 pages)
|
|
|
|
Non-Binary Decomposition Complete Playlist
|
|
|
|
Notes - Complete Decomposition, Non-Binary Decomposition Annotated Notes
(185 pages)
|
|
|
|
Normalization Revision Playlist
|
|
|
|
Mod 1 - Lecture 11 - Practice Questions
|
|
|
|
Mod 1 - Lecture 12 - Minimal FD Cover and Practice Questions
|
|
|
|
Notes 11,12 - Lecture 11,12 - Minimal FD Cover and Practice Questions Annotated Notes
|
|
|
|
Mod 1 - Lecture 13 - Data Independence
133:00
|
|
|
|
Mod 1 - Lecture 14 - Practice Questions
129:00
|
|
|
|
Notes 13,14 - Lecture 13,14 - Data Independence, Practice Questions Annotated Notes
(196 pages)
|
|
|
|
Mod 1 - Lecture 15 - Understanding Redundancies
|
|
|
|
Mod 1 - Lecture 16 - 3NF, BCNF Decomposition
|
|
|
|
Notes - Mod 1 - Lecture 15,16 - Understanding Redundancies, 3NF, BCNF Decomposition Annotated Notes
(239 pages)
|
|
|
Module 2 - Queries
|
|
|
|
Mod 2 - Lecture 1 - Relational Algebra
|
|
|
|
Mod 2 - Lecture 2 - Relational Algebra Set Operations
|
|
|
|
Notes - Mod 2 - Lecture 1,2 - Relational Algebra Annotated Notes
(248 pages)
|
|
|
|
Mod 2 - Lecture 3 - Inner Join Operations in Relational Algebra
|
|
|
|
Mod 2 - Lecture 4 - Division Operation in Relational Algebra
|
|
|
|
Notes - Mod2 - Lecture 3,4 - Relational Algebra Join, Division, Queries Annotated Notes
(208 pages)
|
|
|
|
Mod 2 - Lecture 5 - Division Operation, Outer Join in Relational Algebra
|
|
|
|
Notes - Mod 2 - Lecture 5 - Division Operation, Outer Join in Relational Algebra Annotated Notes
(124 pages)
|
|
|
|
Mod 2 - Lecture 6 - Practice Relational Algebra Operators
|
|
|
|
Mod 2 - Lecture 7 - Writing & Understanding Relational Algebra Queries
|
|
|
|
Mod 2 - Lecture 8 - GATE Questions Relational Algebra
|
|
|
|
Notes - Mod 2 - Lecture 6,7,8 Relational Algebra Queries Annotated Notes
(276 pages)
|
|
|
|
Mod 2 - Lecture 9 - Tuple Relational Calculus TRC
|
|
|
|
Mod 2 - Lecture 10 - Tuple Relational Calculus TRC
|
|
|
|
Mod 2 - Lecture 11 - Tuple Relational Calculus TRC
|
|
|
|
Notes - Mod 2 - Lecture 9,10,11 - Tuple Relational Calculus TRC Annotated Notes
(183 pages)
|
|
|
|
Mod 2 - Lecture 12 - TRC Practice Questions
|
|
|
|
Notes - Mod 2 - Lecture 12 - TRC Practice Questions Annotated Notes
(132 pages)
|
|
|
|
Mod 2 - Lecture 13 - TRC GATE Questions
|
|
|
|
Notes - Mod 2 - Lecture 13 - TRC GATE Questions Annotated Notes
(81 pages)
|
|
|
|
Mod 2 - Lecture 14 - SQL Basics
|
|
|
|
Mod 2 - Lecture 15 - Writing SQL Queries, Union, Except
|
|
|
|
Notes - Mod 2 - Lecture 14,15 - SQL Basics Annotated Notes
(223 pages)
|
|
|
|
Mod 2 - Lecture 16 - SQL Queries using Union, Except, Intersect
|
|
|
|
Notes - Mod 2 - Lecture 16 - SQL Queries using Union, Except, Intersect Annotated Notes
(116 pages)
|
|
|
|
Mod 2 - Lecture 17 - Some Notes on Select, Where Clause
|
|
|
|
Mod 2 - Lecture 18 - Aggregate Operators
|
|
|
|
Mod 2 - Lecture 19 - Null Values in SQL
|
|
|
|
Notes - Mod 2 - Lecture 17,18,19 - Aggregate Operators Annotated Notes
(208 pages)
|
|
|
|
Mod 2 - Lecture 20 - Group By, Having, Order By Clauses
|
|
|
|
Notes - Mod 2 - Lecture 20 - Group By, Having, Order By Clauses Annotated Notes
(182 pages)
|
|
|
|
Mod 2 - Lecture 21 - SQL Practice Questions
145:00
|
|
|
|
Notes - Mod 2 - Lecture 21 - SQL Practice Questions Annotated Notes
(108 pages)
|
|
|
|
Mod 2 - Lecture 22 - Nested Queries
|
|
|
|
Mod 2 - Lecture 23 - Correlated Nested Queries in SQL
|
|
|
|
Notes - Mod 2 - Lecture 22,23 - Nested Queries Annotated Notes
(222 pages)
|
|
|
|
Mod 2 - Lecture 24 - SQL GATE Questions
120:00
|
|
|
|
Notes - Mod 2 - Lecture 24 - SQL GATE Questions Annotated Notes
(90 pages)
|
|
|
Module 3 - ER Model
|
|
|
|
Mod 3 - Lecture 1 - ER Model
182:00
|
|
|
|
Mod 3 - Lecture 2 - Weak Entity Set in ER Model
103:00
|
|
|
|
Notes - Mod 3 - Lecture 1,2 ER Model Annotated Notes
(216 pages)
|
|
|
|
Mod 3 - Lecture 3 - ER Model
261:00
|
|
|
|
Notes - Mod 3 - Lecture 3 ER Model Annotated Notes
(251 pages)
|
|
|
Module 4 - Magnetic Disk
|
|
|
|
Mod 4 - Lecture 1 - Disk Structure & Performance
|
|
|
|
Mod 4 - Lecture 2 - Disk Addressing
|
|
|
|
Mod4 - Lecture 1,2 - Disk Structure, Performance, Addressing Annotated Notes
|
|
|
|
Mod 4 - Lecture 3 - Disk Scheduling Algorithms
|
|
|
|
Mod 4 - Lecture 4 - Disk Scheduling Algorithms Part 2
|
|
|
|
Notes - Mod 4 - Lecture 3,4 - Disk Scheduling Algorithms Annotated Notes
(133 pages)
|
|
|
Module 5 - File Organization & Indexing
|
|
|
|
Mod 5 - Lecture 1 - File Organization
|
|
|
|
Mod 5 - Lecture 2 - Practice File Organization
|
|
|
|
Notes - Mod 5 - Lecture 1,2 - File Organization Annotated Notes
(188 pages)
|
|
|
|
Mod 5 - Lecture 3 - Free Disk Space Management
|
|
|
|
Mod 5 - Lecture 3 Annotated Notes Lost
|
|
|
|
Notes - Mod5 - Lecture 3 - Disk Free Space Management
(64 pages)
|
|
|
|
Mod 5 - Lecture 4 - Indexing - Ordered Indexes
|
|
|
|
Mod 5 - Lecture 5 - Primary Index
|
|
|
|
Mod 5 - Lecture 5 - Primary Index
100:00
|
|
|
|
Mod 5 - Lecture 6 - Clustering Index
|
|
|
|
Notes - Mod 5 - Lecture 4 ,5,6- Indexing - Ordered Indexes Annotated Notes
(177 pages)
|
|
|
|
Mod 5 - Lecture 7 - Secondary Index
|
|
|
|
Mod 5 - Lecture 8 - Questions on Indexes
|
|
|
|
Notes - Mod 5 - Lecture 7,8 - Secondary Index Annotated Notes
(191 pages)
|
|
|
|
Mod 5 - Lecture 9 - Multilevel Index & ISAM
|
|
|
|
Mod 5 - Lecture 10 - GATE Questions on Indexing
|
|
|
|
Notes - Mod 5 - Lecture 9,10 - Multilevel Index & ISAM Annotated Notes
(134 pages)
|
|
|
|
Mod 5 - Lecture 11 - B Tree
|
|
|
|
Mod 5 - Lecture 12 - B Tree Insertion
|
|
|
|
Mod 5 - Lecture 13 - B Tree Order Questions
|
|
|
|
Mod 5 - Lecture 14 - B Tree Structure Questions
|
|
|
|
Mod 5 - Lecture 15 - B Tree More Questions
|
|
|
|
Notes - Mod 5 - Lecture 11,12,13,14,15 - B Tree Annotated Notes
(287 pages)
|
|
|
|
Mod 5 - Lecture 16 - B+ Tree
|
|
|
|
Notes - Mod 5 - Lecture 16 - B+ Tree Annotated Notes
(52 pages)
|
|
|
|
Mod 5 - Lecture 17 - B+ Tree Range Search
|
|
|
|
Mod 5 - Lecture 18 - B+ Tree Insertion
|
|
|
|
Mod 5 - Lecture 19 - B+ Tree Questions
|
|
|
|
Notes - Mod 5 - Lecture 17,18,19 - B+ Tree Annotated Notes
(219 pages)
|
|
|
Module 6 - Transaction Management & Recovery
|
|
|
|
Mod 6 - Lecture 1 - Transaction, Database Consistency
|
|
|
|
Mod 6 - Lecture 2 - Transaction, Read Write Operations
|
|
|
|
Mod 6 - Lecture 3 - ACID Properties
|
|
|
|
Notes - Mod 6 - Lecture 1,2,3 - Transaction, ACID Properties, Database Consistency Annotated Notes
(238 pages)
|
|
|
|
Mod 6 - Lecture 4 - Practice ACID Properties, Database Consistency
|
|
|
|
Notes - Mod 6 - Lecture 4 - Practice ACID Properties, Database Consistency Annotated Notes
(92 pages)
|
|
|
|
Mod 6 - Lecture 5 - Serializability Introduction
|
|
|
|
Notes - Mod 6 - Lecture 5 - Serializability Introduction Annotated Notes
(66 pages)
|
|
|
|
Mod 6 - Lecture 6 - Serializability In General
|
|
|
|
Notes - Mod 6 - Lecture 6 - Serializability In General Annotated Notes
(103 pages)
|
|
|
|
Mod 6 - Lecture 7 - Conflict Serializability
|
|
|
|
Notes - Mod 6 - Lecture 7 - Conflict Serializability Annotated Notes
(144 pages)
|
|
|
|
Mod 6 - Lecture 8 - View Serializability
|
|
|
|
Notes - Mod 6 - Lecture 8 - View Serializability Annotated Notes
(150 pages)
|
|
|
|
Mod 6 - Lecture 9 - Recoverability
|
|
|
|
Notes - Mod 6 - Lecture 9 - Recoverability Annotated Notes
(116 pages)
|
|
|
|
Mod 6 - Lecture 10 - General Locking Protocol for Concurrency Control
|
|
|
|
Notes - Mod 6 - Lecture 10 - General Locking Protocol for Concurrency Control Annotated Notes
(100 pages)
|
|
|
|
Mod 6 - Lecture 11 - Two Phase Locking Protocol
|
|
|
|
Notes - Mod 6 - Lecture 11 - Two Phase Locking Protocol Annotated Notes
(106 pages)
|
|
|
|
Mod 6 - Lecture 12 - Two Phase Locking Protocol Variations
|
|
|
|
Mod 6 - Lecture 13 - Deadlock Handling
|
|
|
|
Notes - Mod 6 - Lecture 12,13 - Two Phase Locking Variations, Deadlock Handling Annotated Notes
(158 pages)
|
|
|
|
Mod 6 - Lecture 14 - Timestamp Based Protocols for Concurrency Control
|
|
|
|
Notes - Mod 6 - Lecture 14 - Timestamp Based Protocols for Concurrency Control Annotated Notes
(142 pages)
|
|
|
|
Mod 6 - Lecture 15 - Timestamp Protocol 50 Questions
180:00
|
|
|
|
Notes - Mod 6 - Lecture 15 - Timestamp Protocol 50 Questions Annotated Notes
(240 pages)
|
|
|
Practice Sets
|
|
|
|
Practice Set 1 - Normalization Ullman Questions
(44 pages)
|
|
|
|
Practice Set 1 - Normalization Live Discussion
120:00
|
|
|
|
Practice Set 1 Solution Part 2 - Normalization
134:00
|
|
|
|
Notes - Practice Set 1 - Normalization Ullman Questions Annotated Notes
(154 pages)
|
|
|
|
Practice Set 2 - NPTEL DBMS 2022 Assignment 1 - Normalization, Relational Algebra
(11 pages)
|
|
|
|
Practice Set 2 - NPTEL DBMS 2022 Assignment 1 - Normalization, Relational Algebra
|
|
|
|
Notes - Practice Set 2 - NPTEL DBMS 2022 Assignment 1 - Normalization, Relational Algebra Annotated Notes
(70 pages)
|
|
|
|
Practice Set 3 - GATE PYQs Magnetic Disk & Disk Scheduling Algorithm
(35 pages)
|
|