Course module

Section B: Data Base Management System — DSSSB TGT Computer Science 2026 — Section A + Section B

Explore the module outline and lessons below. Enroll free to begin studying here.

Lessons: 264
Duration: 21 hr 54 min
PYQs: 427
Practice: 72

Exam importance: 4.9% of the exam, based on section capacity, PYQ history and paper recency.

Syllabus index

Lessons in this module

264 linked lessons

DSSSB - Unit Test - Database Management SystemTest

Previous-year questions

Explore the course

Lessons in this module

Basics of DBMS

DBMS Fundamentals

Types & DBA Functions

Data Model, Architecture & Components

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)

Boyce-Codd Normal Form (BCNF)

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

Division Operator

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

Nested & Correlated Subqueries

File Organization & Indexing

Basics & Types of Indexing

B-Trees & B+ Trees (Structure & Insertion)

Deletion in B-Trees & B+ Trees

Transaction Management

Introduction & ACID Properties

Transaction States

Schedules & Conflict Serializability

View 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

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

Advanced Data Mining Methods

Module lessons

Lessons

Previous-year questions

Explore the course