Computer Engineering is coming soon

We're still writing and reviewing the notes for every subject, and we'll open it when every subject is ready. Meanwhile you can practise aptitude, ask Aria about any subject, or see the branches that are ready.

Computer Engineering

Advanced Databases

DBMS architectures, query optimisation, concurrency and recovery, distributed and XML databases, security.

Interview questions
Notes for Advanced Databases are being written and reviewed. Until they're up, Aria teaches every topic — ask for any part of the syllabus, with worked numericals.

Coming next in Advanced Databases

  1. Advanced DBMS needs and architectures· notes coming
  2. Client–server database architecture· notes coming
  3. Data fragmentation and replication· notes coming
  4. Parallel database architectures· notes coming
  5. Cloud databases and DBaaS· notes coming
  6. Query processing: selection, sorting and joins· notes coming
  7. Query optimisation and evaluation plans· notes coming
  8. Parallel and distributed query processing· notes coming
  9. Schedules, serialisability and recoverability· notes coming
  10. Lock-based and timestamp-based concurrency control· notes coming
  11. Log-based recovery, WAL and checkpoints· notes coming
  12. ARIES recovery· notes coming
  13. Parallel databases: speed-up and parallelism· notes coming
  14. Distributed databases· notes coming
  15. XML: schema, DTD, XPath and XQuery· notes coming
  16. Database security: authentication, authorisation and encryption· notes coming
  17. Database auditing, threats and SQL injection· notes coming
  18. Data privacy: masking and anonymisation· notes coming
  19. NewSQL and modern database trends· notes coming
  20. Biba and Bell–LaPadula models· notes coming
  21. Role hierarchies and separation of duty in RBAC· notes coming
  22. Smart cards· notes coming
  23. Secure DBMS and security software design· notes coming
  24. Statistical database protection and inference control· notes coming