DBMS

‘Recent Articles’ on DBMS !

Introduction :

  1. DBMS Introduction | Set 1
  2. DBMS Introduction | Set 2 (3-Tier Architecture)
  3. DBMS Architecture 2-level 3-level
  4. Need For DBMS
  5. Data Abstraction and Data Independence

Entity Relationship Model :

  1. ER Model
  2. Minimization of ER Diagram

Relational Model :

  1. Relational Model and CODD Rules
  2. Relational Model
  3. Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign)
  4. Anomalies in Relational Model
  5. Mapping from ER Model to Relational Model
  6. Quiz on ER and Relational Model

Relational Algebra :

  1. Introduction
  2. Basic Operators
  3. Extended Operators
  4. How to solve Relational Algebra Problems for GATE
  5. How to Solve Relational Algebra Problems for GATE

Functional Dependencies :

  1. Functional Dependency and Attribute Closure
  2. Equivalence of Functional Dependencies
  3. Canonical Cover

Normalisation :

  1. Introduction
  2. Normal Forms
  3. Dependency Preserving Decomposition
  4. Lossless Join Decomposition
  5. LossLess Join and Dependency Preserving Decomposition
  6. How to find the Highest Normal Form of a Relation
  7. Quiz on Normal Forms

Transactions and Concurrency Control :

  1. Introduction
  2. ACID Properties
  3. Conflict Serializability
  4. View Serializability
  5. Recoverability of Schedules
  6. Precedence Graph for testing Conflict Serializabilty
  7. Quiz on Transactions and Concurrency Control

Indexing, B and B+ trees :

  1. Indexing and its Types
  2. B-Tree | Set 1 (Introduction)
  3. B-Tree | Set 2 (Insert)
  4. B-Tree | Set 3 (Delete)
  5. Quizzes on Indexing, B and B+ Trees

Advanced Topics :

  1. RAID
  2. Query Optimization
  3. How to store a password in database?
  4. Data Warehousing
  5. Data Mining

SQL | Tutorials

Quick Links :

  1. Last Minutes Notes on DBMS
  2. Commonly asked DBMS Interview Questions | Set 1
  3. Commonly asked DBMS Interview Questions | Set 2
  4. ‘Practice Problems’ on DBMS !
  5. ‘Quizzes’ on DBMS !
  6. Ask a Question on ‘DBMS’

Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.

Company Wise Coding Practice    Topic Wise Coding Practice