DB modeling and querying essentials
Graduate course, University of Tours, Master DS4SC, 2024
Study the logical properties of relational database languages. Understand the various classes of queries along with their complexity and properties. Understand the underlying structures and mechanisms used by database engines (indexes, data organization, transaction)
Prerequisites: This course assumes a basic knowledge of relational database querying and design: relational model, conjunctive queries, and SQL.
Hours: lectures: 7.5, tutorials: 6, labs: 7.5
Acquired Skills and Knowledge
- Advanced querying (extend relational queries, views, recursive queries)
- Understanding of query classes and their complexity
- Understanding of transactions and their properties (ACID)
- Basic understanding of index structures (trees, hashing)
- Basic knowledge of database normalization principles (3NF, etc.)