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.

Contents

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

Finnish

Evaluation

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