Syllabus
- ER-model, Relational model (relational algebra, tuple calculus)
- Database design (integrity constraints, normal forms)
- Query languages (SQL)
- File structures (sequential files, indexing, B and B+ trees)
- Transactions and concurrency control
Book
Choose one of:
Video
Web Links
- Home page of Database Systems Concepts
- SQL and other portions
- ER to Relational Model
- Normal Forms Quick View
- Normalization Slides
- Canonical Cover
- Indexing
- B+ Tree Insertion and Deletion
- NULLs
Previous Year Questions
http://gateoverflow.in/questions/database-management
Important Questions
http://gateoverflow.in/blog/560/important-questions-in-databases
GATE CSE Discussions