Databases

1. Database Adminstration

1.1. Data Administrator vs Database Administrator

1.2. Data Administration Strategy

1.3. Data-Information-Decision Cycle

2. Concurrency Control

2.1. Transaction Properties (ACIDS)

2.2. Transaction Log

2.3. Two Phase Locking

2.4. Deadlock Problem

2.5. Transaction Recovery

3. Decision Support Systems

3.1. DSS components

3.2. Data Warehouses

3.3. Operational Vs DSS data

3.4. Data Mart

3.5. OLAP

3.6. Star Schema

3.7. Data Mining

4. Database Life Cycle

4.1. Database Initial Study

4.2. Database Desing

4.3. Implementation & Loading

4.4. Testing & Evaluation

4.5. Operation

4.6. Maintenance & evolution

5. Types of Databases

5.1. Distributed Databases

5.2. Centralized Databases

5.3. Cloud Databases