Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Saturday, April 9, 2022

Syllabus Database Management - In Hindi & English


  1.  DBMS Introduction
  2. Types of DataBase
    1. Centralized Database
    2. Distributed 
    3. NO SQL
    4. Cloud Database
    5. Relational Database
    6. Network Database
    7. Object-Oriented Database
    8. Hierarchical Database
  3. RDMS vs DBMS
  4. DBMS Architecture
  5. Three Schema Architecture
  6. DBMS Language
  7. ER - Model
  8. Mapping Constraints
  9. DBMS Key
  10. DBMS Generalization
  11. DBMS Specialization
  12. DBMS  Aggregation
  13. Relational Data Model
  14. Relational Algebra
  15. Join Operation
  16. Integrity Constrains
  17. Normalization ( 1NF, 2NF, 3NF, BCNF, 4NF, 5NF)
  18. Transaction Processing
  19. Log Based Recovery
  20. Concurrency Control
  21. Lock Based Protocol
  22. Time Stamping Protocol
  23. Validation Based Protocol
  24. Thomas write Rule
  25. File Organization
  26. Sequential File Organization
  27. Heap File Organization
  28. Hash File Organization
  29. B+ File organisation
  30. Indexing B+ Tree
  31. Hashing 
  32. RAID