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