Set Comparison Queries in SQL

Dadashzadeh, Mohammad

doi:10.4018/9781878289889.ch013

Cited by 4 publications

(4 citation statements)

References 0 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…This last cause of misconceptions relates to the internal consistency of the SQL syntax. There is ongoing discussion on this topic, with several aspects of the SQL syntax being considered counter intuitive [10,16,26]. In contrast, Taipalus attributes many of the most common SQL formulation errors they found previously [34] to ignorance [31].…”

Section: Discussionmentioning

confidence: 99%

Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud Study

Miedema

Aivaloglou²,

Fletcher

2021

Proceedings of the 17th ACM Conference on International Computing Education Research

View full text Add to dashboard Cite

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 misconceptions held by novices which lead to these errors would help improve how we teach query languages to our students. In this paper we aim to identify the misconceptions that might be the causes of documented SQL errors that novices make. To this end, we conducted a qualitative think-aloud study to gather information on the thinking process of university students while solving query formulation problems. With the queries in hand, we analyzed the underlying causes for the errors made by our participants. In this paper we present the identified SQL misconceptions organized into four top-level categories: misconceptions based in previous course knowledge, generalization-based misconceptions, language-based misconceptions, and misconceptions due to an incomplete or incorrect mental model. A deep exploration of misconceptions can uncover gaps in instruction. By drawing attention to these, we aim to improve SQL education.

show abstract

Section: Discussionmentioning

confidence: 99%

Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud Study

Miedema

Aivaloglou²,

Fletcher

2021

Proceedings of the 17th ACM Conference on International Computing Education Research

View full text Add to dashboard Cite

show abstract

Section: Other Observationsmentioning

confidence: 99%

Identifying SQL misconceptions of novices

2022

View full text Add to dashboard Cite

H ave you ever struggled with writing a SQL query to retrieve data? Students certainly do. In this paper we set out to investigate why this is the case. The first step to making less mistakes, is to find the underlying reasons why these mistakes are made. Through a think-aloud study with 21 students we identified various SQL errors; and from these deduced 14 SQL misconceptions.The four reasons we found for mistakes are: interference of previous course knowledge, generalizing answers to questions where they do not fit, differences in language usage between SQL and natural language, and incomplete or incorrect mental models. Publish Your WorkOpen Access With ACM! ACM o ers a variety of Open Access publishing options to ensure that your work is disseminated to the widest possible readership of computer scientists around the world.

show abstract

“…The study was published in the summer 2002 issue in JISE. Dadashzadeh [40] authored a study expanding and generalizing similar approach to other set comparison queries. This study shows relational division similarly to Matos and Grasser, and was published in the winter 2003 issue in JISE.…”

Section: Building Upon Existing Body Of Knowledgementioning

confidence: 99%

SQL Education

Taipalus

Seppänen

2020

ACM Trans. Comput. Educ.

View full text Add to dashboard Cite

Structured Query Language (SQL) skills are crucial in software engineering and computer science. However, teaching SQL effectively requires both pedagogical skill and considerable knowledge of the language. Educators and scholars have proposed numerous considerations for the betterment of SQL education, yet these considerations may be too numerous and scattered among different fora for educators to find and internalize, as no systematic mappings or literature reviews regarding SQL education have been conducted. The two main goals of this mapping study are to provide an overview of educational SQL research topics, research types and publication fora, and to collect and propagate SQL teaching practices for educators to utilize. Additionally, we present a short future research agenda based on insights from the mapping process. We conducted a systematic mapping study complemented by snowballing techniques to identify applicable primary studies. We classified the primary studies according to research type, and utilized directed content analysis to classify the primary studies by their topic. Out of our selected 89 primary studies, we identified six recurring topics: (i) student errors in query formulation; (ii) characteristics and presentation of the exercise database; (iii) specific and (iv) non-specific teaching approach suggestions; (v) patterns and visualization; and (vi) easing teacher workload. We list 66 teaching approaches the primary studies argued for (and in some cases against). For researchers, we provide a systematic map of educational SQL research, and future research agenda. For educators, we present an aggregated body of knowledge on teaching practices in SQL education over a time frame of 30 years. In conclusion, we suggest that replication studies, studies on advanced SQL concepts, and studies on aspects other than data retrieval are needed to further educational SQL research.

show abstract

Set Comparison Queries in SQL

Cited by 4 publications

References 0 publications

Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud Study

Identifying SQL Misconceptions of Novices: Findings from a Think-Aloud Study

Identifying SQL misconceptions of novices

SQL Education

Contact Info

Product

Resources

About