DBMS Tutorial (Database Management System)

  1. Introduction to DBMS:
    • What is Database
    • Types of Databases
  2. RDBMS (Relational Database Management System):
    • What is RDBMS
    • DBMS vs RDBMS
    • DBMS vs File System
  3. DBMS Architecture:
    • Three Schema Architecture
  4. Data Models:
    • Data Model Schema
    • Data Independence
  5. DBMS Language:
    • ACID Properties in DBMS
  6. Data Modeling:
    • ER Model Concept
    • Notation for ER Diagram
    • ER Design Issues
    • Mapping Constraints
  7. DBMS Keys:
    • Generalization
    • Specialization
    • Aggregation
    • Convert ER into Table
    • Relationship of Higher Degree
  8. Relational Data Model:
    • Relational Model Concept
    • Relational Algebra
    • Join Operation
    • Integrity Constraints
    • Relational Calculus
  9. Normalization:
    • Functional Dependency
    • Inference Rule
    • DBMS Normalization (1NF, 2NF, 3NF, BCNF, 4NF, 5NF)
    • Relational Decomposition
    • Multivalued Dependency
    • Join Dependency
    • Inclusion Dependence
    • Canonical Cover
  10. Transaction Processing:
    • Transaction
    • Transaction Property
    • States of Transaction
    • DBMS Schedule
    • Testing of Serializability
    • Conflict Schedule
    • View Serializability
    • Recoverability of Schedule
    • Failure Classification
    • Log-Based Recovery
    • DBMS Checkpoint
    • Deadlock in DBMS
  11. Concurrency Control:
    • Concurrency Control
    • Lock-Based Protocol
    • Time Stamping Protocol
    • Validation-Based Protocol
    • Thomas Write Rule
    • Multiple Granularity
    • Recovery Concurrent Transaction
  12. File Organization:
    • Sequential File Organization
    • Heap File Organization
    • Hash File Organization
    • B+ File Organization
    • DBMS ISAM
    • Cluster File Organization
  13. Indexing and B+ Tree:
    • Indexing in DBMS
    • B+ Tree
  14. Hashing:
    • Hashing
    • Static Hashing
    • Dynamic Hashing
  15. RAID:
    • RAID
  16. Miscellaneous:
    • Decomposition Algorithms
    • Storage System in DBMS
    • Data Dictionary Storage
    • File Organization Storage
    • Selection of RAID Levels
    • Bitmap Indexing
    • Buffer Replacement Strategies
    • Database Buffer
    • Estimating Query Cost
    • Query Processing in DBMS
    • Evaluation of Expressions
    • External Sort-Merge Algorithm
    • Hash Join Algorithm
    • Materialization in Query Processing
    • Merge Join Algorithm
    • Nested-Loop Join Algorithm
    • Selection Operation in Query Processing
    • Double-Pipelined Join Algorithm
    • Implementation of Pipelining
    • Pipelining in Query Processing
    • Advanced Query Optimization
    • Transforming Relational Expressions
    • Candidate Key
    • Closure of an Attribute
    • QUESTIONS ON BOYCE CODD NORMAL FORM
    • QUESTIONS ON NORMALIZATION
    • QUESTIONS ON THIRD NORMAL FORM
    • EQUIVALENCE OF FUNCTIONAL DEPENDENCY
    • Referential Integrity Constraint
    • Questions on Lossy and Lossless Decomposition
    • LOSSY OR LOSSLESS DECOMPOSITION (second method)
    • QUESTIONS TO IDENTIFY NORMAL FORM

SQL Introduction

  1. SQL Introduction:
    • SQL Introduction
    • Characteristics of SQL
    • Advantage of SQL
  2. SQL Datatype:
    • SQL Datatype
  3. SQL Command:
    • SQL Command
  4. SQL Operator:
    • SQL Operator
  5. SQL Table:
    • SQL Table
  6. SQL SELECT Statement:
    • SQL SELECT Statement
  7. SQL INSERT Statement:
    • SQL INSERT Statement
  8. SQL UPDATE Statement:
    • SQL UPDATE Statement
  9. SQL DELETE Statement:
    • SQL DELETE Statement
  10. SQL View:
    • SQL View
  11. SQL Index:
    • SQL Index
  12. SQL Sub Queries:
    • SQL Sub Queries
  13. SQL Clauses:
    • SQL Clauses
  14. SQL Aggregate Function:
    • SQL Aggregate Function
  15. SQL JOIN:
    • SQL JOIN
  16. SQL Set Operation:
    • SQL Set Operation

DBMS MCQ

  • DBMS MCQ

Interview Questions

  • DBMS Interview
  • SQL Interview