Skip to main content

Basics of Databases (4 cr)

Code: TSAT0520-3005

General information


Enrollment

01.08.2022 - 25.08.2022

Timing

29.08.2022 - 31.12.2022

Number of ECTS credits allocated

4 op

Mode of delivery

Face-to-face

Unit

School of Technology

Campus

Lutakko Campus

Teaching languages

  • Finnish

Seats

0 - 30

Degree programmes

  • Bachelor's Degree Programme in Electrical and Automation Engineering

Teachers

  • Juho Pekki

Groups

  • TSA21SB
    Sähkö- ja automaatiotekniikka (AMK)

Objectives

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

Learning materials and recommended literature

Opintojakson verkkosivut (luentomateriaali, harjoitukset ja kotitehtävät)

Teaching methods

Kontaktiopetus (Luennot ja materiaalisivu, harjoitukset, tenttiin valmistautuminen, tentti)

Exam dates and retake possibilities

Tentin ajankohta ja toteutustapa ilmoitetaan opintojakson ensimmäisellä kerralla.

Alternative completion methods

Hyväksilukemisen menettelytavat kuvataan tutkintosäännössä ja opinto-oppaassa. Opintojakson opettaja antaa lisätietoa mahdollisista opintojakson erityiskäytänteistä.

Student workload

Opiskelu 108 h (Luennot ja materiaaliin tutustuminen, harjoitukset, tenttiin valmistautuminen, tentti)

Further information for students

Opintojakson arviointi tehdään palautettujen harjoitustehtävien, sekä tentin perusteella.

Evaluation scale

0-5

Evaluation criteria, satisfactory (1-2)

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.

Evaluation criteria, good (3-4)

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.

Evaluation criteria, excellent (5)

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

Prerequisites

-