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.
Introduces semantic modelling through tabular data and RDF, covering relational databases, schema migration, future-proof schemata, SPARQL querying, and metaknowledge limitations.
Explores file organization, indexing methods, and database storage design, including record formats, page formats, and index classification.
Covers relational query optimization, including logical and physical query plans, cost estimation, equivalences, and the System R strategy.
