CS 355 Student Resources, Spring 2009

Links: [Course Home] [Course Info] [Course Schedule] [Resources] [WebCT]

This page will be updated throughout the semester as projects are assigned. CS 355 students: if you find a good resource online, please let me know, and I will add it to this page.

[Textbook errata]

HTML, XHTML, and XML tutorials and references

  1. The two HTML and XHTML tutorials are are easy to read and follow. If you are new to XHTML, read them chunks at a time and experiment with them by writing sample web-pages before moving on.
  2. The tutorials at HTML Dog are also user-friendly.
  3. Web authoring FAQ
  4. Elizabeth Castro, HTML, XHTML & CSS, 6th edition, Peachpit Press, 2007. This title is available through the library's online eBooks service. Just search for the title as you would for any regular book to find and access it online.
  5. This is a good starting point to learn XML. It contains a number of links to other XML tutorials.

PHP sample files

Most of these files have the extension *.php.txt so that you can read the PHP code. You would change the extension to .php to actually run the code.

  1. This simple PHP script connects to our Oracle server and queries the table "Employee."
  2. This PHP script demonstrates the use of "GET" as a form submission method.
  3. This PHP script demonstrates some features of PHP and how to it use to interact with the users.
  4. This tarfile contains two PHP scripts that demonstrate session tracking.
  5. This PHP script demonstrates the use of objects in PHP.
  6. This PHP script demonstrates the use of checkboxes and radio-buttons in PHP.

PHP and OCI references

  1. [NEW!] The SSU CS Club's PHP resource list (Thanks, David!)
  2. FAQ on PHP and Oracle
  3. More information on the OCI functions
  4. PHP manual with a very nice GUI and sample code
  5. PHP input validation code samples
  6. The PHP filter function for input validation

PL/SQL References

  1. Your textbook authors' short PL/SQL guide
  2. Oracle's PL/SQL technology center
  3. Oracle PL/SQL samples
  4. You can access many O'Reilly books for free electronically through the SSU library; this search for PL/SQL references shows three books available electronically.
  5. PL/SQL user's guide and reference

SQL Tutorials

  1. Oracle/SQL tutorial from UC Davis
  2. Oracle/SQL tutorial from your textbook authors at Stanford University. Particularly interesting is the page about how Oracle differs from the SQL standard.
  3. This is an interesting introduction to SQL.
  4. Oracle dates and times:

Scripts for Creating and Populating Oracle Tables

This tar-ball contains an sql script for creating sample database tables. In addition, it contains data and control files for populating these tables using Oracle's sqlldr.

Thanks to Dr. Kooshesh for much of this material.