What to Expect and What to Focus on in SQL Query Teaching
Taipalus, T., & Perälä, P. (2019). What to Expect and What to Focus on in SQL Query Teaching. In SIGCSE '19 : Proceedings of the 50th ACM Technical Symposium on Computer Science Education (pp. 198-203). Association for Computing Machinery. https://doi.org/10.1145/3287324.3287359
© 2019 ACM.
In the process of learning a new computer language, writing erroneous statements is part of the learning experience. However, some errors persist throughout the query writing process and are never corrected. Structured Query Language (SQL) consists of a number of different concepts such as expressions, joins, grouping and ordering, all of which by nature invite different possible errors in the query writing process. Furthermore, some of these errors are relatively easy for a student to fix when compared to others. Using a data set from three student cohorts with the total of 744 students, we set out to explore which types of errors are persistent, i.e., more likely to be left uncorrected by the students. Additionally, based on the results, we contemplate which types of errors different query concepts seem to invite. The results show that syntax and semantic errors are less likely to persist than logical errors and complications. We expect that the results will help us understand which kind of errors students struggle with, and e.g., help teachers generate or choose more appropriate data for students to use when learning SQL ...
PublisherAssociation for Computing Machinery
Parent publication ISBN978-1-4503-5890-3
ConferenceACM Technical Symposium on Computer Science Education
Is part of publicationSIGCSE '19 : Proceedings of the 50th ACM Technical Symposium on Computer Science Education
Publication in research information system
MetadataShow full item record
Showing items with similar title or keywords.
Error messages in relational database management systems : A comparison of effectiveness, usefulness, and user confidence Taipalus, Toni; Grahn, Hilkka; Ghanbari, Hadi (Elsevier BV, 2021)The database and the database management system (DBMS) are two of the main components of any information system. Structured Query Language (SQL) is the most popular query language for retrieving data from the database, as ...
NewSQL Database Management System Compiler Errors : Effectiveness and Usefulness Taipalus, Toni; Grahn, Hilkka (Taylor & Francis, 2022)Modern database management is often faced with a high number of concurrent end-users, and the need for database distribution to ensure fault tolerance and high throughput. To flexibly address these challenges, many modern ...
Explaining Causes Behind SQL Query Formulation Errors Taipalus, Toni (IEEE, 2020)This Full Research Paper presents the most prominent query formulation errors in Structured Query Language (SQL), and maps these errors to their cognitive explanations. Understanding query formulation errors is a key to ...
The Effects of Database Complexity on SQL Query Formulation Taipalus, Toni (Elsevier, 2020)In Structured Query Language (SQL) education, students often execute queries against a simple exercise database. Recently, databases that are more realistic have been utilized to the effect that students find exercises ...
Corrective feedback and learner uptake in an EFL classroom Surakka, Kati (2007)