Efficient GPU Join OptimizationCovers efficient GPU-accelerated join optimization for complex queries, focusing on improving optimization times and heuristic plan quality.
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.
Data Wrangling with HadoopCovers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.
Relational Model: BasicsIntroduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.
Cost-based Query OptimizationExplores cost-based query optimization in database systems, covering cost estimation, selectivity estimation, and join cardinality.
Relational AlgebraIntroduces relational query languages, focusing on algebra operators and query optimization.