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
-
MAUTE24Insinöö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.