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.
Your progress in this subject0 of 3 · 0%
- 1Integrity constraintsClear, exam-focused notes on integrity constraints in the relational model: definitions, formal laws, SQL examples, common mistakes and practice questions.
- 2Functional dependenciesClear, exam-focused notes on functional dependencies: definitions, Armstrong's axioms and derived rules, attribute closure, minimal cover, algorithms and worked examples for finding closures, keys and minimal covers.
- 3Transactions and ACID propertiesTransactions group multiple database operations into one atomic unit and ACID (Atomicity, Consistency, Isolation, Durability) are the properties that make transactions reliable and safe under failures and concurrency.
Coming next in Database Management Systems
- Purpose of a DBMS· notes coming
- DBMS architecture and data models· notes coming
- ER model and ER diagrams· notes coming
- Extended ER features· notes coming
- Converting ER diagrams to tables· notes coming
- DDL, DML, DCL and TCL· notes coming
- Joins and views· notes coming
- Aggregate functions and set operations· notes coming
- Nested queries· notes coming
- PL/SQL procedures and functions· notes coming
- Triggers· notes coming
- Relational model and Codd's rules· notes coming
- Normalisation: 1NF to BCNF· notes coming
- Intelligent query processing· notes coming
- Conflict and view serialisability· notes coming
- Recoverable schedules· notes coming
- Lock-based concurrency control· notes coming
- Timestamp-based concurrency control· notes coming
- Log-based recovery and checkpoints· notes coming
- NoSQL database types· notes coming
- ACID versus BASE· notes coming
- MongoDB CRUD and aggregation· notes coming
- Replication and sharding· notes coming
- Graph databases with Neo4j· notes coming
- Three-schema architecture, schemas and instances· notes coming
- Relational algebra· notes coming
- Lossless join and dependency preservation· notes coming
- Tuple and domain relational calculus· notes coming
- Fourth normal form and multivalued dependencies· notes coming
- Validation-based protocols and multiple granularity· notes coming
- Indexing: ordered, B+-tree and hash indices· notes coming
- Query processing: selection, sorting and joins· notes coming
- Query optimisation and evaluation plans· notes coming
- Deadlock handling in databases· notes coming
- Cloud and distributed databases· notes coming
- Distributed database design: fragmentation, replication and allocation· notes coming
- Distributed query processing· notes coming
- Multiversion concurrency control· notes coming
- Distributed transactions: two-phase and three-phase commit· notes coming
- Object-oriented database systems· notes coming
- Object-oriented data modelling and persistence· notes coming
- Object query language and ODMG· notes coming
- Object-relational mapping· notes coming
- Mobile and web databases· notes coming
- Database security threats and DBMS vulnerabilities· notes coming
- Biba and Clark–Wilson integrity models· notes coming
- Role hierarchies and separation of duty· notes coming
- Smart card security and operating systems· notes coming
- Secure DBMS design· notes coming
- Statistical database protection and inference control· notes coming
- File organisation and buffer management· notes coming
- Parallel database architectures· notes coming