research-article

Open access

Identifying SQL misconceptions of novices: findings from a think-aloud study

Authors:

Daphne Miedema,

Efthimia Aivaloglou,

George FletcherAuthors Info & Claims

ACM Inroads, Volume 13, Issue 1

Pages 52 - 65

https://doi.org/10.1145/3514214

Published: 14 February 2022 Publication History

All formats PDF

First page of PDF

References

[1]

Ahadi, A., Behbood, V., Vihavainen, A., Prior, J., and Lister, R. Students' Syntactic Mistakes in Writing Seven Different Types of SQL Queries and its Application to Predicting Students' Success. In Proceedings of the 47th ACM Technical Symposium on Computing Science Education (2016), pp. 401--406.

Digital Library

[2]

Ahadi, A., Prior, J., Behbood, V., and Lister, R. A Quantitative Study of the Relative Difficulty for Novices of Writing Seven Different Types of SQL Queries. In Proceedings of the 2015 ACM Conference on Innovation and Technology in Computer Science Education (2015), pp. 201--206.

Digital Library

[3]

Ahadi, A., Prior, J., Behbood, V., and Lister, R. Students semantic mistakes in writing seven different types of SQL queries. In Annual Conference on Innovation and Technology in Computer Science Education, ITiCSE (2016), pp. 272--277.

Digital Library

[4]

Bayman, P., and Mayer, R. E. A diagnosis of beginning programmers' misconceptions of basic programming statements. Communications of the ACM 26, 9 (Sept. 1983), 677--679.

Digital Library

[5]

Beker, K., Kim, J., Van Boekel, M., van den Broek, P., and Kendeou, P. Refutation texts enhance spontaneous transfer of knowledge. Contemporary Educational Psychology 56 (2019), 67--78.

[6]

Blair, E. A reflexive exploration of two qualitative data coding techniques. Journal of Methods and Measurement in the Social Sciences 6, 1 (2015), 14--29.

[7]

Boulay, B. D. Some difficulties of learning to program. Journal of Educational Computing Research 2, 1 (1986), 57--73.

[8]

Brass, S., and Goldberg, C. Semantic errors in SQL queries: A quite complete list. Journal of Systems and Software 79, 5 (2006), 630--644.

Digital Library

[9]

Clancy, M. Computer Science Education Research. Taylor & Francis Group, 2004, ch. Misconceptions and attitudes that interfere with learning to program, pp. 85--100.

[10]

Dadashzadeh, M. A simpler approach to set comparison queries in SQL. Journal of Information Systems Education 14, 4 (2003), 345--348.

[11]

Fisler, K. The recurring rainfall problem. In Proceedings of the Tenth Annual Conference on International Computing Education Research (New York, NY, USA, 2014), ICER '14, Association for Computing Machinery, p. 35--42.

Digital Library

[12]

III, J.P. Smith, diSessa, A.A., and Roschelle, J. Misconceptions reconceived: A constructive analysis of knowledge in transition. Journal of the Learning Sciences 3, 2 (1994), 115--163.

[13]

Kaczmarczyk, L.C., Petrick, E.R., East, J.P., and Herman, G.L. Identifying student misconceptions of programming. In Proceedings of the 41st ACM Technical Symposium on Computer Science Education (New York, NY, USA, 2010), SIGCSE'10, Association for Computing Machinery, p. 107--111.

[14]

Kearns, R., Shead, S., and Fekete, A. A teaching system for SQL. In Proceedings of the 2nd Australasian Conference on Computer Science Education (New York, NY, USA, 1997), ACSE '97, Association for Computing Machinery, p. 224--231.

Digital Library

[15]

Ma, L., Ferguson, J., Roper, M., and Wood, M. Investigating and improving the models of programming concepts held by novice programmers. Computer Science Education 21, 1 (2011), 57--80.

[16]

Matos, V. M., and Grasser, R. A simpler (and better) SQL approach to relational division. Journal of Information Systems Education 13, 2 (2002), 85--88.

[17]

McCall, D., and Kölling, M. Meaningful categorisation of novice programmer errors. In 2014 IEEE Frontiers in Education Conference (FIE) Proceedings (2014), pp. 1--8.

[18]

Miedema, D. Towards successful interaction between humans and databases. Msc thesis, Eindhoven University of Technology, 2019.

[19]

Ogden, W. C., and Brooks, S. R. Query languages for the casual user. In Proceedings of the SIGCHI conference on Human Factors in Computing Systems - CHI '83 (New York, New York, USA, 1983), ACM Press, pp. 161--165.

Digital Library

[20]

Pea, R. D. Language-independent conceptual "bugs" in novice programming. Journal of Educational Computing Research 2, 1 (1986), 25--36.

[21]

Presler-Marshall, K., Heckman, S., and Stolee, K. T. Sqlrepair: Identifying and repairing mistakes in student-authored sql queries. In 2021 IEEE/ACM 43rd International Conference on Software Engineering: Software Engineering Education and Training (ICSE-SEET) (2021), IEEE, pp. 199--210.

Digital Library

[22]

Putnam, R. T., Sleeman, D., Baxter, J. A., and Kuspa, L. K. A summary of misconceptions of high school basic programmers. Journal of Educational Computing Research 2, 4 (1986), 459--472.

[23]

Qian, G. Teaching SQL: A divide-and-conquer method for writing queries. J. Comput. Sci. Coll. 33, 4 (Apr. 2018), 37--44.

[24]

Qian, Y., and Lehman, J. Students' misconceptions and other difficulties in introductory programming: A literature review. ACM Transactions on Computing Educaction 18, 1 (Oct. 2017).

Digital Library

[25]

Scherz, Z., Goldberg, D., and Fund, Z. Cognitive implications of learning prolog---mistakes and misconceptions. Journal of Educational Computing Research 6, 1 (1990), 89--110.

[26]

Shin, S. Structured query language learning: Concept map-based instruction based on cognitive load theory. IEEE Access 8 (2020), 100095--100110.

[27]

Smelcer, J. B. User errors in database query composition. International Journal of Human-Computer Studies 42, 4 (1995), 353--381.

Digital Library

[28]

Sorva, J. The same but different students' understandings of primitive and object variables. In Proceedings of the 8th International Conference on Computing Education Research (New York, NY, USA, 2008), Koli '08, Association for Computing Machinery, p. 5--15.

Digital Library

[29]

Sorva, J. Visual Program Simulation in Introductory Programming Education. PhD thesis, Aalto University, Espoo, Finland, 2012.

[30]

Swidan, A., Hermans, F., and Smit, M. Programming misconceptions for school students. In Proceedings of the 2018 ACM Conference on International Computing Education Research (New York, NY, USA, 2018), ICER '18, Association for Computing Machinery, p. 151--159.

[31]

Taipalus, T. Explaining Causes behind SQL Query Formulation Errors. Proceedings - Frontiers in Education Conference (2020), 1--9.

Digital Library

[32]

Taipalus, T., and Perälä, P. What to expect and what to focus on in SQL query teaching. In SIGCSE 2019 - Proceedings of the 50th ACM Technical Symposium on Computer Science Education (2019), pp. 198--203.

Digital Library

[33]

Taipalus, T., and Seppänen, V. SQL education: A systematic mapping study and future research agenda. ACM Trans. Comput. Educ. 20, 3 (Aug. 2020).

Digital Library

[34]

Taipalus, T., and Siponen, M. Errors and Complications in SQL Query Formulation. ACM Transactions on Computing Education 18, 3 (2018).

[35]

Welty, C. Correcting user errors in SQL. Tech report, 1985.

[36]

Welty, C., and Stemple, D. W. Human factors comparison of a procedural and a nonprocedural query language. ACM Transactions on Database Systems 6, 4 (dec 1981), 626--649.

Digital Library

[37]

Whalley, J., and Kasto, N. A qualitative think-aloud study of novice programmers' code writing strategies. ITICSE 2014 - Proceedings of the 2014 Innovation and Technology in Computer Science Education Conference (2014), 279--284.

Digital Library

[38]

Zingaro, D., Taylor, C., Porter, L., Clancy, M., Lee, C., Nam Liao, S., and Webb, K. C. Identifying student difficulties with basic data structures. In Proceedings of the 2018 ACM Conference on International Computing Education Research (New York, NY, USA, 2018), ICER '18, Association for Computing Machinery, p. 169--177.

Cited By

Zhou YMagana ALi TStone JYuen TShoop LRebelsky SPrather J(2025)Facilitating Student's Learning Transfer in a Database Programming ClassProceedings of the 56th ACM Technical Symposium on Computer Science Education V. 110.1145/3641554.3701828(1330-1336)Online publication date: 12-Feb-2025
https://dl.acm.org/doi/10.1145/3641554.3701828
Wang JChen STang ZLin PWang Y(2025)Enhancing SQL programming education: addressing cheating challenges in online judge systemsEducation and Information Technologies10.1007/s10639-024-13228-330:1(715-745)Online publication date: 1-Jan-2025
https://dl.acm.org/doi/10.1007/s10639-024-13228-3
Amiruddin MSamsudin ASuhandi ACostu B(2024)Bibliometric Investigation in Misconceptions and Conceptual Change Over Three Decades of Science EducationInternational Journal of Educational Methodology10.12973/ijem.10.3.367volume-10-2024:volume-10-issue-3-august-2024(367-385)Online publication date: 15-Aug-2024
https://doi.org/10.12973/ijem.10.3.367
Show More Cited By

Recommendations

Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud Study
ICER 2021: Proceedings of the 17th ACM Conference on International Computing Education Research

SQL is the most commonly taught database query language. While previous research has investigated the errors made by novices during SQL query formulation, the underlying causes for these errors have remained unexplored. Understanding the basic ...
Sql: Learn Basics of Queries and Implement Easily (sql programming, SQL 2016, sql database programming, sql for beginners, sql beginners guide, sql ... sql workbook, sql guide, MSSQL) (Volume 1)
SQL: The Complete Reference, Second Edition

Comments

Information & Contributors

Information

Published In

cover image ACM Inroads

ACM Inroads Volume 13, Issue 1

March 2022

62 pages

ISSN:2153-2184

EISSN:2153-2192

DOI:10.1145/3519006

Editors:
Margaret Hamilton
RMIT University, Melbourne VIC, Australia
,
James Harland
RMIT University, Melbourne VIC, Australia

Issue’s Table of Contents

Copyright © 2022 Owner/Author.

This work is licensed under a Creative Commons Attribution International 4.0 License.

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 14 February 2022

Published in INROADS Volume 13, Issue 1

Check for updates

Qualifiers

Research-article
Popular
Refereed

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

7
Total Citations
View Citations
1,380
Total Downloads

Downloads (Last 12 months)599
Downloads (Last 6 weeks)68

Reflects downloads up to 03 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

Zhou YMagana ALi TStone JYuen TShoop LRebelsky SPrather J(2025)Facilitating Student's Learning Transfer in a Database Programming ClassProceedings of the 56th ACM Technical Symposium on Computer Science Education V. 110.1145/3641554.3701828(1330-1336)Online publication date: 12-Feb-2025
https://dl.acm.org/doi/10.1145/3641554.3701828
Wang JChen STang ZLin PWang Y(2025)Enhancing SQL programming education: addressing cheating challenges in online judge systemsEducation and Information Technologies10.1007/s10639-024-13228-330:1(715-745)Online publication date: 1-Jan-2025
https://dl.acm.org/doi/10.1007/s10639-024-13228-3
Amiruddin MSamsudin ASuhandi ACostu B(2024)Bibliometric Investigation in Misconceptions and Conceptual Change Over Three Decades of Science EducationInternational Journal of Educational Methodology10.12973/ijem.10.3.367volume-10-2024:volume-10-issue-3-august-2024(367-385)Online publication date: 15-Aug-2024
https://doi.org/10.12973/ijem.10.3.367
Sibia NBernuy ATran EXu JWilliams JPetersen ALiut M(2024)Exploring Self-Explanations in a Flipped Database CourseProceedings of the 3rd International Workshop on Data Systems Education: Bridging education practice with education research10.1145/3663649.3664374(20-26)Online publication date: 9-Jun-2024
https://dl.acm.org/doi/10.1145/3663649.3664374
Wang JChen STang ZLin PWang Y(2024)False Positives and Deceptive Errors in SQL Assessment: A Large-Scale Analysis of Online Judge SystemsACM Transactions on Computing Education10.1145/365467724:3(1-23)Online publication date: 24-May-2024
https://dl.acm.org/doi/10.1145/3654677
Wu ZEricson B(2024)SQL Puzzles: Evaluating Micro Parsons Problems With Different Feedbacks as Practice for NovicesProceedings of the 2024 CHI Conference on Human Factors in Computing Systems10.1145/3613904.3641910(1-15)Online publication date: 11-May-2024
https://dl.acm.org/doi/10.1145/3613904.3641910
Imbulpitiya AWhalley JSenapathi M(2023)Reflections on Conducting Online Think-AloudsACM Inroads10.1145/359691714:2(26-34)Online publication date: 19-May-2023
https://dl.acm.org/doi/10.1145/3596917

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Digital Edition

View this article in digital edition.

Digital Edition

Magazine Site

View this article on the magazine site (external)

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Article

Figures

Tables

Media

View Issue’s Table of Contents