Information Technology 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.

Information Technology

Database Management System

ER model, relational design and normalisation, SQL and PL/SQL, transactions and recovery, NoSQL.

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

  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. Keys and constraints· notes coming
  5. ER model and ER diagrams· notes coming
  6. EER model and mapping to tables· notes coming
  7. Relational model concepts and constraints· notes coming
  8. Codd's rules· notes coming
  9. Data redundancy and anomalies· notes coming
  10. Functional dependencies· notes coming
  11. Normal forms: 1NF, 2NF and 3NF· notes coming
  12. Boyce–Codd normal form· notes coming
  13. SQL DDL and constraints· notes coming
  14. SQL DML and SELECT queries· notes coming
  15. Aggregate functions, GROUP BY and HAVING· notes coming
  16. Joins· notes coming
  17. Subqueries and set operations· notes coming
  18. Views and indexes· notes coming
  19. PL/SQL blocks and cursors· notes coming
  20. Stored procedures, functions and triggers· notes coming
  21. Transactions and ACID properties· notes coming
  22. Schedules and serializability· notes coming
  23. Recoverable and cascadeless schedules· notes coming
  24. Lock-based protocols and two-phase locking· notes coming
  25. Timestamp and validation protocols· notes coming
  26. Deadlocks in databases· notes coming
  27. Recovery: logs, checkpoints and shadow paging· notes coming
  28. NoSQL databases and their types· notes coming
  29. MongoDB basics· notes coming
  30. Cloud databases and DBaaS· notes coming
  31. Big data, Hadoop and HDFS· notes coming
  32. Role of the database administrator· notes coming
  33. Relational algebra· notes coming
  34. Recursive queries· notes coming
  35. Database programming with JDBC· notes coming
  36. GRANT and REVOKE· notes coming
  37. Relational calculus· notes coming
  38. MapReduce for databases· notes coming
  39. Streaming data and graph databases· notes coming
  40. Data warehousing and data mining· notes coming
  41. Physical storage media and RAID· notes coming
  42. Lossless join and dependency preservation· notes coming
  43. Multivalued dependencies, 4NF and 5NF· notes coming
  44. Query processing and optimisation· notes coming