Course module

Paper 1 | DBMS — RPSC Programmer – Paper 1 + Paper 2

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

Lessons: 249
Duration: 19 hr 56 min
PYQs: 104
Practice: 1098

22% of this course's PYQ weight is covered in this module.

Syllabus index

Lessons in this module

249 linked lessons

Previous-year questions

Explore the course

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

Attribute Closure & Equivalence of Sets

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)

Boyce-Codd Normal Form (BCNF)

Decomposition Properties & 4NF

Multivalued Dependency (MVD) & 4NF

Fifth Normal Form (5NF)

Lossless Join Decomposition

Dependency Preserving Decomposition

File Organization & Indexing

Basics & Types of Indexing

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

Deletion in B-Trees & B+ Trees

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

Views & PLSQL Basics

Transaction Management

Introduction & ACID Properties

Transaction States

Concurrency Problems

Schedules & Conflict Serializability

View Serializability

Recoverability, Cascadeless & Strict Schedules

Concurrency Control

Introduction to Concurrency Control

Timestamp Ordering Protocols

Lock-Based Protocols & Basic 2PL

Variations of 2PL (Strict, Rigorous, Conservative)

Relational Calculus

Safety of Expressions & Power

Database Security & Authorization

Introduction to Database Security

Database Recovery

Failure Types & Recovery Fundamentals

Previous-year questions

Explore the course