This application is designed to help students learn SQL. It supports any number of worksheets.
Each worksheet explores an aspect of the SQL language. A worksheet contains multiple steps which the student will work through. There are several kinds of step.
Here are a couple of worksheets - more are being developed.
The student is free to move around the worksheets and between steps in a worksheet at will. However they are encouraged to follow the steps in order, and to try to get a correct answer to each exercise.
Model SQL statements are shown with reserved words in upper-case, user-defined words in lower-case. This is purely for explanatory purposes since SQL is not case-sensitive. However, table names must be entered in the same case as that used in the database creation because they correspond to UNIX file names.
Model SQL statements are terminated with a semi-colon but this is optional in this interface.
When there is a difference between the result of the query generated by the student's statement and the model answer statement, the application attempts to diagnose the problem. Some of this is automatic, based on a comparison of the resultant tables and the two SQL statements (rudimentary at present). These are combined with authored, step-specific hints.
Comparison between the two results allows for different headings (because columns may be aliased) and different column ordering, since column order is not significant . Where the results are equivalent but there is a difference between the student's SQL statement and the model answer, the model answer statement is also output for reference.
This application does not require any registration so we are not tracking the performance of individual students. However all input is logged so that tutors can identify common problems with exercises and improve the hints provided .
The database and back-end server to be used to execute SQL statements is defined in the worksheet configuration. This is limited to databases running on a MySQL 5.1 server at the University. The client has only select access to the database.
Worksheets are written in an XML vocabulary and may be hosted within the XML database or accessed externally.
This application has been created by Chris Wallace to whom all queries or suggestions for improvement should be addressed. The application is written in XQuery running an eXist XML database, in which the XML descriptions of each worksheet are held.
You can use the following keys to move about a worksheet and link to related resources: