Course module
Data Base Management System — DSSSB TGT Computer Science 2026 Section B
Explore the module outline and lessons below. Enroll free to begin studying here.
Return to /learn/DSSSB-TGT-COMPUTER-SCIENCE-PAPER-2/data-base-management-system after enrolling
- Lessons
- 264
- Duration
- 21 hr 54 min
- PYQs
- 215
- Practice
- 260
Exam importance: 8.9% of the exam, based on section capacity, PYQ history and paper recency.
Syllabus index
Lessons in this module
Basics of DBMS
DBMS Fundamentals
Types & DBA Functions
ER Diagram
ER Modeling Fundamentals
Cardinalities, Participation & Entity Strength
Conversion of ER Diagram into Relational Model
Relational Model & Functional Dependencies
Basics of Relational Model & Anomalies
Functional Dependencies & Axioms
Keys & Integrity Constraints
Super Key, Candidate Key & Primary Key
Foreign Key & Referential Integrity
Composite & Alternate Keys
Normalization (1NF - BCNF)
Introduction to Normalization & 1NF
Second Normal Form (2NF)
Third Normal Form (3NF)
Decomposition Properties & 4NF
Multivalued Dependency (MVD) & 4NF
Lossless Join Decomposition
Dependency Preserving Decomposition
Relational Algebra
Introduction to Query Languages
Unary Operators (Selection & Projection)
Set Operations & Cartesian Product
Join Operations (Inner & Outer)
Rename Operation
SQL
Introduction, Components & Structure
Select, Where, Distinct
Datatypes, Operators & Null
DDL, DML, DCL, TCL & Desc
Order By & Rename Operation (Alias)
Library Functions (Math, Aggregate, String, Date)
Set Operations & Cartesian Product
Join Operations (Inner & Outer)
Group By Clause
File Organization & Indexing
Basics & Types of Indexing
- Basics & Types of IndexingPdf
- BackGround of IndexingDrm Video
- What is IndexingDrm Video
- Practice Question - Primary IndexingDrm Video
- Practice Question - Primary Indexing Cont...Drm Video
- Important Terminology of IndexingDrm Video
- Primary IndexingDrm Video
- Clustered IndexingDrm Video
- Practice Question - Clustered IndexingDrm Video
- Secondary IndexingDrm Video
- Practice question on secondary indexingDrm Video
- Multilevel Indexing notesPdf
- Multilevel indexingDrm Video
B-Trees & B+ Trees (Structure & Insertion)
Transaction Management
Introduction & ACID Properties
Transaction States
Schedules & Conflict Serializability
Concurrency Control
Introduction to Concurrency Control
Timestamp Ordering Protocols
Lock-Based Protocols & Basic 2PL
Variations of 2PL (Strict, Rigorous, Conservative)
Database Security & Authorization
Introduction to Database Security
Mandatory Access Control (MAC)
Role-Based Access Control (RBAC)
Database Recovery
Failure Types & Recovery Fundamentals
Log-Based Recovery Techniques
Advanced Recovery Algorithms
- Advanced Recovery AlgorithmsPdf
- Checkpoints & Shadow PagingDrm Video
- Deferred UpdateDrm Video
- Example (Deferred Approach)Drm Video
- Immediate UpdateDrm Video
- Example (Immediate Approach)Drm Video
- Example (Immediate DB Update)Drm Video
- ARIES Recovery Algorithm - Part 1Drm Video
- ARIES Recovery Algorithm - Part 2Drm Video
Data Warehousing & Mining
Introduction to Data Mining and Data Warehouse
Data Warehousing
Data Mining Functionalities
Data Modelling in Warehouses
Data Mining Techniques
OLAP vs OLTP - Concept & Details
Module lessons
Previous-year questions
PYQ collectionPYQ Questions21 questionsPYQ collectionPYQ Questions11 questionsPYQ collectionPYQ Questions8 questionsPYQ collectionPYQ Questions40 questionsPYQ collectionPYQ Questions17 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions22 questionsPYQ collectionPYQ Questions10 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions12 questionsPYQ collectionPYQ Questions14 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions19 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions10 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions11 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions7 questionsPYQ collectionPYQ Questions8 questionsPYQ collectionPYQ Questions19 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions15 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions6 questionsPYQ collectionPYQ Questions5 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions70 questionsPYQ collectionPYQ Questions7 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions8 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions6 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions5 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions13 questionsPYQ collectionPYQ Questions215 questions
Explore the course
- About Course
- Programming, Data Structures, OOP & Java
- Computer Networks, TCP/IP & Network Security
- Teaching Methodology
- Digital Electronics / Boolean Logic
- Operating Systems & Linux
- Internet & Web Technologies
- Computer Fundamentals, IT Basics & Architecture
- Python Language
- Software Engineering
- Design & Analysis of Algorithms
- Mathematics - I, II, III, IV
- Computer Graphics, Multimedia & Mobile Computing
- Emerging Trends
- Statistical Techniques
- Interpolation - DI
- Basis of Physics
- Previous Year Paper
- Business Studies and Management