Skip to main content

Databases (3 cr)

Code: KL25AB77000-3012

General information


Enrollment
22.04.2025 - 03.09.2025
Registration for the implementation has begun.
Timing
18.08.2025 - 12.10.2025
The implementation has not yet started.
Number of ECTS credits allocated
3 cr
Local portion
0 cr
Virtual portion
3 cr
Mode of delivery
Distance learning
Unit
SeAMK Automation Engineering and Information Technology
Campus
SeAMK Seinäjoki, Frami
Teaching languages
Finnish
Degree programmes
Bachelor of Engineering, Automation Engineering
Teachers
Jarkko Loima
Scheduling groups
Avoin AMK (Ei koske tutkinto-opiskelijaa) (Size: 5 . Open UAS : 5.)
Groups
MAUTE24
Insinööri (AMK), Automaatiotekniikka, monimuotototeutus
Small groups
Open UAS (Doesn't apply to degree student)
Course
KL25AB77000

Evaluation scale

1-5

Objective

The aim of the course is to familiarize the student with the basics of data warehouse. The student understands the relational database and document-base NoSql-database and learns the stages of the information analysis. Students will have command of SQL language. The student learns to use international sources in database design.

Content

The course comprises the following:
- Data warehouseing
- Relational databases
- Conceptual modelling
- ER (Entity-Relationship)-modelling
- Main features of SQL (Structured Query Language)

Materials

Material:
Hovi, Huotari, Lahdenmäki. Tietokantojen suunnittelu ja indeksointi, Docendo

Connolly Thomas - Begg Carolyn: Database Systems, Addison

Teaching methods

Opetus järjestetään lähiopetuksena, johon voi ottaa tarvittaessa etäyhteyden

Assessment criteria, satisfactory (1)

- Satisfactory (1-2) The student knows the basics

Assessment criteria, good (3)

- Good (3-4): The student is familiar with the principles of database design and basic of SQL language

Assessment criteria, excellent (5)

- Excellent (5): The student is able to apply the principles of database design in his/her exercises, and dominates the SQL language

Qualifications

No previous studies are required.

Go back to top of page