A Quantitative Study of the Relative Difficulty for Novices of Writing Seven Different Types of SQL Queries

Publisher:
ACM
Publication Type:
Conference Proceeding
Citation:
Proceedings of the 2015 ACM Conference on Innovation and Technology in Computer Science Education, 2015, 1 pp. 201 - 206
Issue Date:
2015-07-15
Full metadata record
Files in This Item:
Filename Description Size
ThumbnailAhadi et al ITiCSE 2015 Corrected Version See Figures 3 and 5.pdf Published version526.49 kB
Adobe PDF
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: