x !
Archived Curricula Guide 2017–2019
Curricula Guide is archieved. Please refer to current Curricula Guides
TIEP3 Data Bases 5 ECTS
Organised by
Degree Programme in Computer Sciences
Preceding studies
Recommended:
Corresponding course units in the curriculum
School of Information Sciences
Curricula 2015 – 2017
TIEP3 Data Bases 5 ECTS

Learning outcomes

After completing the course a student
• knows the basic concepts and structures of SQL databases (relational databases)
• knows the basic concepts and principles of ER modeling
• is able to model data using ER diagrams
• is able to convert ER diagrams into SQL database schemas
• is able to establish a database and update and retrieve the data in a database with the help of SQL language .

Contents

Course topics include establishing a database, updating data and posing queries in SQL language, ER diagrams and conversion from an ER diagram into an SQL database (relational database) schema.

Teaching methods

Teaching method Contact Online
Lectures 20 h 0 h
Exercises 12 h 0 h

Modes of study

Option 1
Available for:
  • Degree Programme Students
  • Other Students
  • Open University Students
  • Doctoral Students
  • Exchange Students
Participation in course work 
In Finnish
Further information 

Luennot, harjoitukset, harjoitustyö ja tentti.

Option 2
Available for:
  • Degree Programme Students
  • Other Students
  • Open University Students
  • Doctoral Students
  • Exchange Students
Exercise(s) 
In English
Exam  Written exam 
In English
Option 3
Available for:
  • Degree Programme Students
  • Other Students
  • Open University Students
  • Doctoral Students
  • Exchange Students
Näyttökoe  Written exam 
In Finnish

The course can be taken in English by doing weekly exercises, written examination, and course assignment. Teaching in lectures and on weekly exercise sessions will be in Finnish only, so this course requires a lot of self-directed learning.

Evaluation

Numeric 1-5.

Belongs to following study modules

Faculty of Natural Sciences
Faculty of Natural Sciences
Faculty of Natural Sciences
Faculty of Natural Sciences
Faculty of Natural Sciences