So many brackets!
Daphne Miedema, George Fletcher, Efthimia Aivaloglou
Abstract
The Structured Query Language (SQL) is a widely taught database query language in computer science, data science, and software engineering programs. While highly expressive, SQL is challenging to learn for novices. Various research has explored the errors and mistakes that SQL users make. Specific attributes of SQL code, such as the number of tables and the degree of nesting, have been found to impact its understandability and maintainability. Furthermore, prior studies have shown that novices have significant issues using SQL correctly, due to factors such as expressive ease, existing knowledge and misconceptions, and the impact of cognitive load.
Topics & Concepts
Computer scienceSQLSQL/PSMQuery by ExampleNesting (process)Programming languageMaintainabilityIn-Memory ProcessingSoftware engineeringInformation retrievalWeb search querySearch engineMetallurgyMaterials scienceTeaching and Learning ProgrammingSpreadsheets and End-User ComputingScientific Computing and Data Management