Bridging the gap: Understanding SQL learning challenges through quantitative analyses and qualitative insights

Yang, Sophia S.

Permalink

https://hdl.handle.net/2142/129367 Copy

Description

Title

Bridging the gap: Understanding SQL learning challenges through quantitative analyses and qualitative insights

Author(s)

Yang, Sophia S.

Issue Date

2025-02-07

Director of Research (if dissertation) or Advisor (if thesis)

• Alawini, Abdussalam
• Herman, Geoffrey L.

Doctoral Committee Chair(s)

Alawini, Abdussalam

Committee Member(s)

• Zilles, Craig
• Zhai, Chengxiang
• Davidson, Susan B.

Department of Study

Siebel School Comp & Data Sci

Discipline

Computer Science

Degree Granting Institution

University of Illinois Urbana-Champaign

Degree Name

Ph.D.

Degree Level

Dissertation

Keyword(s)

• SQL
• Structured Query Language
• database
• education
• computing education
• pattern mining
• sequence alignment
• quantitative
• qualitative

Abstract

As the demand for SQL experts continues to rise, teaching SQL effectively has become increasingly important. Previous studies on SQL education have identified learning challenges, analyzed student errors, and developed learning tools. Building on this foundation, my research provided additional directions to enhance educators’ understanding of SQL learning challenges and explored tools to teach more effectively. Leveraging large-scale data collected from a public institution’s database course, I conducted a series of quantitative studies with students’ data. I developed use cases for pattern-mining techniques to track students’ submission attempts for their SQL assignments. With advanced pattern-mining techniques, such as Levenshtein Edit Distance, hierarchical clustering, and sequence alignment, I examined and captured students’ problem-solving behaviors under various conditions. Furthermore, previous studies on general education suggested several factors that can affect students’ learning ability, including study time, course modality, collaborative environments, etc. Thus, I conducted several studies to explore factors influencing students’ ability to learn SQL, including the sequence in which query languages are introduced, study time, assignment types, error feedback, and collaborative environments. Lastly, since students often struggle to solve SQL problems due to a lack of error feedback, I also investigated the use of generative AI tools to provide more effective and personalized feedback. To complement these quantitative findings, I designed and conducted a qualitative think-aloud study to gain deeper insights into students’ SQL challenges. Based on the combined findings, I provided actionable recommendations to improve teaching strategies and curriculum design. Instructors should adopt pattern mining tools to identify students needing extra support, emphasize non-timed SQL problems, provide syntax drills, integrate generative AI for error feedback, and explore an online flipped-classroom model with in-person office hours. Additionally, studying the inclusion of Parsons problems could further scaffold student learning in SQL.

Graduation Semester

2025-05

Type of Resource

Thesis

Handle URL

https://hdl.handle.net/2142/129367

Copyright and License Information

Copyright 2025 Sophia S. Yang

Owning Collections