• DBMS - Home
• DBMS - Overview
• DBMS - Architecture
• DBMS - Data Models
• DBMS - Data Schemas
• DBMS - Data Independence
• DBMS - System Environment
• Centralized and Client/Server Architecture
• DBMS - Classification

• Relational Model
• DBMS - Codd's Rules
• DBMS - Relational Data Model
• DBMS - Relational Model Constraints
• DBMS - Relational Database Schemas
• DBMS - Handling Constraint Violations

• Entity Relationship Model
• DBMS - ER Model Basic Concepts
• DBMS - ER Diagram Representation
• Relationship Types and Relationship Sets
• DBMS - Weak Entity Types
• DBMS - Generalization, Aggregation
• DBMS - Drawing an ER Diagram
• DBMS - Enhanced ER Model
• Subclass, Superclass and Inheritance in EER
• Specialization and Generalization in Extended ER Model
• Data Abstraction and Knowledge Representation

• Relational Algebra
• DBMS - Relational Algebra
• Unary Relational Operation
• Set Theory Operations
• DBMS - Database Joins
• DBMS - Division Operation
• DBMS - ER to Relational Model
• Examples of Query in Relational Algebra

• Relational Calculus
• Tuple Relational Calculus
• Domain Relational Calculus

• Relational Database Design
• DBMS - Functional Dependency
• DBMS - Inference Rules
• DBMS - Minimal Cover
• Equivalence of Functional Dependency
• Finding Attribute Closure and Candidate Keys

• Relational Database Design
• DBMS - Keys
• Super keys and candidate keys
• DBMS - Foreign Key
• Finding Candidate Keys

• Normalization in Database Designing
• Database Normalization
• First Normal Form
• Second Normal Form
• Third Normal Form
• Boyce Codd Normal Form
• Difference Between 4NF and 5NF

• Structured Query Language
• Types of Languages in SQL
• Querying in SQL
• CRUD Operations in SQL
• Aggregation Function in SQL
• Join and Subquery in SQL
• Views in SQL
• Trigger and Schema Modification

• Storage and File Structure
• DBMS - Storage System
• DBMS - File Structure
• DBMS - Secondary Storage Devices
• DBMS - Buffer and Disk Blocks
• DBMS - Placing File Records on Disk
• DBMS - Ordered and Unordered Records

• Indexing and Hashing
• DBMS - Indexing
• DBMS - Single-Level Ordered Indexing
• DBMS - Multi-level Indexing
• Dynamic B- Tree and B+ Tree
• DBMS - Hashing

• Transaction and Concurrency
• DBMS - Transaction
• DBMS - Concurrency Control
• DBMS - Deadlock

• Backup and Recovery
• DBMS - Data Backup
• DBMS - Data Recovery

• DBMS Useful Resources
• DBMS - Quick Guide
• DBMS - Useful Resources
• DBMS - Discussion

• Selected Reading
• UPSC IAS Exams Notes
• Developer's Best Practices
• Questions and Answers
• Effective Resume Writing
• AI Based Resume Builder
• Personal AI Study Assistant
• Generate Coding Logic
• HR Interview Questions
• Computer Glossary
• Who is Who