Course module
IT Mains: DBMS — ICAR Technical Assistant (IT) 2026 – Prelims + Mains
Explore the module outline and lessons below. Enroll free to begin studying here.
Return to /learn/ASRB-ICAR-T3-T4-INFORMATION-TECHNOLOGY-PRELIMS-MAINS/database-management-systemdbms after enrolling
- Lessons
- 276
- Duration
- 22 hr 11 min
- PYQs
- 0
- Practice
- 1210
Exam importance: 0% of the exam, based on section capacity, PYQ history and paper recency. Low confidence: historical evidence or paper dates are incomplete.
Syllabus index
Lessons in this module
Basics of DBMS
DBMS Fundamentals
Types & DBA Functions
Data Model, Architecture & Components
FoxPro
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
- Functional Dependencies & AxiomsPdf
- What Is Functional DependencyDrm Video
- Understanding Functional Dependency FurtherDrm Video
- What Is Trivial Functional DependencyDrm Video
- Practice Questions Functional DependencyDrm Video
- Understanding Armstong Axioms notesPdf
- Understanding Armstrong's AxiomsDrm Video
- Gate 2000Drm Video
Attribute Closure & Equivalence of Sets
- Attribute Closure & Equivalence of SetsPdf
- Closure Set of AttributesDrm Video
- Practice Questions Functional DependencyDrm Video
- Comparing Two Set Of Functional DependenciesDrm Video
- Practice QuestionsDrm Video
- Practice Questions on Functional DependenciesDrm Video
- Practice Questions Functional DependencyDrm Video
Minimal Cover (Canonical Cover)
Keys & Integrity Constraints
Super Key, Candidate Key & Primary Key
Foreign Key & Referential Integrity
Composite & Alternate Keys
Normalization (1NF - BCNF)
Codd’s 12 Rules
Introduction to Normalization & 1NF
Second Normal Form (2NF)
Third Normal Form (3NF)
Decomposition Properties & 4NF
Multivalued Dependency (MVD) & 4NF
Fifth Normal Form (5NF)
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
Nested & Correlated Subqueries
Views & PLSQL Basics
Relational Calculus
Tuple Relational Calculus (TRC)
Domain Relational Calculus (DRC)
Safety of Expressions & Power
Transaction Management
Introduction & ACID Properties
Transaction States
Concurrency Problems
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 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
Big Data Systems
Introduction and Characteristics of Big Data
Big Data Architecture
Hadoop Framework Overview
Hadoop Distributed File System (HDFS)
Database Security & Authorization
Introduction to Database Security
Mandatory Access Control (MAC)
Role-Based Access Control (RBAC)
Enhanced Data Models
Distributed Databases
NoSQL
Introduction and Need for NoSQL Databases
Characteristics of NoSQL
Types of NoSQL Databases
NoSQL in Cloud and Distributed Environments
Explore the course
- Prelims: General Knowledge
- Prelims: General English
- Prelims: Quantitative Aptitude
- Prelims: General Agriculture
- IT Mains: Operating System
- IT Mains: Computer Networking
- IT Mains: Software Engineering
- IT Mains: Data Structures & Algorithms
- IT Mains: OOPS with C++ & Java
- IT Mains: Python
- IT Mains: Website Development
- IT Mains: Mobile App Development
- IT Mains: Linux / Windows Server Admin

