Relational Model: BasicsCovers the basics of the relational model in database management systems, including data models, primary and foreign keys.
Query Operators: Part 1Explores query processing steps, physical plans, pipelined execution, and hashing for projections and joins.
Data Wrangling with HadoopCovers data wrangling techniques using Hadoop, focusing on row versus column-oriented databases, popular storage formats, and HBase-Hive integration.
Relational AlgebraIntroduces relational query languages, focusing on algebra operators and query optimization.
File Organization and IndexingExplores file organization, indexing methods, and database storage design, including record formats, page formats, and index classification.