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.
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
- DBMS versus file processing systems· notes coming
- Data abstraction and data independence· notes coming
- DBMS architecture and database languages· notes coming
- Keys and constraints· notes coming
- ER model and ER diagrams· notes coming
- EER model and mapping to tables· notes coming
- Relational model concepts and constraints· notes coming
- Codd's rules· notes coming
- Data redundancy and anomalies· notes coming
- Functional dependencies· notes coming
- Normal forms: 1NF, 2NF and 3NF· notes coming
- Boyce–Codd normal form· notes coming
- SQL DDL and constraints· notes coming
- SQL DML and SELECT queries· notes coming
- Aggregate functions, GROUP BY and HAVING· notes coming
- Joins· notes coming
- Subqueries and set operations· notes coming
- Views and indexes· notes coming
- PL/SQL blocks and cursors· notes coming
- Stored procedures, functions and triggers· notes coming
- Transactions and ACID properties· notes coming
- Schedules and serializability· notes coming
- Recoverable and cascadeless schedules· notes coming
- Lock-based protocols and two-phase locking· notes coming
- Timestamp and validation protocols· notes coming
- Deadlocks in databases· notes coming
- Recovery: logs, checkpoints and shadow paging· notes coming
- NoSQL databases and their types· notes coming
- MongoDB basics· notes coming
- Cloud databases and DBaaS· notes coming
- Big data, Hadoop and HDFS· notes coming
- Role of the database administrator· notes coming
- Relational algebra· notes coming
- Recursive queries· notes coming
- Database programming with JDBC· notes coming
- GRANT and REVOKE· notes coming
- Relational calculus· notes coming
- MapReduce for databases· notes coming
- Streaming data and graph databases· notes coming
- Data warehousing and data mining· notes coming
- Physical storage media and RAID· notes coming
- Lossless join and dependency preservation· notes coming
- Multivalued dependencies, 4NF and 5NF· notes coming
- Query processing and optimisation· notes coming