WWW 145 Introduction To Database Driven Web Sites Course syllabus

I.

II.

Course Prerequisite:

III.

Course Description:

This class will provide a general introduction to the basic framework of a database driven web site. Students will use sample databases and a popular, industry standard software tool for creating site definitions and to plan, develop, and implement a web database application.

IV.

Learning Objectives:

The student who successfully completes this course must:

1. Understand the basic framework of a data-driven web site and how databases are used to support web sites.
2. Demonstrate understanding of dynamic web site fundamentals by successfully creating the individual components that lead to a web database application.
3. Have the ability to use a web editor and a web database server to plan, develop, and implement a web-based application.
4. Demonstrate a basic proficiency in implementing a performance overview including beta and usability testing on web database applications.

 

V.

Academic Integrity:

VI.

Outline of Topics:

1. Dynamic Web Site Fundamentals

   1. Basic components
   2. Development requirements
      • Developing with a local server
      • Developing with a remote server
   3. Site definition using web application development software

    

   Passing Data Between Web Pages

   1. The HTTP protocol
   2. Differences between “GET” and “POST”
   3. Encoding and retrieving query strings or URL variables
   4. Encoding and retrieving cookies
   5. Using web forms to collect data

   Databases and Connectivity

   1. Web database overview
   2. How databases support web sites
   3. Web and database connectivity basics

   Dynamically Populating Web Forms with Database Data

   1. Filtering and displaying data
   2. Creating a web page database lookup application
   3. Filtering a query using dynamic data

    

   Building Web Applications

   Web Application Types & Uses

   • Building User Level Authentication & Registration Tools
     1. User login
     2. Setting user profiles
     • Creating user levels
     • Restricting access to web pages
     • New user registration pages

   Building Administrative Level Pages

   1. Building a Master Detail Page Set
   2. Building the content Insert, Update, and Delete Tools

    

   Beta Testing

   Usability Testing

VII.

Methods of Instruction:

1. Program demonstrations, hands-on usage, textbook reading, applicable web sites, lecture, class discussions, group work, and guest speakers will be used.

VIII.

Course Practices Required:

•  Attend seminars as scheduled.

•  Complete required assignments and tests where applicable.

•  Attend lab as required

The Oakton Community College Catalog states:

The Oakton Community College does not discriminate on the basis of race, color, creed, religion, national origin, disability, age, sex, sexual orientation, or marital status in admission to and participation in its educational programs, College activities and services, or employment practices. The College does not tolerate sexual harassment or sexual assault by or of its students or employees.

In keeping with this policy of tolerance and non-discrimination, in this class all of us should strive to:

•  listen and give careful consideration to all ideas expressed in class, especially those that are different from our own, without attacking or demeaning the people who have those views, and

IX.

Instructional Materials:

X.

Methods of Evaluating Student Progress:

Tests
Class Assignments
Lab Assignments
Attendance and Participation               

XI.

Other Course Information:

Tutors

Faculty tutors and student tutors are available in the Learning Center on both campuses and the 2600 labs on the Des Plaines campus. Check the following website for the days and times when tutors are available

Des Plaines: http://www.oakton.edu/resource/iss/tutschdp.htm

Skokie:
http://www.oakton.edu/resource/iss/tutschrhc.htm

Users of the College's information technology facilities and resources, including hardware, software, networks, and computer accounts, are expected to use these resources responsibly and appropriately, respecting the rights of other information technology users and respecting all contractual and license agreements.

Software Users! Copying software is in violation of Federal law and College policies. Suspected violations will be vigorously investigated and if warranted, appropriate penalties applied.

Specifically, you do not have the right to:

•  make copies of software for yourself or others.

•  receive and use unauthorized copies of software.

If you have a documented learning, psychological, or physical disability you may be entitled to reasonable academic accommodations, or services. To request accommodations or services, contact the ASSIST office in Instructional Support Services. All students are expected to fulfill essential Course requirements. the College will not waive any essential skill or requirement of a Course or degree program.

Other Requirements

All students are responsible to check the course online page frequently for various announcements, weekly topics, assignments and the due dates.

Effective beginning term: Fall, 2005 End term: ________________

Syllabus prepared by: Martinique Johns/Kitty Tabers 10/20/04

Reviewed by program chair: Kitty Tabers 10/20/04