Covers the fundamentals of database systems, including data modeling, information processing, and the challenges of managing large volumes of data.
Covers efficient GPU-accelerated join optimization for complex queries, focusing on improving optimization times and heuristic plan quality.
Explores cost-based query optimization in database systems, covering cost estimation, selectivity estimation, and join cardinality.
Covers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.
Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.
Explores query processing steps, physical plans, pipelined execution, and hashing for projections and joins.
