Relational Query OptimizationCovers relational query optimization, including logical and physical query plans, cost estimation, equivalences, and the System R strategy.
Query Operators Part 2Covers query processing with relational operations, focusing on different join methods and the impact of buffering.
Relational AlgebraIntroduces relational query languages, focusing on algebra operators and query optimization.
Query OptimizationCovers query optimization, from logical to physical plans, including query transformation and cost estimation.
Hashing and SortingCovers hashing, sorting, extendible hashing, linear hashing, and external sorting.
Parallel DatabasesExplores parallel and distributed databases, covering architectures, query optimization, data storage, and distributed transactions.
Relational Model: BasicsCovers the basics of the relational model in database management systems, including data models, primary and foreign keys.
Relational Model: BasicsIntroduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.
