|
Introduction to DBMS & Relational Model
|
|
|
|
Lecture 1: Intro to DBMS & Relational Model
|
|
|
|
Lecture 2: Keys of a Relation
|
|
|
|
Lecture 3: DDL & DML Commands in SQL
|
|
|
|
Lecture 4: Relational Integrity Constraints Part-1
|
|
|
|
Lecture 5: Enforcing Referential Integrity Part-2
|
|
|
|
Lecture 6: Functional Dependency
|
|
|
|
Lecture 7: Inference Rules for FDs & Closure
|
|
|
|
Lecture 8: Computing Candidate keys Using Closure
|
|
|
|
Lecture 9: Cover & Equivalence of FD Sets
|
|
|
|
Lecture 10: Normal Forms Part-1
|
|
|
|
Lecture 11: Normal Forms Part-2
|
|
|
|
Lecture 12: Normal Forms Part-3
|
|
|
|
Lecture 13: GATE PYQs on Normal Forms
|
|
|
|
Lecture 14: Normalization Part-1
|
|
|
|
Lecture 15: Normalization Part-2
|
|
|
|
Lecture 16: Normalization Part-3
|
|
|
|
Lecture 17: Normalization Part-4
|
|
|
|
Lecture 18: Normalization Part-5
|
|
|
|
Lecture 19: Normalization Part-6
|
|
|
Relational Algebra
|
|
|
|
Lecture 1: Intro to Relational Algebra - Select & Project Operators
|
|
|
|
Lecture 2: Relational Algebra - Set Operators, Cross Product, etc
|
|
|
|
Lecture 3: Join Operations
|
|
|
|
Lecture 4: Division Operation in RA
|
|
|
|
Lecture 5: Outer Join Operation
|
|
|
|
Lecture 6: Practice Session on Relational Algebra
|
|
|
|
Lecture 7: GATE PYQs on Relational Algebra
|
|
|
Relational Calculus
|
|
|
|
Lecture 1: Tuple Relational Calculus Part-1
|
|
|
|
Lecture 2: TRC Part-2
|
|
|
|
Lecture 3: Practice Session on TRC
|
|
|
|
Lecture 4: GATE PYQs on TRC
|
|
|
SQL
|
|
|
|
Lecture 1: Intro to SQL
|
|
|
|
Lecture 2: Practice on Basic SQL Queries | Set Operations in SQL
|
|
|
|
Lecture 3: Practice on Set Operations in SQL
|
|
|
|
Lecture 4: Aggregate Functions
|
|
|
|
Lecture 5: Group By, Having and Order By Clause
|
|
|
|
Lecture 5_a: Views & Join in SQL
|
|
|
|
Lecture 6: Nested Subqueries Part-1
|
|
|
|
Lecture 7: Nested Queries Part-2
|
|
|
|
Lecture_7
(57 pages)
|
|
|
|
Lecture 8: SQL GATE PYQs
|
|
|
|
Lecture_8
(42 pages)
|
|
|
File Organization & Indexing
|
|
|
|
Lecture 1: File Organization
|
|
|
|
Lecture_1:
(69 pages)
|
|
|
|
Lecture 2: Indexing Part-1
|
|
|
|
Lecture_2
(52 pages)
|
|
|
|
Lecture 3: Indexing Part-2
|
|
|
|
Lecture_3
(58 pages)
|
|
|
|
Lecture 4: Indexing Part-3
|
|
|
|
Lecture_4
(50 pages)
|
|
|
|
Lecture 5: Indexing Part-4 || Tree Based Indexing
|
|
|
|
Lecture_5
(46 pages)
|
|
|
|
Lecture 6: Indexing Part-5
|
|
|
|
Lecture_6
(31 pages)
|
|
|
|
Lecture 7: Indexing Part-6
|
|
|
|
Lecture_7_FOI
(46 pages)
|
|
|
|
Lecture 8: Indexing Part-7
|
|
|
|
Lecture_8_FOI
(33 pages)
|
|
|
|
Lecture 9: Indexing Part-8
|
|
|
|
Lecture_9
(37 pages)
|
|
|
|
Lecture 10: Indexing Part-9
|
|
|
|
Lecture_10
(43 pages)
|
|
|
ER Model
|
|
|
|
Lecture 1: ER Model Part-1
|
|
|
|
Lecture_1_ER
(88 pages)
|
|
|
|
Lecture 2: ER Model Part-2
|
|
|
|
Lecture_2_ER
(43 pages)
|
|
|
|
Lecture 3: ER Model Part-3
|
|
|
|
Lecture_3_ER
(84 pages)
|
|
Launch your Graphy