Course module
Database Management Systems — Bihar Polytechnic Lecturer (Computer Science)
Explore the module outline and lessons below. Enroll free to begin studying here.
Return to /learn/BIHAR-POLYTECHNIC-LECTURER-COMPUTER-SCIENCE/paper-1-database-management-systems after enrolling
- Lessons
- 250
- Duration
- 18 hr 18 min
- PYQs
- 0
- Practice
- 514
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
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
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
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
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)
ORDBMS
Concepts and Features of Object-Relational Databases
ORDBMS - Introduction
NoSQL
Introduction and Need for NoSQL Databases
Characteristics of NoSQL
Types of NoSQL Databases
Query Optimization and Aggregation Framework
NoSQL in Cloud and Distributed Environments
Explore the course
- Discrete Mathematics
- Digital Logic
- Computer Organization and Architecture
- Programming
- Data Structures
- Algorithms
- Theory of Computation
- Compiler Design
- Operating Systems
- Computer Networks