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.
Relational Model: BasicsCovers the basics of the relational model in database management systems, including data models, primary and foreign keys.
