Course module
Part 3 | Database Management System — BPSC TRE 4.0
- Lessons
- 229
- Duration
- 17 hr 3 min
- PYQs
- 242
- Practice
- 1026
4% of this course's PYQ weight is covered in this module.
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
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)
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
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)
Relational Algebra
Introduction to Query Languages
Unary Operators (Selection & Projection)
Set Operations & Cartesian Product
Join Operations (Inner & Outer)
Rename Operation
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
Recoverability, Cascadeless & Strict Schedules
Concurrency Control
Introduction to Concurrency Control
Lock-Based Protocols & Basic 2PL
Variations of 2PL (Strict, Rigorous, Conservative)
Module lessons
Lessons
Previous-year questions
PYQ collectionPYQ Questions21 questionsPYQ collectionPYQ Questions6 questionsPYQ collectionPYQ Questions7 questionsPYQ collectionPYQ Questions34 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions6 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions11 questionsPYQ collectionPYQ Questions7 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions13 questionsPYQ collectionPYQ Questions17 questionsPYQ collectionPYQ Questions10 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions28 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions10 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions16 questionsPYQ collectionPYQ Questions6 questionsPYQ collectionPYQ Questions41 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions30 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions5 questionsPYQ collectionPYQ Questions14 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions122 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions7 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions7 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions242 questions
Explore the course
- About the Course
- Part 1 | Language (English)
- Part 1 | Language (Hindi)
- Part 2 | Primary Maths & Reasoning
- Part 2 | General Awareness (GK + Current Affairs)
- Part 3 | Computer System and Org. (CSO)
- Part 3 | Operating System
- Part 3 | Computer Networks
- Part 3 | Data Structures
- Part 3 | Theory Of Computation & Compiler Design
- Part 3 | Emerging Trends (AI, Societal Ethics & MS Office)
- Part 3 | Software Engineering
- Part 3 | Programming Concepts (C Programming)
- Part 3 | Programming Concepts (OOPS, C++, JAVA, HTML)
- Part 3 | Programming Concepts (Python)
- Part 3 | Digital Electronics
- BPSC Full Mock Tests
Loading lesson…