Back to all courses

Tietokantojen perusteet

Individual course

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.

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

More information in Tampere University’s study guide.

You can get a digital badge after completing this course.

Further information about the studies

Tampere University
Teemu Rauhala
teemu.rauhala(at)tuni.fi

Responsible teacher

Tampere University
Kati Iltanen
kati.iltanen(at)tuni.fi

Contact person for applications

FITech
Pilvi Lempiäinen , Service designer
pilvi.lempiainen(at)fitech.io
Start the application process
Start the application process
Category:
ICT Studies
Topics:
Information security,
Software engineering
Course code:
TIEP3
Credits:
5 ECTS
Teaching period:
2.3.–29.5.2020
Application deadline:
24.2.2020
Host university:
Tampere University
Study is open for:
Adult learner,
Degree student
Level of studies:
Basic
Teaching methods:
Online
Language:
Finnish
General prerequisites:
Recommended: principles of tabular and text-based data processing, basic level vector and bitmap image processing (or course TIEY4 Introduction to Computing).

This course is included in the following sets of courses