DBMS

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
Sign Up Page
oops

Login to see solution/discussion