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

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 …

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 …

The database and the database management system (DBMS) are two of the main
components of any information system. Structured Query Language (SQL) is the most …

Software developers use a significant amount of time reading and interpreting error
messages. However, error messages have often been based on either anecdotal evidence …

Computer science educators seek to understand the types of mistakes that students make
when learning a new (programming) language so that they can help students avoid those …

Querying a relational database is typically taught in practice by using an exercise database.
Such databases may be simple toy examples or elaborate and complex schemas that mimic …

Abstract In Structured Query Language (SQL) education, students often execute queries
against a simple exercise database. Recently, databases that are more realistic have been …