{"id":"https://openalex.org/W7220826745","doi":null,"title":"Bridging the gap: Understanding SQL learning challenges through quantitative analyses and qualitative insights","display_name":"Bridging the gap: Understanding SQL learning challenges through quantitative analyses and qualitative insights","alternate_titles":[],"publication_year":2025,"publication_date":"2025-02-07","ids":{"openalex":"https://openalex.org/W7220826745"},"language":"en","primary_location":{"id":"pmh:oai:www.ideals.illinois.edu:2142/129367","doi":null,"is_oa":true,"landing_page_url":"https://hdl.handle.net/2142/129367","pdf_url":"https://www.ideals.illinois.edu/items/136408/bitstreams/445738/data.pdf","source":{"id":"https://openalex.org/S4306401358","display_name":"Illinois Digital Environment for Access to Learning and Scholarship (University of Illinois at Urbana-Champaign)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I2801919071","host_organization_name":"University of Illinois System","host_organization_lineage":["https://openalex.org/I2801919071"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Thesis"},"parent_works":[],"lineage":["https://openalex.org/W7220826745"],"child_works_count":0,"type":"dissertation","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://www.ideals.illinois.edu/items/136408/bitstreams/445738/data.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5157765341","display_name":"Sophia S. Yang","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Yang, Sophia S.","raw_affiliation_strings":["Graduate College, University of Illinois Urbana-Champaign"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Graduate College, University of Illinois Urbana-Champaign","institution_ids":["https://openalex.org/I157725225"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5157765341"],"corresponding_institution_ids":["https://openalex.org/I157725225"],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":2,"reviewed_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.9961000084877014,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10533","display_name":"Teaching and Learning Programming","score":0.9961000084877014,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11122","display_name":"Online Learning and Analytics","score":0.002300000051036477,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11875","display_name":"Statistics Education and Methodologies","score":0.000699999975040555,"subfield":{"id":"https://openalex.org/subfields/2613","display_name":"Statistics and Probability"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql-education","display_name":"SQL education","score":0.8029999732971191},{"id":"https://openalex.org/keywords/barriers-to-learning","display_name":"barriers to learning","score":0.7910000085830688},{"id":"https://openalex.org/keywords/pattern-mining","display_name":"pattern mining","score":0.8270000219345093},{"id":"https://openalex.org/keywords/levenshtein-distance","display_name":"Levenshtein distance","score":0.9139999747276306},{"id":"https://openalex.org/keywords/hierarchical-clustering","display_name":"hierarchical clustering","score":0.871999979019165},{"id":"https://openalex.org/keywords/sequence-alignment","display_name":"sequence alignment","score":0.9829999804496765},{"id":"https://openalex.org/keywords/error-feedback","display_name":"error feedback","score":0.7310000061988831},{"id":"https://openalex.org/keywords/ai-feedback","display_name":"AI-generated feedback","score":0.8700000047683716},{"id":"https://openalex.org/keywords/personalized-feedback","display_name":"personalized feedback","score":0.6600000262260437},{"id":"https://openalex.org/keywords/study-time","display_name":"study time","score":0.6050000190734863},{"id":"https://openalex.org/keywords/collaborative-learning","display_name":"cooperative learning","score":0.7540000081062317},{"id":"https://openalex.org/keywords/flipped-classroom","display_name":"flipped classroom","score":0.9049999713897705},{"id":"https://openalex.org/keywords/parsons-problems","display_name":"Parsons problems","score":0.7720000147819519},{"id":"https://openalex.org/keywords/curriculum-development","display_name":"curriculum development","score":0.6309999823570251},{"id":"https://openalex.org/keywords/database-course","display_name":"database course","score":0.3959999978542328}],"concepts":[{"id":"https://openalex.org/C174348530","wikidata":"https://www.wikidata.org/wiki/Q188635","display_name":"Bridging (networking)","level":2,"score":0.7628999948501587},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6823999881744385},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.3564999997615814},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.34709998965263367},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.3181000053882599},{"id":"https://openalex.org/C190248442","wikidata":"https://www.wikidata.org/wiki/Q839486","display_name":"Qualitative research","level":2,"score":0.2987000048160553},{"id":"https://openalex.org/C3018587665","wikidata":"https://www.wikidata.org/wiki/Q7268696","display_name":"Qualitative analysis","level":3,"score":0.2856999933719635},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.27869999408721924},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.26330000162124634},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.26249998807907104}],"mesh":[],"locations_count":1,"locations":[{"id":"pmh:oai:www.ideals.illinois.edu:2142/129367","doi":null,"is_oa":true,"landing_page_url":"https://hdl.handle.net/2142/129367","pdf_url":"https://www.ideals.illinois.edu/items/136408/bitstreams/445738/data.pdf","source":{"id":"https://openalex.org/S4306401358","display_name":"Illinois Digital Environment for Access to Learning and Scholarship (University of Illinois at Urbana-Champaign)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I2801919071","host_organization_name":"University of Illinois System","host_organization_lineage":["https://openalex.org/I2801919071"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Thesis"}],"best_oa_location":{"id":"pmh:oai:www.ideals.illinois.edu:2142/129367","doi":null,"is_oa":true,"landing_page_url":"https://hdl.handle.net/2142/129367","pdf_url":"https://www.ideals.illinois.edu/items/136408/bitstreams/445738/data.pdf","source":{"id":"https://openalex.org/S4306401358","display_name":"Illinois Digital Environment for Access to Learning and Scholarship (University of Illinois at Urbana-Champaign)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I2801919071","host_organization_name":"University of Illinois System","host_organization_lineage":["https://openalex.org/I2801919071"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Thesis"},"sustainable_development_goals":[{"display_name":"Quality education","score":0.9901999831199646,"id":"https://metadata.un.org/sdg/4"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W7220826745.pdf","grobid_xml":"https://content.openalex.org/works/W7220826745.grobid-xml"},"referenced_works_count":134,"referenced_works":["https://openalex.org/W43076228","https://openalex.org/W139906731","https://openalex.org/W151059316","https://openalex.org/W941815880","https://openalex.org/W1515587369","https://openalex.org/W1566718566","https://openalex.org/W1580195166","https://openalex.org/W1952441874","https://openalex.org/W1959608418","https://openalex.org/W1964523235","https://openalex.org/W1965437408","https://openalex.org/W1971796909","https://openalex.org/W1972000103","https://openalex.org/W1989370231","https://openalex.org/W1992658570","https://openalex.org/W1995969371","https://openalex.org/W2011301426","https://openalex.org/W2014510839","https://openalex.org/W2024092127","https://openalex.org/W2042129257","https://openalex.org/W2044009024","https://openalex.org/W2052127297","https://openalex.org/W2052569240","https://openalex.org/W2059729828","https://openalex.org/W2067438752","https://openalex.org/W2071100465","https://openalex.org/W2072607050","https://openalex.org/W2073364004","https://openalex.org/W2074231493","https://openalex.org/W2082186327","https://openalex.org/W2089135307","https://openalex.org/W2089624191","https://openalex.org/W2094192576","https://openalex.org/W2095026299","https://openalex.org/W2096431252","https://openalex.org/W2098307754","https://openalex.org/W2111643688","https://openalex.org/W2112865564","https://openalex.org/W2120913149","https://openalex.org/W2130719656","https://openalex.org/W2132032354","https://openalex.org/W2132516581","https://openalex.org/W2158703410","https://openalex.org/W2159000095","https://openalex.org/W2168809016","https://openalex.org/W2231485967","https://openalex.org/W2286501037","https://openalex.org/W2292552191","https://openalex.org/W2294396910","https://openalex.org/W2318830132","https://openalex.org/W2338073987","https://openalex.org/W2347061999","https://openalex.org/W2460699391","https://openalex.org/W2473995384","https://openalex.org/W2478064165","https://openalex.org/W2510119520","https://openalex.org/W2514180210","https://openalex.org/W2528541263","https://openalex.org/W2595180720","https://openalex.org/W2606099389","https://openalex.org/W2745060418","https://openalex.org/W2748424627","https://openalex.org/W2759596001","https://openalex.org/W2766230222","https://openalex.org/W2788882425","https://openalex.org/W2793593730","https://openalex.org/W2800867697","https://openalex.org/W2809686080","https://openalex.org/W2885090162","https://openalex.org/W2898117192","https://openalex.org/W2898830973","https://openalex.org/W2901126507","https://openalex.org/W2916040897","https://openalex.org/W2944439732","https://openalex.org/W2950300510","https://openalex.org/W2964982419","https://openalex.org/W2965576334","https://openalex.org/W2977675766","https://openalex.org/W2995774055","https://openalex.org/W2998738573","https://openalex.org/W3003257820","https://openalex.org/W3009770877","https://openalex.org/W3010338652","https://openalex.org/W3010914864","https://openalex.org/W3031205039","https://openalex.org/W3033081529","https://openalex.org/W3033482208","https://openalex.org/W3034630906","https://openalex.org/W3035965352","https://openalex.org/W3037102267","https://openalex.org/W3041823931","https://openalex.org/W3045552507","https://openalex.org/W3047886169","https://openalex.org/W3112836607","https://openalex.org/W3133595252","https://openalex.org/W3168139378","https://openalex.org/W3172255581","https://openalex.org/W3175146411","https://openalex.org/W3176219159","https://openalex.org/W3176253106","https://openalex.org/W3177923307","https://openalex.org/W3183901340","https://openalex.org/W3193751197","https://openalex.org/W3200413283","https://openalex.org/W3209496184","https://openalex.org/W4231410305","https://openalex.org/W4231513437","https://openalex.org/W4232518934","https://openalex.org/W4243095575","https://openalex.org/W4244054901","https://openalex.org/W4281764247","https://openalex.org/W4284889749","https://openalex.org/W4289731365","https://openalex.org/W4291475983","https://openalex.org/W4310354026","https://openalex.org/W4312913262","https://openalex.org/W4323037487","https://openalex.org/W4323655724","https://openalex.org/W4381546096","https://openalex.org/W4381550569","https://openalex.org/W4381660888","https://openalex.org/W4385379547","https://openalex.org/W4385473732","https://openalex.org/W4385574376","https://openalex.org/W4386574312","https://openalex.org/W4386728881","https://openalex.org/W4389260745","https://openalex.org/W4389520443","https://openalex.org/W4390606851","https://openalex.org/W4390606890","https://openalex.org/W4390606960","https://openalex.org/W4391599075","https://openalex.org/W4401313459","https://openalex.org/W4406688098"],"related_works":["https://openalex.org/W3093740538","https://openalex.org/W2517400928","https://openalex.org/W2481806910","https://openalex.org/W2117817374","https://openalex.org/W2514647172","https://openalex.org/W7162041041","https://openalex.org/W1606424393","https://openalex.org/W3172255581","https://openalex.org/W7203822847"],"abstract_inverted_index":{"As":[0],"the":[1,147,182,216,265,292,309,321,335],"demand":[2],"for":[3,76,84,251,295,320],"SQL":[4,10,18,44,86,170,213,243],"experts":[5],"continues":[6],"to":[7,39,50,79,137,143,168,173,188,207,223,235,282,308,311,323,343],"rise,":[8],"teaching":[9,225],"effectively":[11],"has":[12,329,339],"become":[13],"increasingly":[14],"important.Previous":[15],"studies":[16,69,112,136],"on":[17,31,113,215],"education":[19,115],"have":[20],"identified":[21],"learning":[22,29,45,123,274,333],"challenges,":[23],"analyzed":[24],"student":[25,273],"errors,":[26],"and":[27,47,98,103,161,192,201,227,254,279,288,305,313,351],"developed":[28,73],"tools.Building":[30],"this":[32,325],"foundation,":[33],"my":[34,354],"research":[35],"provided":[36,220],"additional":[37],"directions":[38],"enhance":[40],"educators'":[41],"understanding":[42],"of":[43,67,176,184,267],"challenges":[46],"explored":[48],"tools":[49,187,234],"teach":[51],"more":[52,190],"effectively.Leveraging":[53],"large-scale":[54],"data":[55],"collected":[56],"from":[57],"a":[58,65,174,203,331],"public":[59],"institution's":[60],"database":[61],"course,":[62],"I":[63,101,133,179,199,219,285,301],"conducted":[64,134,202],"series":[66],"quantitative":[68,197],"with":[70,260],"students'":[71,81,105,122,141,212],"data.I":[72],"use":[74,183],"cases":[75],"pattern-mining":[77,89],"techniques":[78],"track":[80],"submission":[82],"attempts":[83],"their":[85],"assignments.With":[87],"advanced":[88],"techniques,":[90],"such":[91,347],"as":[92,348],"Levenshtein":[93],"Edit":[94],"Distance,":[95],"hierarchical":[96],"clustering,":[97],"sequence":[99,148],"alignment,":[100],"examined":[102],"captured":[104],"problem-solving":[106],"behaviors":[107],"under":[108],"various":[109],"conditions.Furthermore,":[110],"previous":[111],"general":[114],"suggested":[116],"several":[117,135],"factors":[118,139],"that":[119],"can":[120],"affect":[121],"ability,":[124],"including":[125,146],"study":[126,155,206],"time,":[127,156],"course":[128],"modality,":[129],"collaborative":[130,162],"environments,":[131],"etc.Thus,":[132],"explore":[138,255,344],"influencing":[140],"ability":[142],"learn":[144],"SQL,":[145],"in":[149,275,357],"which":[150,328],"query":[151],"languages":[152],"are":[153],"introduced,":[154],"assignment":[157],"types,":[158],"error":[159,177,252],"feedback,":[160,178,253],"environments.Lastly,":[163],"since":[164],"students":[165,237],"often":[166],"struggle":[167],"solve":[169],"problems":[171,269],"due":[172],"lack":[175],"also":[180,317,340],"investigated":[181],"generative":[185,249],"AI":[186,250],"provide":[189,245],"effective":[191],"personalized":[193],"feedback.To":[194],"complement":[195],"these":[196],"findings,":[198,218],"designed":[200],"qualitative":[204],"thinkaloud":[205],"gain":[208],"deeper":[209],"insights":[210],"into":[211],"challenges.Based":[214],"combined":[217],"actionable":[221],"recommendations":[222],"improve":[224],"strategies":[226],"curriculum":[228],"design.Instructors":[229],"should":[230],"adopt":[231],"pattern":[232],"mining":[233],"identify":[236],"needing":[238],"extra":[239],"support,":[240],"emphasize":[241],"non-timed":[242],"problems,":[244],"syntax":[246],"drills,":[247],"integrate":[248],"an":[256],"online":[257],"flipped-classroom":[258],"model":[259],"in-person":[261],"office":[262],"hours.Additionally,":[263],"studying":[264],"inclusion":[266],"Parsons":[268],"could":[270],"further":[271],"scaffold":[272],"SQL.needed":[276],"it":[277,338],"most,":[278],"your":[280],"dedication":[281],"making":[283,299],"sure":[284,300],"stayed":[286],"focused":[287],"motivated":[289],"made":[290],"all":[291],"difference.Thank":[293],"you":[294],"keeping":[296],"me":[297,307,342],"well-fed,":[298],"got":[302],"enough":[303],"sleep,":[304],"dragging":[306],"gym":[310],"de-stress":[312],"keep":[314],"fit.I":[315],"am":[316],"deeply":[318],"grateful":[319],"opportunity":[322],"complete":[324],"Ph.D.":[326],"program,":[327],"been":[330],"tremendous":[332],"experience.Beyond":[334],"academic":[336],"aspects,":[337],"allowed":[341],"new":[345],"passions,":[346],"latte":[349],"art":[350],"sewing,":[352],"enriching":[353],"personal":[355],"growth":[356],"unexpected":[358],"ways.":[359]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W7220826745","counts_by_year":[{"year":2026,"cited_by_count":2}],"updated_date":"2026-11-20T13:11:24.684918","created_date":"2026-10-07T00:00:00"}
