- Introduction to Database
- Introduction to DBMS
- Advantages and Disadvantages of DBMS
- SQL | DDL, DML, DCL Commands
- Domain
- Entity and Attribute
- Relationship among entities
- Attribute
- DBMS Keys
- Schema
- Twelve rules of CODD
- Normalization
- Functional Dependency
- Transaction processing concepts
- Schedules
- Serializability
- OODBMS vs RDBMS
- RDBMS
- SQL Join
- SQL Functions
- Trigger
- Oracle cursor
- Introduction to Concurrency control
DBMS PYQs Hindi Videos
- 01 What is DBMS, data, database, characteristics, advantages, disadvantages in Hindi video
- 02 RDBMS in Hindi video
- 03 DBMS System Architecture in Hindi video
- 04 DBMS VS RDBMS in Hindi video
- 05 DBMS Users classification in Hindi video
- 06 Domain Tuple Attribute in Hindi video
- 07 Data Independence in Hindi video
- 08 Schema in Hindi video
- 09 Relational Data Model in Hindi video
- 10 Hierarchical Data Model in Hindi video
- 11 Integrity Constraints in Hindi video
- 12 Domain of Database | Create domain in Hindi video
- 13 Codd Rules in Hindi video
- 14 Theta join (Hindi) | Inner join in Hindi video
- 15 Natural join in Hindi video
- 16 Left outer join in Hindi video
- 17 Right outer join in Hindi video
- 18 Full outer join in Hindi video
- 19 1 NF | First Normalisation in Hindi video
- 20 2NF | Second Normal Form | Normalization in Hindi video
- 21 3NF | Third Normal Form | Normalization in Hindi video
- 22 Functional dependency in Hindi video
- 23 Relation and its characterstics in Hindi video
- 24 Number of possible Super keys in Hindi video
- 25 DBMS Concurrency control | Problems in Concurrency control | Lost update Dirty Unrepeatable in Hindi video
- 26 Serializability in DBMS | Conflict serializability | View serializability | Examples in Hindi video
- 27 DBMS Transaction processing system | States | Properties | ACID | Operations Example in Hindi video
- 28 DBMS Schedule | Definition | Types | Serial schedule | Non serial schedule | Example in Hindi video
- 29 Lock based concurrency protocol in DBMS | Simplistic | Pre claiming | Two phase | Strict two phase in Hindi video
- 30 Time stamp protocol in DBMS| Concurrency control protocol | advantages | disadvantages in Hindi video
- 31 Validation based protocol in DBMS | Concurrency control protocol | read validation write phase in Hindi video
- 32 Multiple granularity in Hindi video
- 33 ER model | ER model to table to ER model | Relationship | Entity | Attribute in Hindi video
- 34 Types of attributes in ER diagrams | key, simple, composite, single, multivalued, derived, examples in Hindi video
- 35 Cardinality in ER Diagram | symbols | example |1 to 1 | 1 to many | many to many | many to 1 in Hindi video
- 36 ER diagram symbols | for entity, attribute, relationship, participation constraints, cardinality in Hindi video
- 37 ER diagrams to tables | composite, simple, multiuvalued, relationship, cardinality to tables in Hindi video
- 38 Participation constraints in DBMS | total and partial participation, examples, relation in Hindi video
- 39 Constraints in DBMS | Key, domain, entity integrity, referential integrity, tuple uniqueness,example in Hindi video
- 40 Closure in DBMS | steps to find closure in attribute set in Hindi video