|
Module 1 - The Relational Model & Normalization
|
|
|
|
About Lecture 1
|
|
|
|
Lecture 1 - Introduction to DBMS, Data Models, Design Process
104:00
|
|
|
|
Annotated Notes - Lecture 1 - Introduction to DBMS, Data Models
(68 pages)
|
|
|
|
Lecture 2A - The Relational Model - Concepts & Terminology
39:00
|
|
|
|
Lecture 2B - The Relational Model - Why Table is called Relation?
28:00
|
|
|
|
Lecture 2C - The Relational Model - Null Values
11:00
|
|
|
|
GATE 2023 Question
|
|
|
|
Lecture 2D - The Relational Model - Keys - Candidate Key, Primary Key, Super Key
57:00
|
|
|
|
Annotated Notes - Lecture 2 - The Relational Model
(111 pages)
|
|
|
|
Lecture 2E - Practice Questions on Keys
21:00
|
|
|
|
Annotated Notes - Lecture 2E - Practice Questions on Keys
(22 pages)
|
|
|
|
(OPTIONAL) Lecture 3 - SQL - DDL & DML
|
|
|
|
Annotated Notes - (OPTIONAL) Lecture 3 - SQL - DDL & DML
(110 pages)
|
|
|
|
Lecture 4A - Integrity Constraints in Relational Model
53:00
|
|
|
|
Lecture 4B - Referential Integrity Constraints - Foreign Key
72:00
|
|
|
|
Lecture 4C - Actions Taken by DBMS to Enforce Referential Integrity Constraints
52:00
|
|
|
|
Annotated Notes - Lecture 4A - Integrity Constraints in Relational Model
(160 pages)
|
|
|
|
Lecture 5A - Functional Dependency
|
|
|
|
Annotated Notes - Lecture 5A - Functional Dependency
(121 pages)
|
|
|
|
Lecture 5B - Functional Dependency Laws, Closure of Attribute Set
|
|
|
|
Annotated Notes - Lecture 5B - Functional Dependency Laws, Closure of Attribute Set
(167 pages)
|
|
|
|
Lecture 5C - Practice - Finding Candidate Keys
|
|
|
|
Annotated Notes - Lecture 5C - Practice - Finding Candidate Keys
(92 pages)
|
|
|
|
Lecture 5D - Functional Dependency - Inference & Equivalence
|
|
|
|
Annotated Notes - Lecture 5D - Functional Dependency - Inference & Equivalence
(95 pages)
|
|
|
|
Lecture 5E - Minimal Cover of Functional Dependencies
129:00
|
|
|
|
Annotated Notes - Lecture 5E - Minimal Cover of Functional Dependencies
(140 pages)
|
|
|
|
Weekly Quiz 1 - Relational Model - ALL NIELIT Exam PYQs
|
|
|
|
Weekly Quiz 2 - Functional Dependency
|
|
|
|
Lecture 6A - Normal Forms - Partial Functional Dependency, Transitive FD
91:00
|
|
|
|
Annotated Notes - Lecture 6A - Normal Forms - Partial, Transitive FD
(85 pages)
|
|
|
|
Lecture 6B - Normal Forms - 1NF, 2NF
81:00
|
|
|
|
Annotated Notes - Lecture 6B - Normal Forms - 1NF, 2NF
(109 pages)
|
|
|
|
Lecture 6C - Normal Forms - 3NF Third Normal Form
33:00
|
|
|
|
Lecture 6D - Normal Forms - Practice Questions 3NF
29:00
|
|
|
|
Annotated Notes - Lecture 6C-6D - Normal Forms - 3NF
(65 pages)
|
|
|
|
Lecture 6E - Normal Forms - BCNF
14:00
|
|
|
|
GATE IT 2005 - Normalization Question
|
|
|
|
GATE CSE 1987 - Functional Dependency Question
|
|
|
|
GATE CSE 2020 Question - 3NF But Not BCNF
|
|
|
|
GATE CSE 2007, 1990 - Normal Forms Questions
|
|
|
|
GATE CSE 2012 - 3NF, BCNF Question
|
|
|
|
Annotated Notes - Lecture 6E - Normal Forms - BCNF
(64 pages)
|
|
|
|
Lecture 7A - Normalization & Decomposition - Lossless, Lossy
119:00
|
|
|
|
Lecture 7B - Practice Questions - Decomposition - Lossless, Lossy
17:00
|
|
|
|
Lecture 7C - Decomposition - Dependency Preservation
81:00
|
|
|
|
Annotated Notes - Lecture 7A-7C - Decomposition
(201 pages)
|
|
|
|
Lecture 7D - Non-Binary Decomposition & Chase Test
|
|
|
|
Annotated Notes - Lecture 7D - Non-Binary Decomposition & Chase Test
(185 pages)
|
|
|
|
Lecture 8A - 2NF Decomposition
35:00
|
|
|
|
Annotated Notes - Lecture 8A - 2NF Decomposition
(36 pages)
|
|
|
|
Lecture 8B - Understanding Redundancies - Due to FDs & MVDs
71:00
|
|
|
|
Lecture 8C - 3NF, BCNF Decomposition
173:00
|
|
|
|
Annotated Notes - Lecture 8B-8C - Understanding Redundancies, 3NF, BCNF Decomposition
(239 pages)
|
|
|
|
Lecture 8D - GATE PYQs on 3NF, BCNF Decomposition
112:00
|
|
|
|
Annotated Notes - Lecture 8D - GATE PYQs on 3NF, BCNF Decomposition
(117 pages)
|
|
|
|
About Lecture 9
|
|
|
|
(OPTIONAL) Lecture 9 - Physical, Logical Data Independence
133:00
|
|
|
|
Annotated Notes - Lecture 9 - Physical, Logical Data Independence
(88 pages)
|
|
|
|
GATE PYQs & Standard Practice Questions
|
|
|
|
Weekly Quiz 3 - Normalization & Relational Model
|
|
|
|
Weekly Quiz 4 - Normal Forms
|
|
|
|
Weekly Quiz 5 - Normalization
|
|
|
|
Weekly Quiz 6 - Normalization
|
|
|
Module 2 - Queries - Relational Algebra
|
|
|
|
Lecture 1 - Relational Algebra - Selection, Projection
149:00
|
|
|
|
Lecture 2 - Relational Algebra - Set Operations
100:00
|
|
|
|
Annotated Notes - Lecture 1,2 - Relational Algebra
(248 pages)
|
|
|
|
Lecture 3 - Relational Algebra - Inner Join Operations
137:00
|
|
|
|
Lecture 4 - Relational Algebra - Division Operation
104:00
|
|
|
|
Annotated Notes - Lecture 3,4 - Relational Algebra - Join, Division
(208 pages)
|
|
|
|
Lecture 5 - Division Operation, Outer Join in Relational Algebra
120:00
|
|
|
|
Annotated Notes - Lecture 5 - Division Operation, Outer Join in Relational Algebra
(124 pages)
|
|
|
|
Lecture 6 - Practice - Relational Algebra Operators
101:00
|
|
|
|
Lecture 7 - Writing & Understanding Relational Algebra Queries
128:00
|
|
|
|
Lecture 8 - GATE PYQs - Relational Algebra
|
|
|
|
Annotated Notes - Lecture 6,7,8 - Relational Algebra Queries
(276 pages)
|
|
|
|
Weekly Quiz 1 - Relational Algebra
|
|
|
|
Weekly Quiz 2 - Relational Algebra
|
|
|
Module 3 - Queries - Tuple Relational Calculus TRC
|
|
|
|
Lecture 1 - Tuple Relational Calculus TRC
65:00
|
|
|
|
Lecture 2 - Tuple Relational Calculus TRC
94:00
|
|
|
|
Lecture 3 - Tuple Relational Calculus TRC
92:00
|
|
|
|
Annotated Notes - Lecture 1-3 - Tuple Relational Calculus TRC
(183 pages)
|
|
|
|
Lecture 4 - TRC Practice Questions
146:00
|
|
|
|
Annotated Notes - Lecture 4 - TRC Practice Questions
(132 pages)
|
|
|
|
GATE CSE 1999 - Tuple Relational Expression Question
26:00
|
|
|
|
GATE CSE 2002 - Tuple Relational Calculus Question
3:00
|
|
|
|
GATE CSE 2007 - Tuple Relational Calculus Question
11:00
|
|
|
|
GATE CSE 2008 - Tuple Relational Calculus Question
4:00
|
|
|
|
GATE IT 2006 - TRC Question
|
|
|
Module 4 - Queries - SQL
|
|
|
|
SQL - Complete Summary & GATE PYQs
|
|
|
|
Lecture 1 - SQL Basics
119:00
|
|
|
|
Lecture 2 - Writing SQL Queries, Union, Except
87:00
|
|
|
|
Annotated Notes - Lecture 1-2 - SQL Basics
(223 pages)
|
|
|
|
Lecture 3 - SQL Queries using Union, Except, Intersect
117:00
|
|
|
|
Annotated Notes - Lecture 3 - SQL Queries using Union, Except, Intersect
(116 pages)
|
|
|
|
Lecture 4 - Some Notes on Select, Where Clause
76:00
|
|
|
|
Weekly Quiz 1 - SQL Basics
|
|
|
|
Lecture 5 - Aggregate Operators
56:00
|
|
|
|
Lecture 6 - Null Values in SQL
113:00
|
|
|
|
Annotated Notes - Lecture 4-6 - Aggregate Operators
(208 pages)
|
|
|
|
Lecture 7 - Group By, Having, Order By Clauses
210:00
|
|
|
|
Annotated Notes - Lecture 7 - Group By, Having, Order By Clauses
(182 pages)
|
|
|
|
Lecture 8 - Nested Queries
107:00
|
|
|
|
Lecture 9 - Correlated Nested Queries in SQL
112:00
|
|
|
|
Annotated Notes - Lecture 8-9 - Nested Queries
(222 pages)
|
|
|
|
SQL - Summary & GATE PYQs - Complete Analysis
|
|
|
|
Weekly Quiz 2 - SQL
|
|
|
|
Weekly Quiz 3 - SQL
|
|
|
Module 5 - Magnetic Disk
|
|
|
|
Lecture 1 - Disk Structure & Performance
169:00
|
|
|
|
Lecture 2 - Disk Addressing
119:00
|
|
|
|
Annotated Notes - Lecture 1,2 - Disk Structure, Performance, Addressing
(172 pages)
|
|
|
Module 6 - File Organization & Indexing
|
|
|
|
Lecture 1 - File Organization
163:00
|
|
|
|
Lecture 2 - Practice Questions - File Organization
124:00
|
|
|
|
Annotated Notes - Lecture 1,2 - File Organization
(188 pages)
|
|
|
|
Lecture 3 - Free Disk Space Management
135:00
|
|
|
|
Lecture 3 Annotated Notes
|
|
|
|
Slides - Lecture 3 - Disk Free Space Management
(64 pages)
|
|
|
|
Lecture 4 - Indexing - Ordered Indexes
71:00
|
|
|
|
Lecture 5 - Primary Index
106:00
|
|
|
|
Lecture 6 - Clustering Index
63:00
|
|
|
|
Annotated Notes - Lecture 4 ,5,6- Indexing - Ordered Indexes
(177 pages)
|
|
|
|
Lecture 7 - Secondary Index
136:00
|
|
|
|
Lecture 8 - Practice Questions on Indexes
104:00
|
|
|
|
Annotated Notes - Lecture 7,8 - Secondary Index
(191 pages)
|
|
|
|
Lecture 9 - Multilevel Index & ISAM
147:00
|
|
|
|
Lecture 10 - GATE Questions on Indexing
76:00
|
|
|
|
Annotated Notes - Lecture 9,10 - Multilevel Index & ISAM
(134 pages)
|
|
|
|
Lecture 11 - B Tree
117:00
|
|
|
|
Lecture 12 - B Tree Insertion
144:00
|
|
|
|
Lecture 13 - B Tree Order Questions
70:00
|
|
|
|
Lecture 14 - B Tree Structure Questions
81:00
|
|
|
|
Lecture 15 - B Tree More Questions
34:00
|
|
|
|
Annotated Notes - Lecture 11-15 - B Tree
(287 pages)
|
|
|
|
Lecture 16 - B+ Tree
59:00
|
|
|
|
Annotated Notes - Lecture 16 - B+ Tree
(52 pages)
|
|
|
|
Lecture 17 - B+ Tree Range Search
97:00
|
|
|
|
Lecture 18 - B+ Tree Insertion
52:00
|
|
|
|
Lecture 19 - B+ Tree Questions
125:00
|
|
|
|
Annotated Notes - Lecture 17-19 - B+ Tree
(219 pages)
|
|
|
Module 7 - ER Model
|
|
|
|
Lecture 1 - ER Model
182:00
|
|
|
|
Lecture 2 - Weak Entity Set in ER Model
103:00
|
|
|
|
Annotated Notes - Lecture 1,2 - ER Model
(216 pages)
|
|
|
|
Lecture 3 - ER Model to Relational Model Conversion
258:00
|
|
|
|
Annotated Notes - Lecture 3 - ER Model
(251 pages)
|
|
|
Toppers' Hand Written Notes
|
|
|
|
Handwritten Notes by Karan Agrawal (AIR 102 GATE CS 2024) - Databases
|
|
|
|
Notes by Quantum City (AIR 107, GATE CS 2024, Shreyas Rathod) - DBMS Notes
(79 pages)
|
|