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

This training provides you with the opportunity to complete 1 - 28 ECTS credits of online courses. The training is 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 29 August 2024 at 15:00 - 16:00 
> https://utu.zoom.us/j/66993804951

Open Programming and Database Courses webinar on 15.9.2023
> Webinar recording

COURSE SCHEDULE IN ACADEMIC YEAR 2024 - 2025:

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.

The course is organized by Turku University of Applied Sciences. 
The online course can be completed during 1.8. - 31.12.2024. Enrolment 15.6. - 31.10.2024. The course can also be studied in spring term 2025.

> Study guide and enrolment (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 organized by Turku University of Applied Sciences. 
The online course can be completed during 12.8. - 31.12.2024. Enrolment 15.6. - 31.10.2024. The course can also be studied in spring term 2025.

> Study guide and enrolment (Turku UAS)

Further information: avoinamk@turkuamk.fi

Basics of Programming - Exercise 2 ECTS credits

The course consists of a programming project, written in Python. The online course can be completed during 2.9.2024 - 31.7.2025. 

> Study guide (University of Turku)
> Enrolment 19.6.2024 - 31.5.2025 (for those receiving temporary protection) See in English
> Enrolment 19.6.2024 - 31.5.2025 (for anyone else) See in English

Further information: Katja Kivistö

Tools for Programming 1 ECTS credit

The online course can be completed during 2.9.2024 - 31.7.2025. The course consists of workshops and exercises.

> Study guide (University of Turku)
> Enrolment 19.6.2024 - 31.5.2025 (for those receiving temporary protecction) See in English
> Enrolment 19.6.2024 - 31.5.2025 (for anyone else) 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 can be completed during 2.9.2024 - 31.7.2025. The course consists of lecture recordings, workshops, exercises and exam.

> Study guide (University of Turku)
> Enrolment 19.6.2024 - 31.5.2025 (for those receiving temporary protection) See in English
> Enrolment 19.6.2024 - 31.5.2025 (for anyone else) 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. 

The online course can be completed during 2.9.2024 - 31.7.2025. The course consists of lectures (online or video lectures), independent exercises and electronic exam.

> Study guide (University of Turku)
> Enrolment 19.6.2024 - 31.5.2025 (for those receiving temporary protection) See in English
> Enrolment 19.6.2024 - 31.5.2025 (for anyone else) 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 will be organised 17.9. - 27.10.2024, and also in spring term 2025.

> Study guide (University of Turku)
> Enrolment 19.6. - 12.9.2024 (for those receiving temporary protection) See in English
> Enrolment 19.6. - 12.9.2024 (for anyone else) 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.