Data-Driven Database Education: A Quantitative Study of SQL Learning in an Introductory Database Course

<p>The Structured Query Language (SQL) is widely used and challenging to master. Within the context of lab exercises in an introductory database course, this thesis analyzes the student learning process and seeks to answer the question: ``Which SQL concepts, or concept combinations, trouble students the most?'' We provide comprehensive taxonomies of SQL concepts and errors, identify common areas of student misunderstanding, and investigate the student problem-solving process. We present an interactive web application used by students to complete SQL lab exercises. In addition, we analyze data collected by this application and we offer suggestions for improvement to database lab activities.</p>

Name thesis:degree_name

MS in Computer Science

Discipline thesis:degree_discipline

Computer Science

Year dc:date.available

2019

Author dc:creator

• Von Dollen, Andrew C

Contributors dc:contributor

• Alex Dekhtyar

• Databases
• Structured Query Language
• SQL
• Relational Model
• Databases and Information Systems

Identifier

10.15368/theses.2019.78

OAI identifier oai:identifier

oai:digitalcommons.calpoly.edu:theses-3495