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.
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
- DBMS versus file processing systems· notes coming
- Data abstraction and data independence· notes coming
- DBMS architecture and database languages· notes coming
- Relational model concepts and constraints· notes coming
- Keys and constraints· notes coming
- Relational algebra· notes coming
- Relational calculus· notes coming
- SQL DDL and constraints· notes coming
- SQL DML and SELECT queries· notes coming
- PL/SQL blocks and cursors· notes coming
- Query processing: selection, sorting and joins· notes coming
- Query optimisation and evaluation plans· 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
- Deadlocks in databases· notes coming
- Recovery: logs, checkpoints and shadow paging· notes coming
- Distributed databases· notes coming
- Data warehousing and data mining· notes coming
- Database security: authentication, authorisation and encryption· notes coming
- NoSQL databases and their types· notes coming