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.