Electronics & Telecommunication (University) 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.

Electronics & Telecommunication (University)

Database Management

Data models and ER design, relational algebra and SQL, normalisation, transactions and concurrency, query processing, distributed databases.

Interview questions
Notes for Database Management 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 Database Management

  1. DBMS versus file processing systems· notes coming
  2. Data abstraction and data independence· notes coming
  3. DBMS architecture and database languages· notes coming
  4. Relational model concepts and constraints· notes coming
  5. Keys and constraints· notes coming
  6. Relational algebra· notes coming
  7. Relational calculus· notes coming
  8. SQL DDL and constraints· notes coming
  9. SQL DML and SELECT queries· notes coming
  10. PL/SQL blocks and cursors· notes coming
  11. Query processing: selection, sorting and joins· notes coming
  12. Query optimisation and evaluation plans· notes coming
  13. Transactions and ACID properties· notes coming
  14. Schedules and serializability· notes coming
  15. Recoverable and cascadeless schedules· notes coming
  16. Lock-based protocols and two-phase locking· notes coming
  17. Deadlocks in databases· notes coming
  18. Recovery: logs, checkpoints and shadow paging· notes coming
  19. Distributed databases· notes coming
  20. Data warehousing and data mining· notes coming
  21. Database security: authentication, authorisation and encryption· notes coming
  22. NoSQL databases and their types· notes coming