| S.No | Title | Viewer Link |
|---|---|---|
| 1 | Introduction on Database management systems | Click To Watch Video |
| 2 | Data model in DBMS | Click To Watch Video |
| 3 | Three levels of abstraction in DBMS | Click To Watch Video |
| 4 | Introduction on ER diagrams | Click To Watch Video |
| 5 | Types of attributes in Entity Relationship diagram | Click To Watch Video |
| 6 | Example 1 on Entity diagram construction | Click To Watch Video |
| 7 | Example 2 on ER (Entity relationship) diagram construction | Click To Watch Video |
| 8 | Example 3 on ER diagram for Many to Many diagram | Click To Watch Video |
| 9 | Strong Entity and Weak entity in DBMS | Click To Watch Video |
| 10 | Lecture 1 on conversion of Entity relationship diagram to relational model | Click To Watch Video |
| 11 | Lecture 2 on Conversion of ER diagram (one to one relation) to a Relational model | Click To Watch Video |
| 12 | Lecture 3 on conversion of Entity relationship diagram (Many to one) to relational model. | Click To Watch Video |
| 13 | Lecture 4 on conversion of ER diagram (Many to many relation) to relational model. | Click To Watch Video |
| 14 | Lecture 5 on conversion of ER diagram (identifying relationship) to relational model. | Click To Watch Video |
| 15 | GATE 2020 question on ER diagram | Click To Watch Video |
| 16 | Introduction on Relational algebra in DBMS | Click To Watch Video |
| 17 | Selection operator in Relational algebra | Click To Watch Video |
| 18 | Projection operator in Relational Algebra | Click To Watch Video |
| 19 | Set union, Intersection, and difference in Relational algebra | Click To Watch Video |
| 20 | Rename operator in relational algebra | Click To Watch Video |
| 21 | GATE 2014 question on Relational Algebra | Click To Watch Video |
| 22 | Cross product in relational algebra | Click To Watch Video |
| 23 | Inner Join Operators in Relational Algebra | Click To Watch Video |
| 24 | Outer Join operators in relational algebra | Click To Watch Video |
| 25 | Division operator in relational algebra | Click To Watch Video |
| 26 | Lecture 1 on Examples for relational algebra in DBMS | Click To Watch Video |
| 27 | Lecture 2 on Examples for relational algebra in DBMS | Click To Watch Video |
| 28 | Lecture 3 on Examples for relational algebra in DBMS | Click To Watch Video |
| 29 | GATE 2019 QUESTION ON RELATIONAL ALGEBRA | Click To Watch Video |
| 30 | Introduction to Keys in DBMS | Click To Watch Video |
| 31 | Foreign Key in DBMS | Click To Watch Video |
| 32 | Introduction on normalization | Click To Watch Video |
| 33 | Introduction on functional dependency | Click To Watch Video |
| 34 | Examples on functional dependencies | Click To Watch Video |
| 35 | Gate 2000 question on functional dependency | Click To Watch Video |
| 36 | Types of functional dependencies | Click To Watch Video |
| 37 | Closure of an attribute set in DBMS | Click To Watch Video |
| 38 | GATE 2014 question on candidate key | Click To Watch Video |
| 39 | Steps in minimizing the functional dependencies | Click To Watch Video |
| 40 | Example 1 on minimizing Functional dependencies in DBMS | Click To Watch Video |
| 41 | Gate 2014 Question on Minimization of Functional dependencies | Click To Watch Video |
| 42 | Introduction on Equivalence of Functional Dependencies in DBMS. | Click To Watch Video |
| 43 | Example 1 on equivalence of Functional dependencies in DBMS | Click To Watch Video |
| 44 | Example 2 on equivalence of functional dependencies | Click To Watch Video |
| 45 | Introduction on Lossless Decomposition in DBMS | Click To Watch Video |
| 46 | Example 1 on Lossless Decomposition in DBMS | Click To Watch Video |
| 47 | Example 2 on Lossless Decomposition in DBMS | Click To Watch Video |
| 48 | Example 3 on Lossless decomposition in DBMS | Click To Watch Video |
| 49 | Introduction on functional dependency preserving in DBMS | Click To Watch Video |
| 50 | Example on functional dependency preserving in DBMS | Click To Watch Video |
| 51 | Types of Normal forms and 1NF | Click To Watch Video |
| 52 | Introduction on Second Normal Form | Click To Watch Video |
| 53 | Example 1 on 2NF | Click To Watch Video |
| 54 | GATE 2008 question on second normal form | Click To Watch Video |
| 55 | Introduction on third normal form | Click To Watch Video |
| 56 | Example 1 on third normal form | Click To Watch Video |
| 57 | Introduction on BCNF | Click To Watch Video |
| 58 | Example on BCNF | Click To Watch Video |
| 59 | Gate 2019 question on BCNF | Click To Watch Video |
| 60 | Examples on finding highest normal form | Click To Watch Video |
| 61 | Introduction to transaction management | Click To Watch Video |
| 62 | Gate 2016 question on ACID properties | Click To Watch Video |
| 63 | Various states of a transaction in DBMS | Click To Watch Video |
| 64 | Types of Schedules in transaction management | Click To Watch Video |
| 65 | Lost update problem and unrepeatable read problem | Click To Watch Video |
| 66 | Dirty read problem | Click To Watch Video |
| 67 | Cascading abort problem and cascadeless schedules | Click To Watch Video |
| 68 | Introduction on Strict schedule | Click To Watch Video |
| 69 | conflict operations | Click To Watch Video |
| 70 | Introduction on conflict equivalent schedules | Click To Watch Video |
| 71 | Example 2 on conflict equivalent schedules | Click To Watch Video |
| 72 | Gate 2020 question on conflict equivalent schedules | Click To Watch Video |
| 73 | Number of serial,concurrent schedules possible | Click To Watch Video |
| 74 | Introduction to conflict serializable schedules | Click To Watch Video |
| 75 | What is Precedence Graph | Click To Watch Video |
| 76 | Example 2 on precedence graph | Click To Watch Video |
| 77 | Example 3 on precedence graph | Click To Watch Video |
| 78 | Example 2 on conflict serializability | Click To Watch Video |
| 79 | Gate 2014 question on conflict Serializability | Click To Watch Video |
| 80 | Gate 2014 question on Conflict serializability and recoverable schedules | Click To Watch Video |
| 81 | View serializable in transaction management | Click To Watch Video |
| 82 | Examples on View serializable | Click To Watch Video |
| 83 | Introduction on concurrency control | Click To Watch Video |
| 84 | Introduction on basic two phase locking protocol | Click To Watch Video |
| 85 | Problems in two phase locking protocol or 2PL | Click To Watch Video |
| 86 | Variants in two phase locking protocol or 2PL | Click To Watch Video |
| 87 | Numerical questions on 2PL | Click To Watch Video |
| 88 | Introduction on Graph based protocol | Click To Watch Video |
| 89 | Example 1 on Graph based protocol | Click To Watch Video |
| 90 | Example 2 on Graph based protocol | Click To Watch Video |
| 91 | Time stamp based protocol in DBMS | Click To Watch Video |
| 92 | Example on time stamp ordering protocol. | Click To Watch Video |
| 93 | Introduction on Thomas write rule | Click To Watch Video |
| 94 | Thomas write rule 2 in DBMS | Click To Watch Video |
| 95 | Introduction to File management in DBMS | Click To Watch Video |
| 96 | Basics of Indexing | Click To Watch Video |
| 97 | Types of indexing in DBMS | Click To Watch Video |
| 98 | Introduction on Primary indexing | Click To Watch Video |
| 99 | Numerical question on primary indexing | Click To Watch Video |
| 100 | Clustered indexing in file management | Click To Watch Video |
| 101 | Gate 2013 question on clustered indexing | Click To Watch Video |
| 102 | Introduction on Secondary Indexing | Click To Watch Video |
| 103 | Numerical question on secondary indexing | Click To Watch Video |
| 104 | Introduction to B and B+trees | Click To Watch Video |
| 105 | Properties of B trees in DBMS | Click To Watch Video |
| 106 | Example on B tree properties | Click To Watch Video |
| 107 | Numerical question on order computation of a node in B tree. | Click To Watch Video |
| 108 | Steps for B tree Construction in DBMS | Click To Watch Video |
| 109 | Example 1 on B tree construction. | Click To Watch Video |
| 110 | Example 2 on B tree construction | Click To Watch Video |
| 111 | Steps in B tree deletion | Click To Watch Video |
| 112 | Example 1 on B tree deletion. | Click To Watch Video |
| 113 | Example 2 on B tree deletion in DBMS | Click To Watch Video |
| 114 | Various cases/scenarios in the deletion of elements from B tree. | Click To Watch Video |
| 115 | Introduction to B+ trees in DBMS | Click To Watch Video |
| 116 | Numerical question on B+tree order computation | Click To Watch Video |
| 117 | Gate 2017 question on B+tree order computation | Click To Watch Video |
| 118 | Properties of B+ trees in DBMS | Click To Watch Video |
| 119 | Steps for Inserting elements in B+trees | Click To Watch Video |
| 120 | Example 1 on B+ tree insertion in DBMS | Click To Watch Video |
| 121 | Example 2 on B+ tree insertion in DBMS | Click To Watch Video |
| 122 | Steps for Deleting elements in B+ trees | Click To Watch Video |
| 123 | Example 1 for deleting elements in B+tree | Click To Watch Video |
| 124 | Example 2 for deleting elements in B+ tree | Click To Watch Video |
Login to see solution/discussion