Web Database Programming

Course: CS 290B
Title: Web Database Programming
Prerequisite(s): None
Corequisite(s):
Credit: Class 3, Credit 3

This course is for students who are not Computer Science majors, but who would like to learn some very useful CS topics in one semester. It starts with Java -- the current major academic and industrial programming language. The amount of Java covered is a 9-week subset directed toward Graphical User Interfaces (GUIs) and Internet and Web applications. Next, the course teaches 5 weeks of Perl -- a language used for Web programming and demonstrative of a whole class of useful scripting languages. The course concludes with a week of how to use the Structured Query Language (SQL) to manipulate databases via the Web.

Catalog Description:

An introduction to Java programming including basic language features, classes, objects, and methods. An introduction to Perl programming directed toward using Perl with Web-based CGI applications. Database access through Java Server Pages (JSP) and Structured Query Language (SQL). This course is intended for students with no previous programming experience and is not open to CS majors.

List of Topics (by week):

Java Programming --

1. Introduction to Programming Languages

2. Object-Oriented Programming: Classes, Objects, and Methods

3. Primitive Type and Strings

4. Expressions, Statements, and Blocks

5. Flow of Control

6. Applets

7. Building a Graphical User Interface (GUI)

8. Image Manipulation and Animation

9. Java Server Pages, Servlets, and Data Manipulation

Perl --

10. Data, Operators, Statements, Blocks, and Scope

11. Conditionals, Loops, Arrays, Array Operators, and Hashes

12. Subroutines, Functions

13. String Manipulation

14. Working with Web Forms and Data

Structured Query Language (SQL) --