DV1127 Databases and Object-oriented programming in PHP

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.

Prerequisites

General requirements for university studies.

Read more about general admission requirements.

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

Course literature and other teaching material

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.

Assessments

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 (U), Pass (G) or Pass with Distinction (VG).

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.