ITC280 "Web Database" introduces a student to server side web programming

Syllabus: Below is a short synopsis of the class syllabus. Students are recommended to download the complete syllabus, in word document form, Here!

Course Description: A hands-on, practical course introducing the techniques needed to create database driven web sites. The languages and methods used for database access will remain flexible to reflect current industry standard.

In this class students will work with the leading open source tools.  The database is MySQL. The server for the class runs the Apache web server on Linux, configured for PHP as the scripting environment.

Course Structure and Requirements

Materials:

Our book is PHP and MySQL by Larry Ullman (2nd Edition, please), (ISBN: 0321336577). Please view Homework page for required reading.

Grading (approximate, and subject to change without notification):

• Points may be deducted per day for late assignments.
• 20% Assignments
• 5% Pop Quizzes
• 20% Online Quizzes
• 50% Final Project (web site)
• 5% Participation/Teacher Discretion

Prerequisites:

• WEB110 and ITC110 with 2.0 or better
• Skills: Familiarity with HTML, Windows Operating System, basic knowledge of the use of computers and internet browsers
• Students must know how to use Windows Explorer (save, copy, delete, move files and work between windows) and be familiar with the process of FTP
• Prior programming experience required (ITC110)
• Prior database experience recommended

Competencies: After completing this class, a student will be able to:

• Design and build a dynamic database driven web site
• Demonstrate server side scripting skills in PHP
• Design and build a MySQL database to support the website, using the UNIX command line, and through a custom web interface
• Support user state and site security through the use of cookies and session state
• Design functions and include files using PHP and SQL query syntax

Student Expectations:

The Syllabus is a plan for the quarter and is subject to change at any time.

It is the student's responsibility to be aware of any changes by attending class. Assignments must be submitted by the due date, or points may be deducted.

It is extremely important that students attend each class and keep up with the reading and assignments. Please see "Homework" page for latest requirements.

Please check the website frequently for updates.