SQL Online Tutor

Running the tutor

• Start my Basic SQL book

Updating the tutorial

• List all the tasks in my basic SQL book

Application code

• The book table definition
• The task table definition
• Javascript functions
• PHP functions
• listtasks.php
• updatetask.php
• learnsql.php
• executesql.php

Bugs

• change to posts - get only for testing and on links
• cant get clean listings to be displayed? - done - save files as phps
• Javascript problem with popups - done - but still problem with javascript: code - workaround using onclick
• need to url encode query in popups for + in select - done- but escape isnt good enough
• Task id/seqno number is a mess - redesigned - but still not happy
• Classify tasks - explanation, example, exercise - or just code in the definition? - no this is required - could link to an icon to help flag the action required - t_type added
• problems with popup hinttext - done with a bit of string manipulation
• problems with exercise structure - its too restrictive and needs to be freed up to allow blocks in different orders - re-analyse as blocks - text with a heading and body [ inline, or popup] - sql - sql result - inline or popup - query entry - diagnostic - navigation based on diagnostics need to cast the mannheim book into the current form to see where it breaks - could use XML here instead - version 2

Work to do

• Set up at least one style sheet - done
• Move tasks to their own database - its still on keeny - but oK there
• Code up the Mannheim workbook
• Multiple exercise sets - called books
• Allow multiple databases within an exercise - no but book specifies a server/user/database
• Allow multiple DBMS - Oracle first then SQL Server ? Access - default is MySQL
• Error diagnostics and hinting - hint may be only after incorrect result
• Security on task database