Tietojenkäsittelytieteiden alaa esittelevä graafinen kuvituskuva.

Open Programming and Database Courses at the Open Higher Education

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 organized 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.

CURRICULUM (in total. 1 - 28 ECTS credits)

Open Programming and Database Courses webinar on Friday 15.9.2023:

> Webinar recording

The studies will also be organized in the academic year 2024 - 2025. The courses start on September 1, 2024. The exception is Web Programming, which starts on 17.9. Registration for the courses starts on June 19.

COURSE SCHEDULE IN ACADEMIC YEAR 2023 - 2024:

Fundamentals of Programming 5 ECTS credits,
1.2. - 31.7.2024

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.

> Study Guide (University of Turku)
> Enrolment 18.12.2023 - 3.5.2024 (for those receiving temporary protection) See in English
> Enrolment 18.12.2023 - 3.5.2024 (for anyone else) See in English

More information: Katja Kivistö

Design and Use of Relational Databases 5 ECTS credits,
23.10.2023 - 31.5.2024

Database thinking and the principles of data management from a quality perspective. The entire course can be completed virtually - no onsite attendance is required.

> Study Guide (Turku UAS)
> Enrolment - 31.1.2024 (Turku UAS)

More information: avoinamk@turkuamk.fi

Basics of Programming - Exercise 2 ECTS credits, 1.2. - 31.7.2024

The online course consists of a programming project, written in Python.

> Study Guide (University of Turku)
> Enrolment 9.10.2023 - 3.5.2024 (for those receiving temporary protection) See in English.
> Enrolment 9.10.2023 - 3.5.2024 (for anyone else) See in English.

More information: Katja Kivistö

Tools for Programming 1 ECTS credit, 1.3. -31.7.2024

The online course consists of workshops and independent work.

> Study Guide (University of Turku)
> Enrolment 9.10.2023 - 3.5.2024 (for those receiving temporary protection) See in English.
> Enrolment 9.10.2023 - 3.5.2024 (for anyone else) See in English.

More information: Katja Kivistö

Basics of Object-Oriented Programming 5 ECTS credits,
1.3. - 31.5.2024

The entire course can be completed virtually - no onsite attendance is required. The online course consists of lectures (recorded), workshops and independent work. The completion of the course is an electronic exam and will be taken in ViLLE learning environment.

> Study Guide (University of Turku)
> Enrolment 9.10.2023 - 2.4.2024 (for those receiving temporary protection) See in English.
> Enrolment 9.10.2023 - 2.4.2024 (for anyone else) See in English.

More information: Katja Kivistö

Advanced Course in Object Oriented Programming 5 ECTS credits, 1.5. - 30.7.2024

> Study Guide (University of Turku)
> Enrolment 1.2 - 26.4.2024 (for those receiving temporary protection) See in English.
> Enrolment 1.2. - 26.4.2024 (for anyone else) See in English.

More information: Katja Kivistö

Web Programming 5 ECTS credits, 7.2. - 19.3.2024

> Study Guide (University of Turku)
> Enrolment 5.12.2023 - 2.2.2024 (for those receiving temporary protection) See in English.
> Enrolment 5.12.2023 - 2.2.2024 (for anyone else) See in English.

More 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.