Relational Model: BasicsIntroduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.
Data Wrangling with HadoopCovers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.
NoSQL DatabasesCovers the origins, properties, and types of NoSQL databases, focusing on MongoDB and the CAP theorem.
SQL Queries and SyntaxCovers the basics of SQL, including components of the language and syntax of SELECT clause.
Efficient GPU Join OptimizationCovers efficient GPU-accelerated join optimization for complex queries, focusing on improving optimization times and heuristic plan quality.
Architecture of CockroachDBExplores the architecture of CockroachDB, focusing on transaction management, concurrency control, and scalability.