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

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

Ahadi, A

Prior, J

Behbood, V Lister, R

Permalink

Publication Type:: Conference Proceeding
Citation:: Annual Conference on Innovation and Technology in Computer Science Education, ITiCSE, 2015, 2015-June pp. 201 - 206
Issue Date:: 2015-06-22

Closed Access

	Filename	Description	Size
	Ahadi et al ITiCSE 2015 Corrected Version See Figures 3 and 5.pdf	Published version	526.49 kB	Adobe PDF	View/Open

Copyright Clearance Process

Recently Added
In Progress
Closed Access

This item is closed access and not available.

Full metadata record

Field	Value	Language
dc.contributor.author	Ahadi, A https://orcid.org/0000-0002-2018-3065	en_US
dc.contributor.author	Prior, J https://orcid.org/0000-0002-7182-0984	en_US
dc.contributor.author	Behbood, V	en_US
dc.contributor.author	Lister, R https://orcid.org/0000-0001-5780-0445	en_US
dc.date.issued	2015-06-22	en_US
dc.identifier.citation	Annual Conference on Innovation and Technology in Computer Science Education, ITiCSE, 2015, 2015-June pp. 201 - 206	en_US
dc.identifier.isbn	9781450334402	en_US
dc.identifier.issn	1942-647X	en_US
dc.identifier.uri	http://hdl.handle.net/10453/37481
dc.description.abstract	Copyright © 2015 ACM. 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.	en_US
dc.relation.ispartof	Annual Conference on Innovation and Technology in Computer Science Education, ITiCSE	en_US
dc.relation.isbasedon	10.1145/2729094.2742620	en_US
dc.title	A quantitative study of the relative difficulty for novices of writing seven different types of SQL queries	en_US
dc.type	Conference Proceeding
utslib.citation.volume	2015-June	en_US
utslib.for	130212 Science, Technology and Engineering Curriculum and Pedagogy	en_US
dc.location.activity	Lithuania
pubs.embargo.period	Not known	en_US
pubs.organisational-group	/University of Technology Sydney
pubs.organisational-group	/University of Technology Sydney/Faculty of Engineering and Information Technology
pubs.organisational-group	/University of Technology Sydney/Faculty of Engineering and Information Technology/School of Computer Science
pubs.organisational-group	/University of Technology Sydney/Strength - CAI - Centre for Artificial Intelligence
pubs.organisational-group	/University of Technology Sydney/Strength - HCTD - Human Centred Technology Design
utslib.copyright.status	closed_access
pubs.publication-status	Published	en_US
pubs.volume	2015-June	en_US

Abstract:

Copyright © 2015 ACM. 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.

Please use this identifier to cite or link to this item:

http://hdl.handle.net/10453/37481