Covers SQL data definition, manipulation, and views in databases.
Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.
Covers efficient GPU-accelerated join optimization for complex queries, focusing on improving optimization times and heuristic plan quality.
Covers the fundamentals of database systems, including data modeling, information processing, and the challenges of managing large volumes of data.
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.
Covers relational and spatial databases, including storage, management systems, ACID properties, historical typologies, primary and foreign keys, and spatial functions.
