Skip to main content

Basics of Databases (4 cr)

Code: TSAT0520-3013

General information


Enrollment
01.08.2024 - 22.08.2024
Registration for the implementation has ended.
Timing
26.08.2024 - 08.12.2024
Implementation has ended.
Number of ECTS credits allocated
4 cr
Local portion
4 cr
Mode of delivery
Face-to-face
Unit
School of Technology
Campus
Lutakko Campus
Teaching languages
English
Seats
20 - 35
Degree programmes
Bachelor's Degree Programme in Electrical and Automation Engineering
Teachers
Antti Häkkinen
Groups
TAR23S1
Bachelor's Degree Programme in Automation and Robotics
Course
TSAT0520

Realization has 11 reservations. Total duration of reservations is 16 h 30 min.

Time Topic Location
Tue 27.08.2024 time 11:30 - 13:00
(1 h 30 min)
Basics of Databases TSAT0520-3013
P2_D331 Tietoverkkolaboratorio
Tue 03.09.2024 time 11:30 - 13:00
(1 h 30 min)
Basics of Databases TSAT0520-3013
P2_D331 Tietoverkkolaboratorio
Tue 10.09.2024 time 11:30 - 13:00
(1 h 30 min)
Basics of Databases TSAT0520-3013
P2_D331 Tietoverkkolaboratorio
Tue 17.09.2024 time 11:30 - 13:00
(1 h 30 min)
Basics of Databases TSAT0520-3013
P2_D331 Tietoverkkolaboratorio
Tue 24.09.2024 time 11:30 - 13:00
(1 h 30 min)
Basics of Databases TSAT0520-3013
Verkko/Online (KYHA)
Tue 01.10.2024 time 11:30 - 13:00
(1 h 30 min)
Basics of Databases TSAT0520-3013
P2_D331 Tietoverkkolaboratorio
Wed 09.10.2024 time 11:30 - 13:00
(1 h 30 min)
Basics of Databases TSAT0520-3013
P2_D331 Tietoverkkolaboratorio
Tue 22.10.2024 time 11:30 - 13:00
(1 h 30 min)
Basics of Databases TSAT0520-3013
P2_D334 Sulautetut järjestelmät
Tue 29.10.2024 time 15:00 - 16:30
(1 h 30 min)
Basics of Databases TSAT0520-3013
P2_D331 Tietoverkkolaboratorio
Mon 04.11.2024 time 15:00 - 16:30
(1 h 30 min)
Basics of Databases TSAT0520-3013
Verkko/Online (KYHA)
Mon 18.11.2024 time 08:30 - 10:00
(1 h 30 min)
Basics of Databases TSAT0520-3013
P2_D331 Tietoverkkolaboratorio
Changes to reservations may be possible.

Evaluation scale

0-5

Objective

Student gets familiar with databases to the extent necessary from the point of view of electrical and automation technology. By this course, the student has a basic understanding of databases.

EUR-ACE KNOWLEDGE AND UNDERSTANDING
Student is familiar with the basic structures and terminology of databases.

EUR-ACE APPLYING TECHNOLOGY INTO PRACTICE
Student is able to retrieve, edit and append the information stored in the database using database queries.

Content

Basic queries to databases
Application of the database
Understanding the concept model

Materials

Materials in the e-learning environment.

Teaching methods

- weekly lectures in campus
- independent study
- distance learning
- small group learning
- exercises

Exam schedules

The possible date and method of the exam will be announced in the course opening.

Completion alternatives

The admission procedures are described in the degree rule and the study guide. The teacher of the course will give you more information on possible specific course practices.

Student workload

One credit (1 Cr) corresponds to an average of 27 hours of work.

- lectures 30 h
- exercises 50 h
- preparing for the exam 28 h
Total 108 h

Assessment criteria, satisfactory (1)

Sufficient (1): Student recognizes the basics and terminology, but has shortcomings in understanding the key issues.

Satisfactory (2): Student knows the basics and terminology, but has shortcomings in the application of key issues.

Assessment criteria, good (3)

Good (3): Student is familiar with basic database queries and working with them. Student is able to apply the theory learnt from databases to practice and understand the concept model.

Very good (4): Student knows the key subjects and is able to apply them in different implementations.

Assessment criteria, excellent (5)

Excellent (5): Student masters key subjects and is able to apply them creatively and innovatively.

Qualifications

-

Go back to top of page