Database Technology, 6 credits (732A57)

Databasteknik, 6 hp

Main field of study

Computer Science

Level

Second cycle

Course type

Programme course

Examiner

Olaf Hartig

Course coordinator

Olaf Hartig

Director of studies or equivalent

Patrick Lambrix
Course offered for Semester Weeks Language Campus VOF
F7MSL Statistics and Machine Learning, Master´s Programme 3 (Autumn 2020) v202045-202102 English Linköping v

Main field of study

Computer Science

Course level

Second cycle

Advancement level

A1N

Course offered for

  • Masters Programme in Statistics and Machine Learning

Entry requirements

A bachelor’s degree in one of the following subjects: statistics, mathematics, applied mathematics, computer science, engineering, or equivalent. Completed courses in calculus, linear algebra, statistics and programming are required. 
Documented knowledge of English equivalent to Engelska B/Engelska 6 

Intended learning outcomes

After the completion of the course you should on an advanced level be able to:
 - explain and use the most important terminology within databases and database technology in a correct way 
- design a data model using EER diagrams. 
- design, implement and use a relational database. 
- explain the theory behind the relational model and how this affects good design of databases. 

Course content

The aim of this course is to give a thorough introduction to:
- the theoretical and practical issues underlying the design and implementation of modern database systems
- principles for general database management systems: DBMS, 
- methods for database design and use. 
- datamodelling with EER, Relational databases, Datastructures for databases, SQL, Relational algebra, query optimization, transactions, serialisation, concurrency.

Teaching and working methods

The course consists of lectures and laboratory work. Lectures are devoted to theory and techniques. Database design and implementation techniques are practised in the laboratory work.
Homework and independent study are a necessary complement to the course. Language of instruction: English. 

 

Examination

Written examination. Laboratory work.
Detailed information about the examination can be found in the course’s study guide. 

Grades

ECTS, EC

Department

Institutionen för datavetenskap
There is no course literature available for this course.
TENT Examination EC 3 credits
LAB1 Laboratory work EC 3 credits

This tab contains public material from the course room in Lisam. The information published here is not legally binding, such material can be found under the other tabs on this page. There are no files available for this course.