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 proceedingConference proceeding contributionpeer-review

24 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 languageEnglish
Title of host publicationITiCSE 2015
Subtitle of host publicationProceedings of the 2015 ACM Conference on Innovation and Technology in Computer Science Education
Place of PublicationNew York, NY
PublisherAssociation for Computing Machinery
Pages201-206
Number of pages6
ISBN (Electronic)9781450334402
DOIs
Publication statusPublished - 2015
Externally publishedYes
EventACM Conference on Innovation and Technology in Computer Science Education (20th : 2015) - Vilnius, Lithuania
Duration: 4 Jul 20158 Jul 2015

Conference

ConferenceACM Conference on Innovation and Technology in Computer Science Education (20th : 2015)
Abbreviated titleITiCSE 2015
CountryLithuania
CityVilnius
Period4/07/158/07/15

Keywords

  • online assessment
  • databases
  • SQL queries

Fingerprint

Dive into the research topics of 'A quantitative study of the relative difficulty for novices of writing seven different types of SQL queries'. Together they form a unique fingerprint.

Cite this