Covers the fundamentals of database systems, including data modeling, information processing, and the challenges of managing large volumes of data.
Introduces the Entity-Relationship model for designing databases with a focus on conceptual and relational aspects.
Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.
Introduces relational query languages, focusing on algebra operators and query optimization.
Explores file organization, record formats, indexing techniques, and index classifications in databases, emphasizing the importance of efficient data storage and access.
Explores file organization, indexing methods, and database storage design, including record formats, page formats, and index classification.
Explores storage layers, disk management, flash disks, and B+ tree indexing for efficient data retrieval.
Covers hashing, sorting, extendible hashing, linear hashing, and external sorting.
Explores query processing steps, physical plans, pipelined execution, and hashing for projections and joins.
Covers query processing with relational operations, focusing on different join methods and the impact of buffering.
Covers query optimization, from logical to physical plans, including query transformation and cost estimation.
Explores eventual consistency in distributed systems, discussing challenges, tradeoffs, and practical applications.
Covers the architecture of parallel databases, benefits of parallelism, distributed databases, and replication methods.
