/Courses Spring 2005 /Web Publishing with Databases
Web Publishing with Databases, Spring 2005 (W2)
|
/Courses Spring 2005 /Web Publishing with Databases |
Web Publishing with Databases, Spring 2005 (W2) |
|
|
| Course Schedule | Literature | W2 News Group | CourseGrader |
|
|
Teachers | Office | |
| Martin Elsman (mael@itu.dk) | 4E04 |
Teaching Assistants |
Office |
Office Hours |
| Jacob Friis Mathiasen (jfm@itu.dk) | News group | News group help |
| Kristian Thy (thy@itu.dk) | News group | News group help |
| Jens Vesti (vesti@itu.dk) | News group | News group help |
News |
|
Course Goals |
|
To learn to apply advanced Web techniques for developing realistic,
useful Web sites, involving information interchange with a
database. The course is focused on the possibilities the server side
provides for constructing Web sites with a high degree of dynamic
content. After the course, the successful student will be able to
design and construct medium-sized Web applications using PHP, design
small MySQL databases, and construct PHP scripts that interact with
databases using SQL (Structured Query Language). See also the course base description. |
Prerequisites |
| As a prerequisite, students should know about HTML and be able to use HTML to construct simple Web pages. Students with no programming experience should be motivated and prepared to put extra effort into the problem sets. |
Course Content |
| Based on knowledge about the construction of static Web
sites, the course provides the student with techniques for creating
Web sites that are programs and Web sites that are databases. The students are introduced to basic programming with PHP (PHP Hypertext Preprocessor) on the Web server, for generating HTML code dynamically, and to database programming with SQL (Structured Query Language), for enriching Web pages with dynamic content. The lectures and the weekly individual exercises teaches the student
|
Course Format (When and where) |
|
The course is built around 12 weekly lectures and 11 weekly exercises.
Lectures are on Tuesdays from 17.00-19.00 in room 4A14, starting February 1, 2005. There are exercise classes from 15.00-17.00 in 2A52 and from 19.00 to 21.00 in 4A56 and 4A58. Each student must turn in (and get approved) at least 9 of the 11 weekly exercises within the given deadlines. This includes students joining the course late. |
How to get Help: The Course News Group |
| If you have questions to the exercises or the course, please
use the news group it-c.courses.W2 or visit
a teaching assistant in the office hours (see above). See Sysadm's news-howto.
Do NOT email teaching assistants or lecturers at their
personal email address for general exercise help. Email to everyone on the course can be sent using the course mailing list: W2_F2005@itu.dk. |
Examination Format |
|
The examination format is a 4 hour written exam with all written
material allowed. Grades are given in the 13-scale using external
censorship. Besides the written exam, the students must have turned in
at least 9 of 11 possible weekly problem set solutions within the
given deadlines, and the solutions must be
approved by the teachers. Problem sets will be discussed in the exercise classes on the dates listed below. For a problem set solution to be approved, the student must turn in the solution to the problem set using CourseGrader before the time 00.01 on the following course day. Solutions to problem set 11 should be turned in before the time 00.01 on May 10, 2005. You are allowed to discuss solution strategies with your fellow students, but you must code up your own answers yourself. Copying other students' solutions and submitting them will be considered as cheating at the exams, cf. ITU's notes on academic conduct and misconduct. Furthermore, for approval of a problem set solution, the student must have completed correctly at least 50 percent of the problem set. (Percentage rates for the individual exercises are stated in the problem sets.) So to get a problem set approved, you should probably solve well over 60 percent to be on the safe side. Note: When submitting a problem set solution to CourseGrader, the whole solution must be turned in together (for all exercises in the problem set). If solutions to a problem set have been turned in several times, the last solution being turned in before the deadline is the one being rated. Note: When using CourseGrader the first time, you need to ask it to send you your password. Notice that CourseGrader is an isolated system, which have no connection to other ITU-related systems. In fact, the system is not maintained by the System Administration, but by Martin Elsman. |
Course Schedule | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
The schedule is preliminary
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Some ealier exam sets with solutions |
|
Creating databases at ITU |
To complete the exercises, you will need to create some databases at
ITU's MySQL server. Creating a database is done using ITU's database administration
service:
|
register_globals Off |
| If you have installed your own Web server or for other reasons need to live with register_globals Off, please see the Zend-note on register_globals Off for a description of how to program in such an environment. |
Literature |
Related Literature
|
|
|
|
|
Updated 01-27-2005 |
