x !
Archived Curricula Guide 2011–2012
Curricula Guide is archieved. Please refer to current Curricula Guides
TKOPA213 Database Programming 8 ECTS
Organised by
Computer Science
Person in charge
Assistant professor Marko Junkkari.
Preceding studies
Data Bases or the old course Principles of Information Systems. Data Structures must be taken before this course or simultaneously with it.

Learning outcomes

The course aims at introducing database programming to students. In the course problems such as how to handle large amounts of data in programmes, how to access data in databases using different data models, and how data is administrated in different databases are dealt with. Upon completion of the course students should be able to create new databases, use the SQL language in administration tasks and use SQL embedded in programmes, which have been created with a general programming language.


The emphasis of the course is on relational data models and their query languages and programming styles. Query optimisation, transaction processing and consistency monitoring are discussed on a general level. In addition to relational data models, other database models are examined. In practical database programming, the focus is on SQL embedded in high level languages and JDBC and OCBC programming interfaces. WWW based database programming is also considered.

Teaching methods

Teaching method Contact Online
Lectures 32 h 0 h
Exercises 16 h 0 h

And instruction for project work.

Teaching language


Modes of study


Numeric 1-5.

Recommended year of study

2. year spring

Or later.

Study materials

  1. Elmasri, R. & Navathe, S., Fundamentals of Database Systems. Benjamin/Cummings 1997.

Belongs to following study modules

School of Information Sciences
School of Information Sciences
School of Information Sciences
Complementing studies (Computer Science/Interactive Technology)
Archived Teaching Schedule. Please refer to current Teaching Shedule.
School of Information Sciences