SoleOPS 3.13.0, ©2005-2018Solenovo Oy

Opintojakson toteutussuunnitelma

GroupR504D13S/Degree Programme in Information Technology (Rovaniemi)
Study unitR504D19B Web Programming Technologies, 5.00 ECTS credits, 133 h
Software Engineering Competence
Time of implementationAutumn1/2014-2015, Autumn2/2014-2015
Responsible teacherKesti Aku
Other teachersMielikäinen Maisa
Status of implementationFinished

Description status Ready
Language of instruction English
Starting and ending dates01.08.2014 - 31.12.2014
Minimum number of participants  
Maximum number of participants  
Enrolment period15.04.2014 - 15.09.2014
Implementation method
Virtuality 0 ECTS credits
R&D integration 0 ECTS credits
Resit dates of the exam 19.01.2015 klo 16:30-19:30, 16.02.2015 klo 16:30-19:30, 13.04.2015 klo 16:30-19:30
Koulutuksen aikataulu (www-linkki)
Description language English 
Assessment criteria  
Pedagogical arrangements

The student gets a general view on going through a database development process by using modern tools. The students handle the basics of SQL -language and are able to use it for their advantage in developing database applications. The student acquires a general view on basics of web programming, and is also able to produce independently an interactive database-based web application in PHP coding environment.


Students manage the basics of database modelling and design and SQL language and also are able to exploit these skills in web based database system development. Students get a overall view from the basics of web based software application development and are able to implement interactive web based database application in PHP programming enviroment.


Handouts in network/Moodle


Conceptual modeling and database designing

Database development begins and is based on the Customer requirements. First section concentrates on modeling the content of the database by using the notation known in Sybase environment, Sybase Power Designer is used as a modeling tool. SQL language and Oracle 11g and MS Visual Studio 2008 tools are putting on a practice when working with database. Most major and useful SQL commands are went through during the course.

PHP parts coming soon...


Requirements and assesment:
Final grade consists oftwo parts:  final exam and practical work. Both of them represents 1/2 of the final grade. 
Assessment scale: failed - excellent (5)