Covers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.
Covers efficient GPU-accelerated join optimization for complex queries, focusing on improving optimization times and heuristic plan quality.
Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.
Explores dataflow analysis for optimization, including equations solving, live variables, reaching definitions, and very busy expressions.
