Databases

This course will cover the following topics: Data modeling (EER). Translation from EER to relational database. The relational model. Databases: ANSI / SPARC architecture, normalization, SQL, concurrency issues. Relationship database alternatives: NoSQL and semi-structural data (XML and JSON). Transaction management against database.

Knowledge

The candidate must:

• know key concepts within databases, and can account for these
• be able to use SQL
• be able to construct a data model (EER) for a given problem and translate this into the relational model
• understand problems related to several simultaneous users of a database and know how these can be solved
• know about NoSQL solutions
• know the use and storage of semi-structural data such as XML

Skills

The candidate must:

• be able to create a own database, and retrieve and modify the data in this database, all via SQL (D)
• see the connection between program code and underlying SQL / database
• be able to optimize SQL queries
• be able to propose sustainable solutions for data storage related to normalization and reuse of data

General competence

The candidate must:

• gain an understanding of using database solutions to solve different needs for storage and representation of digital data
• have an understanding of what good data quality is

Teaching with practical exercises and discussion forum.