WWW 205 Web Database Management Course syllabus

I.

II.

Course Prerequisite:

III.

Course Description:

IV.

Learning Objectives:

1. Explain the strategies used to enable Web applications to interact with various data sources.
2. Locate and evaluate Internet resources that provide technical information on how to create and maintain data-driven Web applications.
3. Describe Methods used to create a connection to a data source.
4. Identify the objects, properties, and events within the Data Model.
5. Use basic SQL commands within a Web application.
6. Create Web sites that display, insert, modify, and delete data from a database.
7. Explain various client and server programming techniques required to manipulate data from the data source.
8. Explain various tools available that can be used to create database-driven Web applications.
9. Identify business applications that utilized data-driven Web applications.
10. Describe Methods used to secure the data within the Web database.

V.

Academic Integrity:

VI.

Outline of Topics:

1. Overview of Web database processing
   1. Client-side processing
   2. Server-side processing
   3. Internet protocols and standards
      1. XML, SOAP, HTTP, HTML
2. Internet resources that relate to Web database processing
   1. Web sites
   2. Discussion lists
3. Create Web page forms to collect data
   1. Data validation techniques
   2. Processing a form using server scripts
4. Creating a connection to a data source
   1. Data Source Names (DSN)
   2. Connection Strings
   3. Connecting to an Access database
   4. Connecting to data sources (such as a SQL Server database)
5. Introduction to Structured Query Language (SQL)
   1. Select Queries
   2. Insert, Delete, Update Queries
   3. Calculations and Group functions
6. Data Models
   1. Data objects, properties, and events (such as ADO/ADO+)
   2. Using objects to retrieve data (AD)/ADO+)
7. Create Web sites that interact with the database
   1. Built-in functions
8. Client programming to display and manipulate data
   1. Using client controls that interact with the database (such as ActiveX controls)
   2. Working with disconnected recordsets
9. Server programming to display and manipulate data
   1. Use server-side programming (such as Active Server Pages)
   2. Data binding with server controls
   3. Debugging and error handling techniques
10. Tools to create database-driven Web applications such as:
    1. Programming applications (such as Visual Studio)
    2. Office applications (such as Microsoft Access, FrontPage)
    3. tdird-party products (such as UltraDev, ColdFusion)
11. Identify business applications that utilize data-driven Web applications such as:
    1. Building a membership Web site
    2. Building an online catalogue
    3. Building a shopping cart
    4. Other business-related Web database applications
12. Security
    1. Encryption Standards
    2. Security Protocols
    3. Programming-based security
    4. Database security
13. Current Topics

VII.

Methods of Instruction:

VIII.

Course Practices Required:

1. Attend seminars as scheduled
2. Read Course materials: textbook and current journals
3. Complete required assignments, projects, and tests
4. Attend and participate in 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.

• listen and give careful consideration to all ideas expressed in class, especially tdose that are different from our own, without attacking or demeaning the people who have tdose views, and
• avoid using insulting terms or telling offensive jokes when talking to or about individuals or groups.

IX.

Instructional Materials:

X.

Methods of Evaluating Student Progress:

XI.

Other Course Information:

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:

1. make copies of software for yourself or others.
2. receive and use unautdorized 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.