Database Management Systems

Syllabus

1. Database System Architecture
2. Data Models
3. Relational Query Languages
4. Relational Database Design
5. Query Processing and Optimisation
6. Storage Strategies
7. Transaction Processing
8. Advanced Topics

Introduction

1. Introduction

Database Design and Relational Languages

1. Introduction to the Relational Model
2. Introduction to SQL
3. Intermediate SQL
4. Advanced SQL
5. Database Design using the E-R Model
6. Relational Database Design
7. Formal Relational Query Languages (full chapter also available here)

Query Processing and Optimisation

1. Query Processing
2. Query Optimisation

Storage Management and Indexing

1. Physical Storage Systems
2. Data Storage Structures
3. Indexing

Transaction Management

1. Transactions
2. Concurrency Control
3. Recovering System

Big Data Analytics

1. Big Data
2. Data Analytics

Application Design and Development

1. Complex Data Types
2. Application Development

Resources

1. Lab exercises and Projects
   • index structure
   • lock manager
   • relation manager (wht interator interface)
   • simple relational algebra evaluation engine
2. Practice Exercises with Solutions
3. Database Design for Mere Mortals is a good book apparently