Computer assisted assessment of SQL query skills

Authors:
Stijn Dekeyser;Michael de Raadt;Tien Yu Lee
Affiliations:
University of Southern Queensland, Queensland, Australia;University of Southern Queensland, Queensland, Australia;University of Southern Queensland, Queensland, Australia
Venue:
ADC '07 Proceedings of the eighteenth conference on Australasian database - Volume 63
Year:
2007

Citing 12
Cited 4

Database systems: a practical approach to design, implementation and management

Database systems: a practical approach to design, implementation and management
WinRDBI: a Windows-based relational database educational tool

SIGCSE '97 Proceedings of the twenty-eighth SIGCSE technical symposium on Computer science education
Learning SQL with a computerized tutor

SIGCSE '98 Proceedings of the twenty-ninth SIGCSE technical symposium on Computer science education
A teaching system for SQL

Proceedings of the 2nd Australasian conference on Computer science education
Improving the human factors aspect of database interactions

ACM Transactions on Database Systems (TODS)
Database System Concepts

Database System Concepts
Optimal implementation of conjunctive queries in relational data bases

STOC '77 Proceedings of the ninth annual ACM symposium on Theory of computing
Peer-to-peer learning with open-ended writable Web

Proceedings of the 8th annual conference on Innovation and technology in computer science education
The backwash effect on SQL skills grading

Proceedings of the 9th annual SIGCSE conference on Innovation and technology in computer science education
SQLator: an online SQL learning workbench

Proceedings of the 9th annual SIGCSE conference on Innovation and technology in computer science education
Automated tutoring for a database skills training environment

Proceedings of the 36th SIGCSE technical symposium on Computer science education
Database Systems: An Application Oriented Approach, Complete Version (2nd Edition)

Database Systems: An Application Oriented Approach, Complete Version (2nd Edition)

Ideas in Teaching, Learning and Assessment of Databases: A Communication of the 7thInternational Workshop on Teaching, Learning and Assessment of Databases (TLAD 2009)

BNCOD 26 Proceedings of the 26th British National Conference on Databases: Dataspace: The Final Frontier
Empirical evidence for the usefulness of Armstrong relations in the acquisition of meaningful functional dependencies

Information Systems
An evaluation of electronic individual peer assessment in an introductory programming course

Koli Calling '07 Proceedings of the Seventh Baltic Sea Conference on Computing Education Research - Volume 88
Automated grading and tutoring of SQL statements to improve student learning

Proceedings of the 13th Koli Calling International Conference on Computing Education Research

Quantified Score

Hi-index	0.00

Visualization

Abstract

Structured Query Language (SQL) is the dominant language for querying relational databases today, and is an essential topic in introductory database courses in higher education. Even though the language is syntactically simple, relatively concise, and highly structured, students experience many difficulties while learning to express queries in SQL. In recent years a small number of software tools have been proposed to help students learn to write query statements and to assess their querying skills. In this paper we compare and evaluate existing tools mainly from the perspective of database theory and practice, but also from a pedagogical perspective. Addressing the deficiencies and opportunities uncovered by the evaluation, we then introduce SQLify, a new tool that extends the current state of the art by incorporating semantic feedback, enhanced automatic assessment based on database theory, and peer review to arrive at a richer learning experience for students, as well as consistent assessment results and reduced marking for instructors.