DBMS

1. DATA MODELS

1.1. RELATIONAL MODEL

1.2. ENTITY-RELATIONAL MODEL

1.3. OBJECT-BASED DATA MODEL

1.4. SEMI STRUCTURED MODEL

1.5. NETWORK MODEL

1.6. HIERARCHICAL MODEL

2. RELATIONAL MODEL

2.1. All data is stored in various tables

3. DDL COMMANDS

3.1. data defination language

3.2. CREATE

3.3. ALTER

3.4. RENAME

3.5. ADD

3.6. MODIFY

3.7. DROP

3.8. TRUNCATE

4. DML COMMANDS

4.1. data manipulation language

4.2. INSERT

4.3. DELETE

4.4. SELECT

4.4.1. FROM

4.4.1.1. WHERE

4.5. UPDATE

5. MDX

5.1. Multidimensional eXpressions is a language for expressing analytical queries

6. CONSTRAINTS

6.1. PRIMARY KEY

6.2. FORIEGN KEY

6.3. UNIQUE KEY

6.4. NOT NULL

6.5. CHECK

7. DATABASE SYSTEM INTERNALS

7.1. QUERY PROCESSING

7.2. PARSING AND TRANSLATION

7.3. OPTIMIZATION

7.4. EVALUTION

8. DATABASE ARCHITECTURE

8.1. CENTRALIZED

8.2. CLIENT-SERVER

8.3. PARALLEL(MULTIPROCESS)

8.4. DISTRIBUTED

8.4.1. CLOSELY COUPLE

8.4.2. BASELY COUPLE

9. TRANSACTION MANAGEMENT

10. STORAGE MANAGEMENT

11. RELETIONAL ALGEBRA

11.1. JOINS