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

Alireza Ahadi; Julia Prior; Vahid Behbood; Raymond Lister

doi:10.1145/2729094.2742620

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

Alireza Ahadi, Julia Prior, Vahid Behbood, Raymond Lister

Research output: Chapter in Book/Report/Conference proceeding › Conference proceeding contribution › peer-review

37 Citations (Scopus)

Abstract

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 years. We examine which types of queries our students found harder to write. The seven types of SQL queries studied are: simple queries on one table; grouping, both with and without "having"; natural joins; simple and correlated sub-queries; and self-joins. The order of queries in the preceding sentence reflects the order of student difficulty we see in our data.

Original language	English
Title of host publication	ITiCSE 2015
Subtitle of host publication	Proceedings of the 2015 ACM Conference on Innovation and Technology in Computer Science Education
Place of Publication	New York, NY
Publisher	Association for Computing Machinery
Pages	201-206
Number of pages	6
ISBN (Electronic)	9781450334402
DOIs	https://doi.org/10.1145/2729094.2742620
Publication status	Published - 2015
Externally published	Yes
Event	ACM Conference on Innovation and Technology in Computer Science Education (20th : 2015) - Vilnius, Lithuania Duration: 4 Jul 2015 → 8 Jul 2015

Conference

Conference	ACM Conference on Innovation and Technology in Computer Science Education (20th : 2015)
Abbreviated title	ITiCSE 2015
Country/Territory	Lithuania
City	Vilnius
Period	4/07/15 → 8/07/15

Keywords

online assessment
databases
SQL queries

Access to Document

10.1145/2729094.2742620

Cite this

Ahadi, A., Prior, J., Behbood, V., & Lister, R. (2015). A quantitative study of the relative difficulty for novices of writing seven different types of SQL queries. In ITiCSE 2015: Proceedings of the 2015 ACM Conference on Innovation and Technology in Computer Science Education (pp. 201-206). Association for Computing Machinery. https://doi.org/10.1145/2729094.2742620

@inproceedings{a3ee5d6388394f13977bf463ee80f2d5,

title = "A quantitative study of the relative difficulty for novices of writing seven different types of SQL queries",

abstract = "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 years. We examine which types of queries our students found harder to write. The seven types of SQL queries studied are: simple queries on one table; grouping, both with and without {"}having{"}; natural joins; simple and correlated sub-queries; and self-joins. The order of queries in the preceding sentence reflects the order of student difficulty we see in our data.",

keywords = "online assessment, databases, SQL queries",

author = "Alireza Ahadi and Julia Prior and Vahid Behbood and Raymond Lister",

year = "2015",

doi = "10.1145/2729094.2742620",

language = "English",

pages = "201--206",

booktitle = "ITiCSE 2015",

publisher = "Association for Computing Machinery",

note = "ACM Conference on Innovation and Technology in Computer Science Education (20th : 2015), ITiCSE 2015 ; Conference date: 04-07-2015 Through 08-07-2015",

}

Ahadi, A, Prior, J, Behbood, V & Lister, R 2015, A quantitative study of the relative difficulty for novices of writing seven different types of SQL queries. in ITiCSE 2015: Proceedings of the 2015 ACM Conference on Innovation and Technology in Computer Science Education. Association for Computing Machinery, New York, NY, pp. 201-206, ACM Conference on Innovation and Technology in Computer Science Education (20th : 2015), Vilnius, Lithuania, 4/07/15. https://doi.org/10.1145/2729094.2742620

A quantitative study of the relative difficulty for novices of writing seven different types of SQL queries. / Ahadi, Alireza; Prior, Julia; Behbood, Vahid; Lister, Raymond.

ITiCSE 2015: Proceedings of the 2015 ACM Conference on Innovation and Technology in Computer Science Education. New York, NY : Association for Computing Machinery, 2015. p. 201-206.

Research output: Chapter in Book/Report/Conference proceeding › Conference proceeding contribution › peer-review

TY - GEN

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

AU - Ahadi, Alireza

AU - Prior, Julia

AU - Behbood, Vahid

AU - Lister, Raymond

PY - 2015

Y1 - 2015

N2 - 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 years. We examine which types of queries our students found harder to write. The seven types of SQL queries studied are: simple queries on one table; grouping, both with and without "having"; natural joins; simple and correlated sub-queries; and self-joins. The order of queries in the preceding sentence reflects the order of student difficulty we see in our data.

AB - 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 years. We examine which types of queries our students found harder to write. The seven types of SQL queries studied are: simple queries on one table; grouping, both with and without "having"; natural joins; simple and correlated sub-queries; and self-joins. The order of queries in the preceding sentence reflects the order of student difficulty we see in our data.

KW - online assessment

KW - databases

KW - SQL queries

UR - http://www.scopus.com/inward/record.url?scp=84951966686&partnerID=8YFLogxK

U2 - 10.1145/2729094.2742620

DO - 10.1145/2729094.2742620

M3 - Conference proceeding contribution

AN - SCOPUS:84951966686

SP - 201

EP - 206

BT - ITiCSE 2015

PB - Association for Computing Machinery

CY - New York, NY

T2 - ACM Conference on Innovation and Technology in Computer Science Education (20th : 2015)

Y2 - 4 July 2015 through 8 July 2015

ER -

Ahadi A, Prior J, Behbood V, Lister R. A quantitative study of the relative difficulty for novices of writing seven different types of SQL queries. In ITiCSE 2015: Proceedings of the 2015 ACM Conference on Innovation and Technology in Computer Science Education. New York, NY: Association for Computing Machinery. 2015. p. 201-206 https://doi.org/10.1145/2729094.2742620

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

Abstract

Conference

Keywords

Access to Document

Other files and links

Fingerprint

Cite this