Introduction to Database SystemsCovers the fundamentals of database systems, including data modeling, information processing, and the challenges of managing large volumes of data.
Data Wrangling with HadoopCovers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.
Cost-based Query OptimizationExplores cost-based query optimization in database systems, covering cost estimation, selectivity estimation, and join cardinality.
Relational Model: BasicsIntroduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.