For this test, you may bring one sheet (8.5" x 11") of handwritten notes. This is the rough outline of the topics that you will be tested on. Study chapters 8, 13 from your book, the notes handed out in class and the notes on AJAX on the web.

SQL and MySQL

• Using SQL write code to create and delete tables
• Using SQL write code to insert or update data in a table
• Using SQL write code to query for data from table(s)
• Write PHP code to access to a MySQL database to insert, update, delete or query for data and display results in tabular form

XML

• Determine if a piece of XML code is well formed
• Write an XML DTD or Schema from a given specification
• Write an XML data set that conforms to a given DTD or Schema
• Write an XSLT stylesheet that displays the data in a XML file in either linear or tabular form

AJAX

• Create a simple AJAX application for a given specification. The application will involve making a call to the server, obtaining information from the server, and then updating the HTML page.