/

RDBMS

Relational Database Management Systems

  

 Contents:

  1. DBMS Architecture
  2. Data Models
  3. Keys
  4. Attributes
  5. ER-diagram
  6. Degree of Relationship
  7. Converting ER-diagram to Relational Schema
  8. Normalization
    1. Dependencies
    2. Normal Forms
     
  9. SQL
    1. Data Types
    2. DDL & DML
    3. BETWEEN, IN and LIKE
    4. ORDER BY
    5. GROUP BY and HAVING
    6. Constraints
    7. Aggregate Functions
    8. Subquery
    9. Joins