-
Preview
-
Database System Structure and Database Design
-
ER Model
-
ER Model
-
Additional Features of ER Model
-
Conceptual Design with ER Model
-
Introduction to Relational Model Part-I
-
Introduction to Relational Model Part-II
-
Logical Database Design Part-I
-
Logical Database Design Part-II
-
Introduction to Views
-
Relational Algebra & Calculus Part-I
-
Relational Algebra & Calculus Part-II
-
Introduction to Joins
-
Structured Query Language (SQL: Part-I)
-
Structured Query Language(SQL: Part-I)Continued..
-
Structured Query Language (SQL: Part-2)
-
Aggregate Operators & Null Values
-
Complaints Integrity Constraints in SQL
-
Triggers And Active Databases
-
Schema Refinement
-
Concept of Functional Dependency
-
Reasoning About Functional Dependencies
-
Finding the Keys Using Closure
-
Normalization Part-1
-
Normalization Part-1 Continues
-
Normalization Part-2
-
Normalization Part-3
-
Transaction Concept
-
Transaction Concept Part-2
-
Concurrent Executions & Serializability Part 1
-
Concurrent Executions & Serializability Part 2
-
Concurrent Executions& Serializability Conclusion
-
Schedules In DBMS
-
Isolation and It's Levels & Testing Serializability
-
Lock Based Protocols
-
Two - Phase Locking Protocol
-
Time Stamp Based Protocols
-
Validation Based Protocol & Multiple Granularity
-
Recovery & Atomicity And Log Based Recovery
-
Data on External Storage
-
Types of File Organizations (Heap & Hash File)
-
Dynamic Hashing
-
B+ Tree File Organization & Clustered File Organization
-
INDEXING
-
INDEX DS & Comparison of file Organization
-
INTUITIONS FOR TREE INDEXES
-
ISAM WITH EXAMPLE
-
B+Tress A Dynamic Index Structure - Insertion
-
B+ Trees A Dynamic Index Structure - Deletion
-
DDL& DML Commands (Practical Executions)
-
DDL& DML Commands Contd..(Practical Executions)
-
DDL& DML Command With Primary &Foreign Keys (Practical Executions)
-
Triggers (Practical Executions)
-
Selection Queries(Practical Executions)
-
Aggregate Functions (Practical Executions)
