The purpose of this set of web pages is to demonstrate knowledge of building Microsoft Excel based solutions, data structure design and live querying on data tables (MySQL and MS SQL).
This page is an interactive demonstration of a set of live SQL queries.
Please select a staff member's name from the dropdown list at the foot of the page and click the 'Submit' button.
The resultant output demonstrates that the data is being extracted from the database and is not a set of pre-written HTML tables.
Click the button below to advance to the next stage
Or use the above 'SQL Queries' dropdown menu to jump to any stage.