DV1127 Databases and Object-oriented programming in PHP

Single subject course, 7.5 ECTS credits, First cycle, spring semester 2012

Overview

Databases and scripting languages, such as PHP, is a basic component of web applications. A prerequisite for building database-driven web applications is to have a solid understanding of limitations and possibilities of script programming. Sometimes, it is not enough to be able to use PHP as a simpler scripting language. To develop professional web applications,it is required a better handling of the script part that is more related with traditional programming in C/C++ or Java. This course is a basic programming course, where PHP and its language constructions are reviewed from beginning. All programming takes place in a web-based environment with a web server (Apache, HTML and CSS) and a database server (SQL and MySQL). This way the student is prepared for further studies in the subject, e g for developing database-driven web applications. The main purpose of the course is to teach the bases in programming and PHP as programming language. After completion of the course, the student is expected to aquired basic knowledge in programming normally considered prerequisites for further studies in programming, databases and database-driven web applications.

Application date

2011-October-15

Course period

2012-January-16 until
2012-June-03

Mode of delivery

Distance learning, Mixed, part time 25 %

Number of physical meetings

Compulsory: 0
Optional: 0

Teaching location

Teaching and examinations are held at distance.

Language of instruction

Swedish

Syllabus in English

Links

Main field of study

Computer Science

Level

G1N

Admission

Prerequisites

General requirements for university studies.

Read more about general admission requirements.

Application date

2011-October-15

Course period

2012-January-16 until
2012-June-03

Mode of delivery

Distance learning, Mixed, part time 25 %

Number of physical meetings

Compulsory: 0
Optional: 0

Teaching location

Teaching and examinations are held at distance.

Language of instruction

Swedish

Syllabus in English

Links

Main field of study

Computer Science

Level

G1N

Learning Outcomes

Content

The course includes the following elements: @@ Databases, simple modelling of ER (Entity Relationship) as well as implementation of these with SQL (Structured Query Language). @@ Object-oriented PHP programming, PHP language constructions, syntax, semantics, link against databases, function-oriented programming, object-oriented programming, data structures and algorithms.
  • Web applications, developing web applications using techniques such as web server (Apache), PHP, HTML, CSS, and SQL integrated.
  • XHTML and Scalable Vector Graphics (SVG). How to draw simple images with SVG graphics integrated into a Web application with PHP. @@ Use of tools and techniques suitable for the development of Web applications, such as UNIX/Linux installation on external Web server, ssh, ftp/sftp, database clients such as phpMyAdmin and MySQL Workbench.

Learning outcomes

On completion of course the student will:
  • individually demonstrate basic knowledge in techniques which the course covers. Above all, the techniques object oriented PHP and SQL, and how they together are used to create a database-driven web application.
  • individually demonstrate a basic understanding of the importance of a web application's structure and describe how the different technologies (HTML, object oriented PHP and SQL) may be used to influence the structure.
  • individually demonstrate good practical ability to handle those tools and environments used in development of web applications.
  • be able to independently develop and deploy a web application developed with HTML, object oriented PHP and SQL

Generic Skills

The following general skills are trained in course:
  • Problem solving
  • Information search
  • Ability to work independently
  • Written communication

Course literature and other teaching material

Huvudlitteratur:
1. Titel: Beginning PHP 5 and MySQL 5, From Novice to Professional, 4e uppl
Författare: Gilmore, W
Förlag: Pagina förlags AB
Utgiven: 2010
Antal sidor: 787
ISBN10: 1430231149
ISBN13: 9781430237741
---
Referenslitteratur:
1. Databasteknik
Författare: Thomas Radron-McCarthy
Författare: Tore Risch
Förlag: Studentlitteratur AB
Utgivningsår: 2005, Antal sidor 646
ISBN10: 9144044496
ISBN13: 9789144044491

2. Beginning Web Programming with HTML, XHTML and CSS, 2:a upplagan
Författare: Duchett, Jon
Förlag: Pagina Förlag AB
Utgivningsår: 2008, Antal sidor: 1097
ISBN10: 0470259310
ISBN13: 9780470259313

3. HTML & CSS: The Complete Reference, fifth edition
Författare: Thomas A. Powell
Förlag: McGraw-Hill/Osborne Media
Språk: Engelska
Utgiven: 2010, Antal sidor: 832
ISBN10: 0071496297
ISBN13: 9780071496292

Application date

2011-October-15

Course period

2012-January-16 until
2012-June-03

Mode of delivery

Distance learning, Mixed, part time 25 %

Number of physical meetings

Compulsory: 0
Optional: 0

Teaching location

Teaching and examinations are held at distance.

Language of instruction

Swedish

Syllabus in English

Links

Main field of study

Computer Science

Level

G1N

Stucture - Literature

Course literature and other teaching material

Huvudlitteratur:
1. Titel: Beginning PHP 5 and MySQL 5, From Novice to Professional, 4e uppl
Författare: Gilmore, W
Förlag: Pagina förlags AB
Utgiven: 2010
Antal sidor: 787
ISBN10: 1430231149
ISBN13: 9781430237741
---
Referenslitteratur:
1. Databasteknik
Författare: Thomas Radron-McCarthy
Författare: Tore Risch
Förlag: Studentlitteratur AB
Utgivningsår: 2005, Antal sidor 646
ISBN10: 9144044496
ISBN13: 9789144044491

2. Beginning Web Programming with HTML, XHTML and CSS, 2:a upplagan
Författare: Duchett, Jon
Förlag: Pagina Förlag AB
Utgivningsår: 2008, Antal sidor: 1097
ISBN10: 0470259310
ISBN13: 9780470259313

3. HTML & CSS: The Complete Reference, fifth edition
Författare: Thomas A. Powell
Förlag: McGraw-Hill/Osborne Media
Språk: Engelska
Utgiven: 2010, Antal sidor: 832
ISBN10: 0071496297
ISBN13: 9780071496292

Learning methods

The course is given as distance course. As support is BTH learning platform where course materials are distributed and information published. There is communication via e-mail. Tutoring are primarily through the learning platform forum. The course consists of a number of course modules conducted individually. Modules of the course is practical oriented and focuses on training skills through exercises and problem-solving. Each course sections contains a theoretical part in which the student deepen the knowledge by studying literature and searching information. Each course sections is a building block for the creation of a larger web application. Thus, each step is a preparation for the project which is the course's final examination. After each completed course module submission and report on work in the forum. The course is completed and examination through an individual project. In the project a web application is developed and documented. The student uses building blocks from previous course sections and merge them into a well-functioning end product. In connection with the project's presentation a report is submitted . The report includes all previously presented a report from course modules and a summary. The course requires that the student have, or acquire, the ability to independently seek information to solve problems and difficulties that appears. Teaching is usually in Swedish, but teaching in English may occur.

Work placement

The course contains a project and is part of the examination of the course.

Teachers

Examiner
Mikael Roos

Course Manager
Mikael Roos

Teacher(s)
Mikael Roos
Rickard Gimerstedt

Planned learning activities

Distance course consisting of reading instructions and practical assignments that are solved individually, Tutoring takes place in forum and chat.

Time allocation

On average, a student should study 200 hours to reach the learning outcomes. This time includes all the various available learning activities (lectures, self studies, examinations, etc.). This estimation is based on the fact that one academic year counts as 60 ECTS credits, corresponding to an average student workload of 1 600 hours. This may vary individually.

Application date

2011-October-15

Course period

2012-January-16 until
2012-June-03

Mode of delivery

Distance learning, Mixed, part time 25 %

Number of physical meetings

Compulsory: 0
Optional: 0

Teaching location

Teaching and examinations are held at distance.

Language of instruction

Swedish

Syllabus in English

Links

Main field of study

Computer Science

Level

G1N

Examination

Assessments

Component examinations for the course
Code Title ECTS credits Grade
1005 Assignments 2.5 U/G/VG
1015 Report 2.5 U/G/VG
1025 Project 2.5 U/G/VG

Grading

The course will be graded Fail, Pass or Pass with Distinction.

On request grades according to ECTS will be given.

Future exams

No upcoming, centrally coordinated, examinations for this course were found.

To participate in a centrally coordinated examination, you must enroll in Student's Portal, no later than fifteen days before the examination.

Time and location for the examination will be published about 5 days in advance.

There might be other scheduled examinations. Information concerning these examinations are available in It's Learning or at other places that the person who is responsible of the course will refer to.

Course Evaluation

The course manager is responsible for the views of students on the course being systematically and regularly gathered and that the results of the evaluations in various forms affect the form and development of the course.

Application date

2011-October-15

Course period

2012-January-16 until
2012-June-03

Mode of delivery

Distance learning, Mixed, part time 25 %

Number of physical meetings

Compulsory: 0
Optional: 0

Teaching location

Teaching and examinations are held at distance.

Language of instruction

Swedish

Syllabus in English

Links

Main field of study

Computer Science

Level

G1N

 

Share Share