Database Management Systems
2026-11-18 ยท dbms
Syllabus
- Database System Architecture
- Data Models
- Relational Query Languages
- Relational Database Design
- Query Processing and Optimisation
- Storage Strategies
- Transaction Processing
- Advanced Topics
Introduction
- Introduction
**Database Design and SQL: Part 2 and Database Connectivity
- Introduction to the Relational Model
- Introduction to SQL
- Intermediate SQL
- Advanced SQL
- Database Design using the E-R Model
- Relational Database Design
- Formal Relational Query Languages (full chapter also available here)
Query Processing and Optimisation
- Query Processing
- Query Optimisation
Storage Management and Indexing
- Physical Storage Systems
- Data Storage Structures
- Indexing
Transaction Management
- Transactions
- Concurrency Control
- Recovering System
Big Data Analytics
- Big Data
- Data Analytics
Application Design and Development
- Complex Data Types
- Application Development
Resources
- Lab exercises and Projects
- index structure
- lock manager
- relation manager (wht interator interface)
- simple relational algebra evaluation engine
- Practice Exercises with Solutions
- Database Design for Mere Mortals is a good book apparently
linked from