Open Programming and Database Courses 1 - 28 ECTS credits - training for those receiving temporary protection in Finland
This training provides you with the opportunity to complete 1 - 28 ECTS credits of online courses. The studies are intended for those receiving temporary protection in Finland as well as for anyone with the ability to study at a higher education level in English. The courses are free of charge.
These courses are undergraduate level studies, which equal basic studies of a Finnish bachelor’s degree in IT. The studies require knowledge of English at proficiency level B1 or above. You can enrol on one course or several, depending on your own need and interest. Please note: 1 ECTS credit = 27 hours of student’s work.
Once you have completed the courses of your choice, you can request a certificate of the courses (see instructions below). The credits can be included in higher education either in Finland or abroad, depending on the degree program. The certificate is also an excellent way to demonstrate your expertise in programming to future employers.
These courses are organised as open higher education in cooperation between the University of Turku and Turku University of Applied Sciences. The training is funded by the Finnish Ministry of Education and Culture.
Open Programming and Database Courses webinar on 15.9.2023
Open Programming and Databases webinar on 29 August 2024 at 15:00-16:00
> Information will be published in August
COURSE SCHEDULE IN ACADEMIC YEAR 2024 - 2025:
The courses start on September, 2024. Registration for the courses starts on June 15.
Fundamentals of Programming 5 ECTS credits
Fundamentals of Programming is an open programming course intended for anyone interested in programming. The course provides the fundamentals of programming with the Python programming language, and no previous experience is required. The entire course can be completed virtually - no onsite attendance is required.
Online course in the autumn term 2024.
> Study guide, enrolment 15.6. - 31.10.2024 (Turku UAS)
Further information: avoinamk@turkuamk.fi
Design and Use of Relational Databases 5 ECTS credits
In the database design part of the course, students familiarize themselves with database thinking and the principles of data management from a quality perspective. Key topics include data modeling using ER diagrams, relational schema representations and normalization technique for validating the quality of the design. The course is suitable for beginners and no previous studies are necessary.
The course is a self-study course available online 12.8. - 31.12.2024.
> Study guide, enrolment 15.6. - 31.10.2024 (Turku UAS)
Further information: avoinamk@turkuamk.fi
Basics of Programming - Exercise 2 ECTS credits
The online course 2.9.2024 - 31.7.2025 consists of a programming project, written in Python.
> Study guide (University of Turku)
> Enrolment (for those receiving temporary protection) 19.6.2024 - 31.5.2025 See in English
> Enrolment (for anyone else) 19.6.2024 - 31.5.2025 See in English
Further information: Katja Kivistö
Tools for Programming 1 ECTS credit
The online course 2.9.2024 - 31.7.2025 consists of workshops and exercises.
> Study guide (University of Turku)
> Enrolment (for those receiving temporary protection) 19.6.2024 - 31.5.2025 See in English
> Enrolment (for anyone else) 19.6.2024 - 31.5.2025 See in English
More information: Katja Kivistö
Basics of Object-Oriented Programming 5 ECTS credits
The key content of the course is the ability to design and write your own classes. The language used is Java. The online course 2.9.2024 - 31.7.2025 consists of lecture recordings, workshops, exercises and exam.
> Study guide (University of Turku)
> Enrolment (for those receiving temporary protection) 19.6.2024 - 31.5.2025 See in English
> Enrolment (for anyone else) 19.6.2024 - 31.5.2025 See in English
Further information: Katja Kivistö
Advanced Course in Object Oriented Programming 5 ECTS credits
The course has two main themes in software engineering: object based design and, in terms of software specification, design by contract.
Online course 2.9.2024 - 31.7.2025 consists of lectures (online or video lectures), independent exercises and electronic exam.
> Study guide (University of Turku)
> Enrolment (for those receiving temporary protection) 19.6.2024 - 31.5.2025 See in English
> Enrolment (for anyone else) 19.6.2024 - 31.5.2025 See in English
Further information: Katja Kivistö
Web Programming 5 ECTS credits
The web programming course introduces modern programming techniques in the web environment. The course discusses developing modern single-page applications. The course concentrates on full stack development: the student will gain basic skills in both client-side and server-side programming.
The online course is organised 17.9. - 27.10.2024.
> Study guide (University of Turku)
> Enrolment (for those receiving temporary protection) 19.6. - 12.9.2024 See in English
> Enrolment (for anyone else) 19.6. - 12.9.2024 See in English
Further information: Katja Kivistö
Instructions for requesting Transcript of Study Records
Once you have completed the courses of your choice, you can request a transcript of study records from the University of Turku from the study services secretary Heli Lainio, heli.lainio@utu.fi. If you have studied courses only at Turku University of Applied Sciences, request a transcript of study records from avoinamk@turkuamk.fi.