Query Operators: Part 1Explores query processing steps, physical plans, pipelined execution, and hashing for projections and joins.
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.
Hashing and SortingCovers hashing, sorting, extendible hashing, linear hashing, and external sorting.
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.
Parallel DatabasesExplores parallel and distributed databases, covering architectures, query optimization, data storage, and distributed transactions.
