Efficiency has been a pivotal aspect of the software industry since its inception, as a system
that serves the end-user fast, and the service provider cost-efficiently benefits all parties. A …

Structured Query Language (SQL) skills are crucial in software engineering and computer
science. However, teaching SQL effectively requires both pedagogical skill and …

Have 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 …

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 …

SQL is a typical query language for performing data analytics. Although its usage is
ubiquitous, learners experience that query formulation in SQL is error-prone and time …

A set of mutation operators for SQL queries that retrieve information from a database is
developed and tested against a set of queries drawn from the NIST SQL Conformance Test …

Understanding the meaning of existing SQL queries is critical for code maintenance and
reuse. Yet SQL can be hard to read, even for expert users or the original creator of a query …

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 …

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 …

Computer science researchers have studied extensively the mistakes of novice
programmers. In comparison, little attention has been given to studying the mistakes of …