Databases I

Course contents
  • - Overview of relational and non-relational data models and the corresponding database systems
    - Overview of central theories and theorems (relational algebra, ACID, BASE, CAP etc.)
    - Modeling relational structures (conceptual data modeling, logical data models, database schemata, normalization)
    - SQL (Data Definition Language, Data Manipulation Language)
    - SQL extensions and behavioral implementation (e.g. integrity assurance through triggers, stored procedures etc.)
    - Multi-User Control and Transaction Models