Students' Semantic Mistakes in Writing Seven Different Types of SQL Queries

@inproceedings{Ahadi2016StudentsSM,
  title={Students' Semantic Mistakes in Writing Seven Different Types of SQL Queries},
  author={Alireza Ahadi and Julia Coleman Prior and Vahid Behbood and Raymond Lister},
  booktitle={ITiCSE},
  year={2016}
}
Computer science researchers have studied extensively the mistakes of novice programmers. In comparison, little attention has been given to studying the mistakes of people who are novices at writing database queries. This paper represents the first large scale analysis of students' semantic mistakes in writing different types of SQL SELECT statements. Over 160 thousand snapshots of SQL queries were collected from over 2300 students across nine years. We describe the most common semantic… CONTINUE READING

Figures, Tables, and Topics from this paper.

Citations

Publications citing this paper.
SHOWING 1-6 OF 6 CITATIONS

What to Expect and What to Focus on in SQL Query Teaching

VIEW 3 EXCERPTS
CITES BACKGROUND
HIGHLY INFLUENCED

Improving the Effectiveness of SQL Learning Practice: A Data-Driven Approach

  • 2018 IEEE 42nd Annual Computer Software and Applications Conference (COMPSAC)
  • 2018
VIEW 3 EXCERPTS
CITES BACKGROUND, METHODS & RESULTS

A Static Code Smell Detector for SQL Queries Embedded in Java Code

  • 2017 IEEE 17th International Working Conference on Source Code Analysis and Manipulation (SCAM)
  • 2017
VIEW 2 EXCERPTS
CITES BACKGROUND

Similar Papers