Databases
Relational algebra, SQL, and database design.
📝 Topics
- ER Model: Entities, relationships, and table counts.
- Relational Model: Algebra, calculus, and division.
- SQL: Group by, joins, and nested queries.
- Normalization: BCNF, 3NF, and closures.
- Transactions: Serializability and 2PL.
- Integrity Constraints: Keys and referential integrity.
- Indexing: B+ Trees and block access.
Back to Core CS