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.
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
- Advanced DBMS needs and architectures· notes coming
- Client–server database architecture· notes coming
- Data fragmentation and replication· notes coming
- Parallel database architectures· notes coming
- Cloud databases and DBaaS· notes coming
- Query processing: selection, sorting and joins· notes coming
- Query optimisation and evaluation plans· notes coming
- Parallel and distributed query processing· notes coming
- Schedules, serialisability and recoverability· notes coming
- Lock-based and timestamp-based concurrency control· notes coming
- Log-based recovery, WAL and checkpoints· notes coming
- ARIES recovery· notes coming
- Parallel databases: speed-up and parallelism· notes coming
- Distributed databases· notes coming
- XML: schema, DTD, XPath and XQuery· notes coming
- Database security: authentication, authorisation and encryption· notes coming
- Database auditing, threats and SQL injection· notes coming
- Data privacy: masking and anonymisation· notes coming
- NewSQL and modern database trends· notes coming
- Biba and Bell–LaPadula models· notes coming
- Role hierarchies and separation of duty in RBAC· notes coming
- Smart cards· notes coming
- Secure DBMS and security software design· notes coming
- Statistical database protection and inference control· notes coming