A1 Alkuperäisartikkeli tieteellisessä aikakauslehdessä
SQL education : a systematic mapping study and future research agenda (2020)

Taipalus, Toni; Seppänen, Ville (2020). SQL education : a systematic mapping study and future research agenda. ACM Transactions on Computing Education, 20 (3), 20. DOI: 10.1145/3398377

JYU-tekijät tai -toimittajat

Julkaisun tiedot

Julkaisun kaikki tekijät tai toimittajat: Taipalus, Toni; Seppänen, Ville

Lehti tai sarja: ACM Transactions on Computing Education

eISSN: 1946-6226

Julkaisuvuosi: 2020

Volyymi: 20

Lehden numero: 3

Artikkelinumero: 20

Kustantaja: Association for Computing Machinery (ACM)

Julkaisumaa: Yhdysvallat (USA)

Julkaisun kieli: englanti

DOI: https://doi.org/10.1145/3398377

Avoin saatavuus: Julkaisukanava ei ole avoin

Julkaisu on rinnakkaistallennettu (JYX): https://jyx.jyu.fi/handle/123456789/71405


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.

YSO-asiasanat: tietojenkäsittelytieteet; korkeakouluopetus; kyselykielet; SQL

Vapaat asiasanat: SQL education; systematic mapping study; future research agenda

Liittyvät organisaatiot

OKM-raportointi: Kyllä

Alustava JUFO-taso: 2

Viimeisin päivitys 2021-02-02 klo 09:51