Mobilité EUt+
Retour

Page du cours ✏️


Databases
30.7326

Description
Learning Objectives: 
Students acquire the skills to,
  • be able to transform a UML class diagram into a relational data model (both manually and with a CASE tool) and understand ER models
  • be able to implement a database schema using SQL-DDL and insert, query and modify data using SQL-DML
  • be able to implement integrity conditions with the help of constraints
  • be able to apply database rights concepts in practice
  • be able to implement database application logic in an application program and with the help of an OR mapper
  • Know the concepts of transaction management and database index structures and be able to apply them appropriately
  • Know basic concepts of NoSQL database systems
Course content:
  • Conceptual data modeling based on the UML class diagram and the ER model
  • Relational data modeling
  • SQL-DDL, SQL-DML, system catalog
  • Accessing databases from an application
  • Use of OR mappers
  • Transaction concept
  • Internal data organization: indexes (B-trees, hash methods)
  • NoSQL databases

Crédits ECTS
5

Langue d'enseignement
Deutsch

Langue d'examen
Deutsch

Langue des supports pédagogiques
Deutsch/English

Acquis d'apprentissage fondamentaux

Entité de gestion (faculté)
Computer Science Department (HDA)