Query Operators Part 2Covers query processing with relational operations, focusing on different join methods and the impact of buffering.
Relational Query OptimizationCovers relational query optimization, including logical and physical query plans, cost estimation, equivalences, and the System R strategy.
Parallel & Distributed DBMSCovers the architecture of parallel databases, benefits of parallelism, distributed databases, and replication methods.
Hashing and SortingCovers hashing, sorting, extendible hashing, linear hashing, and external sorting.
Query OptimizationCovers query optimization, from logical to physical plans, including query transformation and cost estimation.
Query Operators: Part 1Explores query processing steps, physical plans, pipelined execution, and hashing for projections and joins.