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 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 Friday 15.9.2023:

> Webinar recording

COURSE SCHEDULE IN ACADEMIC YEAR 2024 - 2025:

The courses start on September, 2024. Registration for the courses starts on June 19.

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.

> Study Guide (Turku UAS)
> Enrolment 15.6. - (Turku UAS)

More 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 (Turku UAS)
> Enrolment 15.6. - 31.10.2024 (Turku UAS)

More 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

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

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

More 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

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.