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.

ohjelmointi, tietokannat, tietokanta

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
Level:
Teaching period:
2.3.–29.5.2020
Application deadline:
Application period has ended
Host university:
Tampere University
Study is open for:
Adult learner,
Degree student
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).
Interested in this course? Subscribe and get updates about the course directly to your email. You can cancel subscription any time you want.

This course is included in the following theme