CPT 250 Database Programming
Mrs. Heckel
Tech 105A
 sheckel@stchas.edu
 636.922.8568
www.stchas.edu/faculty/sheckel


General Course Information

CATALOG DESCRIPTION:   Special topics course about how to program in a commercially popular database language (using SQL), and integrating databases for the Web.

Credit Hours:      3

TEXT (required):      Marc Wandschneider
                                Web Application Development with PHP and MySQL
                                Pearson Education; Upper Saddle River, NJ; 2006

Time of Class:         Spring 2007    Section 80    Tuesday/Thursday 5:30-6:50 pm


Course Objectives:
Students with special needs: We all have various channels through which we learn best. The College has an Office of Accessibility Services that guides, counsels, and assists students with disabilities. It is located in Room 1206 of the Administration Building. It is your responsibility to discuss with the instructor during the first week of class anything needed to help you succeed. If you have special needs, please call Pam Bova (922.8247) in the Office of Accessibility Services so that your eligibility for services can be determined.

SCC also offers mental health counseling.  If you need help with depression, anger, domestic violence, stress, addiction, eating disorder, or anxiety, please contact Mary Hall at 636.288.6533.  Her office is located at ADM 1204.
What the teacher expects from each student

Attendance Policy

Each student is expected to attend all classes.  The fact that some of the course is hands-on makes attendance at class even more important.  If absence is unavoidable, the student is expected to have the textbook material read and any class assignments completed before returning to the next schedule class.  Failure to do this will cause the inability to keep up with the class material being discussed.
DO NOT call or e-mail the teacher to find out what we covered in a class that you missed. 
This information should be obtained from the course timetable and/or a classmate.


Course Requirements
What the student can expect from the teacher

Office Hours:       

Monday 8:00-11:00 am
Tuesday/Thursday 11:30-1:00 pm & 5:00-5:30 pm
Also available by appointment


Returning assignments/tests to the student

Every effort will be made for all assignments to be returned to all students within one week of the test date or assignment’s due date.

Grading Scale:  
A
 93-100
 Attendance
 15%
B
 85-92
 Exams*
 30%
C
 75-84
 Hands-on Assignments
 40%
D
 65-74 Final Exam
 20%
F
 below 65%

*the lowest grade will not be calculated

 
All written work



Attedance:

 Because much of this class is hands-on, missing a class means taking time from other students while the instructor tries to catch you up on what you missed.  Also, most students will not have access to the required software off campus, so most hands-on work will need to be done in the classroom.

Hands-On Assignments

You will write a 2-3 page paper (it will count as a test grade) comparing any two of the following:  Perl, ASP, Javascript, VBScript.  Be sure to write it so that Business Managers can understand what you mean (as if you were trying to "sell" management on incorporating one of the two languages).


Exams

Exams in this class will be done via WebCT, but not from the classroom.  See the tentative time table for exam due dates and chapters involved.  Exams will be true/false, multiple choice, and --especially-- debugging code.  Since the exams are not taken on specific dates in the classroom, there is no need to accommodate make-up tests.

Final Exam

The final exam will be a project/program.  The details will be distributed soon after mid-term, so you'll know what you need to do, and how it will be graded.  The final exam will be due during final exam week, but will be accepted earlier if you wish.
Withdrawal dates and related policies

Last day to change from credit to audit or audit to credit
 Feb 9
Last day to drop and receive a "W"
 Mar 23
Last day to apply for Aug 2007 graduation
 Jun 7


Tentative Time Table

Tues Thurs Chapter Topic Online
Test due
1/16
Introduction to the course

1/18 8 & 10
 Introduction to Databases
Storing/Retrieving Data
1/23
8 & 10


1/25 9 & 11
 Designing/Creating Databases
Advanced Data Access
1/30
9 & 11


2/1
 Hands-on SQL assignment
2/6
1
 Getting Started with PHP
 8-10

2/8
 2 & 3
 The PHP Language
Code Organization and Reuse
2/13
2 & 3
9-11

2/15
 4 & 5
 Object-Oriented Programming
Working with Arrays
2/20
4 & 5


2/22
 6 & 7
 Strings and Characters
Interacting with Server:  Forms
 1-2-3
2/27
6 & 7


3/1
 12
 PHP and Data Access
3/6
12
4-5

3/8
 Catch-up day
3/13
 3/15
 No Classes -- Spring Break
3/20
13 & 14
 Web Applications and the Internet
Implementing a User Interface
 6-7

3/22
 13 & 14

3/27
15 & 16
 User Management
Planning and Code Security
 12

3/29
 15 & 16

4/3
17 & 20
 Securing your Web Applications
User Authentication
 13-14

4/5
 17 & 20

4/10
18
 Error Handling and Debugging
 15-16

4/12
 18

4/17
19 & 22
 Cookies and Sessions
Data Validation
 17-20

4/19
 19 & 22

4/24
24 & 25
 Files & Directories
File Uploading
 18

4/26
 24 & 25

5/1
26 & 29
 Working with Dates and Time
Development and Deployment
 19-22

5/3
 26 & 29

5/8
 5/10
 Final Exams:  Project is due
 24-25