CISC224 Web Databases

Department of Science, Technology, Engineering & Mathematics: STEM Department Archive

I. Course Number and Title
CISC224 Web Databases Course No Longer Offered
II. Number of Credits
3 credits
III. Number of Instructional Minutes
2250 minutes
IV. Prerequisites
CISC215 (C or better) or VAMM110 (C or better)
V. Other Pertinent Information
The use of hands-on development is tightly integrated into the presentation of the course materials. Students will be evaluated in various methods including, but not limited to, exercises, written tests, and various programming projects that will be completed out of the classroom.
VI. Catalog Course Description
This course covers the development and utilization of web-enabled databases. Students will use Relational database as a backend to a web delivered interface. Both Client-side and Server-side processing will be used to create dynamic web pages.
VII. Required Course Content and Direction
  1. Course Learning Goals

    1. create and maintain database for web interaction.
    2. retrieve, insert, update and delete data.
    3. control data/user access.
    4. utilize HTML to develop user interface
    5. handle runtime errors
    6. control transactions with both Client-side and Server-side scripts.
    7. describe use of compiled Web Server programs.
    8. use basic SQL *Plus commands to select and modify existing records in a data base.
  2. Planned Sequence of Topics and/or Learning Activities

    1. Foundations
      1. Web basics, protocols, web addresses
      2. Theoretical, Conceptual and Physical Aspects of RDBMS.
      3. Need for creating dynamic web pages
    2. RDBMS
      1. Overview
      2. Mechanics of using our system
      3. Creating, Inserting and Updating databases
    3. Structured Query Language
      1. Creating queries
      2. Performing Calculations
    4. HTML
      1. Basic tags
      2. Tables
      3. Hyperlinks
    5. Web Servers
      1. Installing and Using Personal Web Server
      2. Accessing our WebServerrr
      3. Site Performance factors
      4. Utilization of our WebServer with RDBMS
    6. Programming Choices
      1. Languages that work with the web (Java, C#,.net)
      2. Other application programs that help in development (Cold Fusion, PHP, etc)
    7. Client-side Scripts
      1. Forms
      2. VBScript vs. JavaScript
      3. Use of Cookies
      4. Debugging Techniques
    8. Server-side Scripts
      1. ASP
      2. Creating a Web Application
    9. Compiled Web Server Programs
      1. Common Gateway Interface
      2. Active X DLLs
  3. Assessment Methods for Course Learning Goals

  4. Reference, Resource, or Learning Materials to be used by Student:

    Departmentally selected textbook. Details provided by the instructor of each course section. See Course Format.

Review/Approval Date -3/02