CSc 8711, Databases and the Web, Fall 2006

• Class Bulletin Board (You need to sign up)
• Course Syllabus
• Class Roster
• SSH
• Oracle 10g
  • SQLPlus FAQ
  • Oracle Data Dictionary Information
  • Oracle Commands
  • Code from Oracle 9i text
• PL/SQL Web Programming in Oracle
  • Oracle's PL/SQL Web Toolkit Notes
    
  • PL/SQL Web Toolkit Reference
  • Dynamic PL/SQL: Package DBMS_SQL, etc.
  • Flexible Parameter Passing in HTML Forms
• Java Servlets and Javascript
  • Java Servlets (Oracle 9i Primer - Chapter 7)
  • Servlet and JSP Tutorial
  • oracle.html (jweb) Package Reference
  • Javascript Reference
  • Javascript Examples
• XML
  • XML Basics (ppt pdf)
  • XML/Database Mappings (ppt pdf)
  • DTDs and XML Schema (ppt pdf)
  • XML Parsing APIs (ppt pdf)
  • XML Querying/Transformation
    • XPath (ppt pdf)
    • XSLT (ppt pdf) Java Servlet to apply xsl transform to xml file
    • XQuery (ppt pdf)
      Mail Order DB Queries, Mail Order Data Galax XQuery on tinman
  • XML Applications (ppt pdf)
• Web Services
  • Apache Axis setup on tinman
  • WSDL Essentials
    
  • WSDL Tutorial
    
  • Xmethods - publicly available web services
    
  • Invoking Web Services in Java - Overview
  • Apache Axis User Guide
• Ajax Example
• Programming Project 1(Due: September 8, 2006). Project1 Submission Instructions
• Programming Project 2 - Mini( Due: September 22, 2006).
  JDBC Connect String:

  Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@tinman.cs.gsu.edu:1521:tinman",user,pass);
  

• Programming Project 2(Due: October 13, 2006).
• Programming Project 3(Due: November 3, 2006).
• Programming Project 4(Due: November 17, 2006).
• Take Home XQuery quiz(Due: November 27, 2006). Submit screen capture under "quiz" using handin script.
• Programming Project 5(Due: December 1, 2006).
• Paper Requirement(Due: December 8, 2006).