Learning SQL in steps

Learning SQL is a common problem for many Computer Science (CS) students, the steps involved are quite different to those mastered when learning procedural or object-oriented programming languages. The introduction of commercial products that include shortcuts into the learning environment can initially appear to benefit the student, however, transferring these skills to a textual environment can be difficult for many students. Computer Science students are required to build textual SQL queries because the demands of complex queries can quickly out grow the capabilities of graphical query builders available in many software packages. SQL in Steps (SiS) is a graphical user interface centred around the textual translation of a query; this combination of a GUI and a clear representation of its textual meaning has the potential to improve the way in which users gain an understanding of SQL. SiS allows for an incremental and evolutionary development of queries by enabling students to build queries step by step until their goal is reached. A planned evaluation of SiS hopes to quantify the extent to which the introduction of such a user interface into the learning environment can improve the students’ understanding of the language.

[1]  Victor Matos,et al.  The case of the missing tuple: teaching the SQL outer-join operator to undergraduate information systems students , 2006 .

[2]  Chris J. H. Fowler,et al.  Learning technology and usability: a framework for understanding courseware , 1999, Interact. Comput..

[3]  Julia Coleman Prior Online Assessment of SQL Query Formulation Skills , 2003, ACE.

[4]  Ben Shneiderman,et al.  Improving the human factors aspect of database interactions , 1978, TODS.

[5]  John Cigas,et al.  Experiences with online SQL environments , 2010 .

[6]  T. Gog,et al.  Effects of worked examples, example-problem, and problem-example pairs on novices learning , 2011 .

[7]  Umberto Ferraro Petrillo,et al.  SAVI: a new system for advanced SQL visualization , 2011, SIGITE '11.

[8]  Stijn Dekeyser,et al.  A System Employing Peer Review and Enhanced Computer Assisted Assessment of Querying Skills , 2007, Informatics Educ..

[9]  Alan Fekete,et al.  A teaching system for SQL , 1997, ACSE '97.

[10]  Carme Quer,et al.  LEARN-SQL: Automatic Assessment of SQL Based on IMS QTI Specification , 2008, 2008 Eighth IEEE International Conference on Advanced Learning Technologies.

[11]  Karen Renaud,et al.  Teaching SQL - Which Pedagogical Horse for This Course? , 2004, BNCOD.

[12]  Antonija Mitrovic,et al.  Learning SQL with a computerized tutor , 1998, SIGCSE '98.

[13]  Andrew Cumming,et al.  Improving the Student Learning Experience for SQL Using Automatic Marking , 2004, CELDA.

[14]  Wolfgang Gatterbauer,et al.  QueryViz: helping users understand SQL queries and their patterns , 2011, EDBT/ICDT '11.

[15]  Antonija Mitrovic,et al.  A Knowledge-Based Teaching System for SQL , 1998 .

[16]  Harriet J. Fell,et al.  From animation to analysis in introductory computer science , 1994, SIGCSE '94.

[17]  Suzanne W. Dietrich,et al.  WinRDBI: a Windows-based relational database educational tool , 1997, SIGCSE '97.