INDEX
- Introduction to DBMS Basic Concept
- Advantages and Disadvantage of DBMS
- Architecture of DBMS
- Concurrency Control
- Concurrency Control – Lock Based Protocol in DBMS Transaction
- Timestamp Based Protocol
- Entity Relationship Modelling with solved example
- Extended Entity Relationship Model with solved example
- Database Administrator Manager Storage Manager
- Deadlock Full concept in DBMS transaction management
- Shadow Paging in Database Recovery
- Log Based Database Recovery
- Shadow Copy Technique in Database recovery
- Introduction to SQL
- Data definition language
- DML ( data manipulation language )
- DRL ( Data Retrieval Language)
- Aggregate Function in SQL
- SQL Inner Joins & Left join
- SQL Right Join & Full Join
- DBMS Importance with complete strategy for Mumbai Universality
- Normalization and first normal form 1NF
- Second Normal Form 2NF example
- Third Normal Form 3NF with example
- BCNF | Boyce Cod Normal Form | with example
- Transaction State and Acid Properties
- Types of Joins in SQL
No comments:
Post a Comment