Explores query processing steps, physical plans, pipelined execution, and hashing for projections and joins.
Covers the fundamentals of database systems, including data modeling, information processing, and the challenges of managing large volumes of data.
Covers relational query optimization, including logical and physical query plans, cost estimation, equivalences, and the System R strategy.
Covers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.
Explores cost-based query optimization in database systems, covering cost estimation, selectivity estimation, and join cardinality.
