Course module
Paper-2 | Database Management System — RSSB (Basic Computer Instructor)
- Lessons
- 161
- Duration
- 12 hr 8 min
- PYQs
- 355
- Practice
- 435
5% 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
Relational Calculus
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
NoSQL
Introduction and Need for NoSQL Databases
Characteristics of NoSQL
Types of NoSQL Databases
Module lessons
Previous-year questions
PYQ collectionPYQ Questions28 questionsPYQ collectionPYQ Questions10 questionsPYQ collectionPYQ Questions8 questionsPYQ collectionPYQ Questions46 questionsPYQ collectionPYQ Questions17 questionsPYQ collectionPYQ Questions7 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions25 questionsPYQ collectionPYQ Questions16 questionsPYQ collectionPYQ Questions5 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions22 questionsPYQ collectionPYQ Questions26 questionsPYQ collectionPYQ Questions16 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions43 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions5 questionsPYQ collectionPYQ Questions17 questionsPYQ collectionPYQ Questions2 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions7 questionsPYQ collectionPYQ Questions8 questionsPYQ collectionPYQ Questions5 questionsPYQ collectionPYQ Questions23 questionsPYQ collectionPYQ Questions5 questionsPYQ collectionPYQ Questions19 questionsPYQ collectionPYQ Questions14 questionsPYQ collectionPYQ Questions58 questionsPYQ collectionPYQ Questions5 questionsPYQ collectionPYQ Questions38 questionsPYQ collectionPYQ Questions5 questionsPYQ collectionPYQ Questions8 questionsPYQ collectionPYQ Questions15 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions171 questionsPYQ collectionPYQ Questions1 questionsPYQ collectionPYQ Questions3 questionsPYQ collectionPYQ Questions4 questionsPYQ collectionPYQ Questions355 questions
Explore the course
- About the Course
- Paper-1 & 2 | Basic Numeracy
- Paper-1 & 2 | Data Interpretation
- Paper-1 & 2 | General Mental Ability
- Paper-1 & 2 | Logical Reasoning and Analytical Ability
- Paper-1 & 2 | Decision Making and Problem Solving
- Paper-1 | General Science
- Paper-1 | General Awareness
- Paper - 2 | Digital Logic Systems
- Paper-2 | Data Structures & Algorithms
- Paper 2 | Data Communication and Network Security
- Paper-2 | Operating Systems
- Paper-2 | Computer Organization and Architecture
- Paper 2 | System Analysis and Design
- Paper-2 | C Programming
- Paper 2 | OOPS , C++ , JAVA
- Paper 2 | Python
- Emerging Trends and AI
- Paper-2 | Data Processing (Ms-Office)
- Paper-2 | Internet and Web Technologies
- Paper 2 | Pedagogy
- Live Classes
- Paper 1 - Full Mock Tests
- Paper 2 - Full Mock Tests
- BCI Previous Year Papers
Loading lesson…