Students' Syntactic Mistakes in Writing Seven Different Types of SQL Queries and its Application to Predicting Students' Success

The computing education community has studied extensively the errors of novice programmers. In contrast, little attention has been given to student's mistake in writing SQL statements. This paper represents the first large scale quantitative analysis of the student's syntactic mistakes in writing different types of SQL queries. Over 160 thousand snapshots of SQL queries were collected from over 2000 students across eight years. We describe the most common types of syntactic errors that students make. We also describe our development of an automatic classifier with an overall accuracy of 0.78 for predicting student performance in writing SQL queries.

[1]  Raymond Lister,et al.  A Quantitative Study of the Relative Difficulty for Novices of Writing Seven Different Types of SQL Queries , 2015, ITiCSE.

[2]  Ian H. Witten,et al.  Generating Accurate Rule Sets Without Global Optimization , 1998, ICML.

[3]  David W. Stemple,et al.  Human factors comparison of a procedural and a nonprocedural query language , 1981, TODS.

[4]  R. B. Buitendijk.  Logical errors in database SQL retrieval queries , 1988 .

[5]  Phyllis Reisner,et al.  Use of Psychological Experimentation as an Aid to Development of a Query Language , 1977, IEEE Transactions on Software Engineering.

[6]  Raymond Lister,et al.  The backwash effect on SQL skills grading , 2004, ITiCSE '04.

[7]  Stefan Brass,et al.  Semantic errors in SQL queries: a quite complete list , 2004, Fourth International Conference onQuality Software, 2004. QSIC 2004. Proceedings..

[8]  Vladimir Zadorozhny,et al.  Learning SQL Programming with Interactive Tools: From Integration to Personalization , 2010, TOCE.

[9]  Antonija Mitrovic,et al.  An Intelligent SQL Tutor on the Web , 2003, Int. J. Artif. Intell. Educ..

[10]  Stefan Brass,et al.  Semantic errors in SQL queries: A quite complete list , 2006, J. Syst. Softw..

[11]  Ian H. Witten,et al.  The WEKA data mining software: an update , 2009, SKDD.

[12]  Julia Prior,et al.  AsseSQL: an online, browser-based SQL skills assessment tool , 2014, ITiCSE '14.

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

[14]  Charles Welty,et al.  Correcting User Errors in SQL , 1985, Int. J. Man Mach. Stud..

[15]  MitrovicAntonija.  Learning SQL with a computerized tutor , 1998 .

[16]  Xin Zhou,et al.  An open integrated exploratorium for database courses , 2008, ITiCSE.

[17]  John B. Smelcer,et al.  User errors in database query composition , 1995, Int. J. Hum. Comput. Stud..