Covers relational query optimization, including logical and physical query plans, cost estimation, equivalences, and the System R strategy.
Introduces relational query languages, focusing on algebra operators and query optimization.
Explores query processing steps, physical plans, pipelined execution, and hashing for projections and joins.
Covers relational and spatial databases, including storage, management systems, ACID properties, historical typologies, primary and foreign keys, and spatial functions.
Covers query optimization, from logical to physical plans, including query transformation and cost estimation.
Introduces the relational model, SQL, keys, integrity constraints, ER translation, weak entities, ISA hierarchies, and SQL vs. noSQL.
Covers the basics of the relational model in database management systems, including data models, primary and foreign keys.
Introduces the fundamentals of handling data, emphasizing the importance of Pandas and data modeling for effective analysis.
Covers query processing with relational operations, focusing on different join methods and the impact of buffering.
