DBMS

1. DDL COMMANDS

1.1. data defination language

1.2. CREATE

1.3. ALTER

1.4. RENAME

1.5. ADD

1.6. MODIFY

1.7. DROP

1.8. TRUNCATE

2. DML COMMANDS

2.1. data manipulation language

2.2. INSERT

2.3. DELETE

2.4. SELECT

2.4.1. FROM

2.4.1.1. WHERE

2.5. UPDATE

3. CONSTRAINTS

3.1. PRIMARY KEY

3.2. FORIEGN KEY

3.3. UNIQUE KEY

3.4. NOT NULL

3.5. CHECK

4. DATABASE SYSTEM INTERNALS

4.1. QUERY PROCESSING

4.2. PARSING AND TRANSLATION

4.3. OPTIMIZATION

4.4. EVALUTION

5. TRANSACTION MANAGEMENT

6. DATA MODELS

6.1. RELATIONAL MODEL

6.2. ENTITY-RELATIONAL MODEL

6.3. OBJECT-BASED DATA MODEL

6.4. SEMI STRUCTURED MODEL

6.5. NETWORK MODEL

6.6. HIERARCHICAL MODEL

7. RELATIONAL MODEL

7.1. All data is stored in various tables

8. MDX

8.1. Multidimensional eXpressions is a language for expressing analytical queries

9. DATABASE ARCHITECTURE

9.1. CENTRALIZED

9.2. CLIENT-SERVER

9.3. PARALLEL(MULTIPROCESS)

9.4. DISTRIBUTED

9.4.1. CLOSELY COUPLE

9.4.2. BASELY COUPLE

10. STORAGE MANAGEMENT

11. RELETIONAL ALGEBRA

11.1. JOINS