Home > Research > Publications & Outputs > Learning SQL in steps

Research

Associated organisational units

Keywords

View graph of relations

Learning SQL in steps

Research output: Contribution to Journal/Magazine › Journal article › peer-review

Published

Standard

Learning SQL in steps. / Garner, Philip; Mariani, John Amedeo.
In: Journal on Systemics, Cybernetics and Informatics, Vol. 13, No. 4, 2015, p. 19-24.

Research output: Contribution to Journal/Magazine › Journal article › peer-review

Harvard

Garner, P & Mariani, JA 2015, 'Learning SQL in steps', Journal on Systemics, Cybernetics and Informatics, vol. 13, no. 4, pp. 19-24.

APA

Garner, P., & Mariani, J. A. (2015). Learning SQL in steps. Journal on Systemics, Cybernetics and Informatics, 13(4), 19-24.

Vancouver

Garner P, Mariani JA. Learning SQL in steps. Journal on Systemics, Cybernetics and Informatics. 2015;13(4):19-24.

Author

Garner, Philip ; Mariani, John Amedeo. / Learning SQL in steps. In: Journal on Systemics, Cybernetics and Informatics. 2015 ; Vol. 13, No. 4. pp. 19-24.

Bibtex

@article{24d534be82204be0b79817d9c46d9768,
title = "Learning SQL in steps",
abstract = "Learning SQL is a common problem for many Computer Science (CS) students, the steps involved are quite different to those mastered when learning procedural or object-oriented programming languages. The introduction of commercial products that include shortcuts into the learning environment can initially appear to benefit the student, however, transferring these skills to a textual environment can be difficult for many students. Computer Science students are required to build textual SQL queries because the demands of complex queries can quickly out grow the capabilities of graphical query builders available in many software packages. SQL in Steps (SiS) is a graphical user interface centred around the textual translation of a query; this combination of a GUI and a clear representation of its textual meaning has the potential to improve the way in which users gain an understanding of SQL. SiS allows for an incremental and evolutionary development of queries by enabling students to build queries step by step until their goal is reached. A planned evaluation of SiS hopes to quantify the extent to which the introduction of such a user interface into the learning environment can improve the students{\textquoteright} understanding of the language.",
keywords = "learning SQL, education, learning environments, graphical queries, relational databases",
author = "Philip Garner and Mariani, {John Amedeo}",
year = "2015",
language = "English",
volume = "13",
pages = "19--24",
journal = "Journal on Systemics, Cybernetics and Informatics",
issn = "1690-4524",
number = "4",

}

RIS

TY - JOUR

T1 - Learning SQL in steps

AU - Garner, Philip

AU - Mariani, John Amedeo

PY - 2015

Y1 - 2015

N2 - Learning SQL is a common problem for many Computer Science (CS) students, the steps involved are quite different to those mastered when learning procedural or object-oriented programming languages. The introduction of commercial products that include shortcuts into the learning environment can initially appear to benefit the student, however, transferring these skills to a textual environment can be difficult for many students. Computer Science students are required to build textual SQL queries because the demands of complex queries can quickly out grow the capabilities of graphical query builders available in many software packages. SQL in Steps (SiS) is a graphical user interface centred around the textual translation of a query; this combination of a GUI and a clear representation of its textual meaning has the potential to improve the way in which users gain an understanding of SQL. SiS allows for an incremental and evolutionary development of queries by enabling students to build queries step by step until their goal is reached. A planned evaluation of SiS hopes to quantify the extent to which the introduction of such a user interface into the learning environment can improve the students’ understanding of the language.

AB - Learning SQL is a common problem for many Computer Science (CS) students, the steps involved are quite different to those mastered when learning procedural or object-oriented programming languages. The introduction of commercial products that include shortcuts into the learning environment can initially appear to benefit the student, however, transferring these skills to a textual environment can be difficult for many students. Computer Science students are required to build textual SQL queries because the demands of complex queries can quickly out grow the capabilities of graphical query builders available in many software packages. SQL in Steps (SiS) is a graphical user interface centred around the textual translation of a query; this combination of a GUI and a clear representation of its textual meaning has the potential to improve the way in which users gain an understanding of SQL. SiS allows for an incremental and evolutionary development of queries by enabling students to build queries step by step until their goal is reached. A planned evaluation of SiS hopes to quantify the extent to which the introduction of such a user interface into the learning environment can improve the students’ understanding of the language.

KW - learning SQL

KW - education

KW - learning environments

KW - graphical queries

KW - relational databases

M3 - Journal article

VL - 13

SP - 19

EP - 24

JO - Journal on Systemics, Cybernetics and Informatics

JF - Journal on Systemics, Cybernetics and Informatics

SN - 1690-4524

IS - 4

ER -