Providing Insight into SQL
James Reye · Journal of Educational Technology Systems · 1996
SQL is the well-known, industry-standard language for accessing relational databases. Although users often have no trouble writing simple queries in SQL, most people experience difficulties in correctly formulating and understanding more complex queries. To help users gain a greater insight into SQL, a special interface has been developed. This is intended as a support tool for introductory database courses. This system provides two special facilities: 1) a progressive execution option, which allows the user to receive immediate feedback on an SQL query as it is being entered on a word-by-word basis; and 2) additional windows which allow the user to view an illustration of what is occurring inside an SQL query, as well as the final results.