Artificial Intelligence & Data Science 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.

Artificial Intelligence & Data Science

Database Management Systems

ER modelling, SQL and PL/SQL, normalisation, transactions and recovery, NoSQL and MongoDB.

Interview questions

Coming next in Database Management Systems

  1. Purpose of a DBMS· notes coming
  2. DBMS architecture and data models· notes coming
  3. ER model and ER diagrams· notes coming
  4. Extended ER features· notes coming
  5. Converting ER diagrams to tables· notes coming
  6. DDL, DML, DCL and TCL· notes coming
  7. Joins and views· notes coming
  8. Aggregate functions and set operations· notes coming
  9. Nested queries· notes coming
  10. PL/SQL procedures and functions· notes coming
  11. Triggers· notes coming
  12. Relational model and Codd's rules· notes coming
  13. Normalisation: 1NF to BCNF· notes coming
  14. Intelligent query processing· notes coming
  15. Conflict and view serialisability· notes coming
  16. Recoverable schedules· notes coming
  17. Lock-based concurrency control· notes coming
  18. Timestamp-based concurrency control· notes coming
  19. Log-based recovery and checkpoints· notes coming
  20. NoSQL database types· notes coming
  21. ACID versus BASE· notes coming
  22. MongoDB CRUD and aggregation· notes coming
  23. Replication and sharding· notes coming
  24. Graph databases with Neo4j· notes coming
  25. Three-schema architecture, schemas and instances· notes coming
  26. Relational algebra· notes coming
  27. Lossless join and dependency preservation· notes coming
  28. Tuple and domain relational calculus· notes coming
  29. Fourth normal form and multivalued dependencies· notes coming
  30. Validation-based protocols and multiple granularity· notes coming
  31. Indexing: ordered, B+-tree and hash indices· notes coming
  32. Query processing: selection, sorting and joins· notes coming
  33. Query optimisation and evaluation plans· notes coming
  34. Deadlock handling in databases· notes coming
  35. Cloud and distributed databases· notes coming
  36. Distributed database design: fragmentation, replication and allocation· notes coming
  37. Distributed query processing· notes coming
  38. Multiversion concurrency control· notes coming
  39. Distributed transactions: two-phase and three-phase commit· notes coming
  40. Object-oriented database systems· notes coming
  41. Object-oriented data modelling and persistence· notes coming
  42. Object query language and ODMG· notes coming
  43. Object-relational mapping· notes coming
  44. Mobile and web databases· notes coming
  45. Database security threats and DBMS vulnerabilities· notes coming
  46. Biba and Clark–Wilson integrity models· notes coming
  47. Role hierarchies and separation of duty· notes coming
  48. Smart card security and operating systems· notes coming
  49. Secure DBMS design· notes coming
  50. Statistical database protection and inference control· notes coming
  51. File organisation and buffer management· notes coming
  52. Parallel database architectures· notes coming