SQL education: A systematic map** study and future research agenda

T Taipalus, V Seppänen - ACM Transactions on Computing Education …, 2020‏ - dl.acm.org
Structured Query Language (SQL) skills are crucial in software engineering and computer
science. However, teaching SQL effectively requires both pedagogical skill and …

Increasing students' awareness of their behavior in online learning environments with visualizations and achievement badges

T Auvinen, L Hakulinen, L Malmi - IEEE Transactions on …, 2015‏ - ieeexplore.ieee.org
In online learning environments where automatic assessment is used, students often resort
to harmful study practices such as procrastination and trial-and-error. In this paper, we study …

Open social student modeling for personalized learning

P Brusilovsky, S Somyürek, J Guerra… - … on Emerging Topics …, 2015‏ - ieeexplore.ieee.org
Open student modeling (OSM) is an approach to technology-based learning, which makes
student models available to the learners for exploration. OSM is known for its ability to …

Errors and complications in SQL query formulation

T Taipalus, M Siponen, T Vartiainen - ACM Transactions on Computing …, 2018‏ - dl.acm.org
SQL is taught in almost all university level database courses, yet SQL has received relatively
little attention in educational research. In this study, we present a database management …

Review of Automated Assessment Tools for grading student SQL queries

S Nayak, R Agarwal, SK Khatri - 2022 International Conference …, 2022‏ - ieeexplore.ieee.org
The Structured Query Language (SQL) is the most widely used language for querying
relational databases and it is taught in all basic programming classes in higher education …

Students' syntactic mistakes in writing seven different types of SQL queries and its application to predicting students' success

A Ahadi, V Behbood, A Vihavainen, J Prior… - Proceedings of the 47th …, 2016‏ - dl.acm.org
The computing education community has studied extensively the errors of novice
programmers. In contrast, little attention has been given to student's mistake in writing SQL …

Advances in database systems education: Methods, tools, curricula, and way forward

M Ishaq, A Abid, MS Farooq, MF Manzoor… - Education and …, 2023‏ - Springer
Abstract Fundamentals of Database Systems is a core course in computing disciplines as
almost all small, medium, large, or enterprise systems essentially require data storage …

A quantitative study of the relative difficulty for novices of writing seven different types of SQL queries

A Ahadi, J Prior, V Behbood, R Lister - … of the 2015 ACM conference on …, 2015‏ - dl.acm.org
This paper presents a quantitative analysis of data collected by an online testing system for
SQL" select" queries. The data was collected from almost one thousand students, over eight …

Students' semantic mistakes in writing seven different types of SQL queries

A Ahadi, J Prior, V Behbood, R Lister - … of the 2016 ACM Conference on …, 2016‏ - dl.acm.org
Computer science researchers have studied extensively the mistakes of novice
programmers. In comparison, little attention has been given to studying the mistakes of …

Framework for SQL Error Message Design: A Data-Driven Approach

T Taipalus, H Grahn - ACM Transactions on Software Engineering and …, 2023‏ - dl.acm.org
Software developers use a significant amount of time reading and interpreting error
messages. However, error messages have often been based on either anecdotal evidence …