Bridging the gap: Understanding SQL learning challenges through quantitative analyses and qualitative insights
Year: 2025
Type: dissertation
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 thinkaloud 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.needed it most, and your dedication to making sure I stayed focused and motivated made all the difference.Thank you for keeping me well-fed, making sure I got enough sleep, and dragging me to the gym to de-stress and keep fit.I am also deeply grateful for the opportunity to complete this Ph.D. program, which has been a tremendous learning experience.Beyond the academic aspects, it has also allowed me to explore new passions, such as latte art and sewing, enriching my personal growth in unexpected ways.
Author: Yang, Sophia S.
Institution: University of Illinois Urbana-Champaign
Language: English
Subfield: Computer Science Applications
Field: Computer Science
Domain: Physical Sciences
Keywords: SQL education, barriers to learning, pattern mining, Levenshtein distance, hierarchical clustering, sequence alignment, error feedback, AI-generated feedback, personalized feedback, study time, cooperative learning, flipped classroom, Parsons problems, curriculum development, database course
SDG: Quality education
Open Access status: green
OpenAlex ID: W7220826745
