Open Access. Powered by Scholars. Published by Universities.®

Physical Sciences and Mathematics Commons

Open Access. Powered by Scholars. Published by Universities.®

Databases and Information Systems

Master's Theses

2019

Databases

Articles 1 - 1 of 1

Full-Text Articles in Physical Sciences and Mathematics

Data-Driven Database Education: A Quantitative Study Of Sql Learning In An Introductory Database Course, Andrew C. Von Dollen Jul 2019

Data-Driven Database Education: A Quantitative Study Of Sql Learning In An Introductory Database Course, Andrew C. Von Dollen

Master's Theses

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.