{"id":"https://openalex.org/W7167424643","doi":"https://doi.org/10.1145/3803400.3809307","title":"SQL Beyond Querying: Enhancing SQL Learning with Schema and Data Management","display_name":"SQL Beyond Querying: Enhancing SQL Learning with Schema and Data Management","publication_year":2026,"publication_date":"2026-07-06","ids":{"openalex":"https://openalex.org/W7167424643","doi":"https://doi.org/10.1145/3803400.3809307"},"language":null,"primary_location":{"id":"doi:10.1145/3803400.3809307","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3803400.3809307","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 31st ACM Conference on Innovation and Technology in Computer Science Education V. 1","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3803400.3809307","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5046399251","display_name":"Naaz Sibia","orcid":"https://orcid.org/0000-0001-7628-7077"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Naaz Sibia","raw_affiliation_strings":["University of Toronto, Toronto, Canada"],"raw_orcid":"https://orcid.org/0000-0001-7628-7077","affiliations":[{"raw_affiliation_string":"University of Toronto, Toronto, Canada","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5118273667","display_name":"Jessica Wen","orcid":"https://orcid.org/0009-0000-2766-5916"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Jessica Wen","raw_affiliation_strings":["University of Toronto, Mississauga, Canada"],"raw_orcid":"https://orcid.org/0009-0000-2766-5916","affiliations":[{"raw_affiliation_string":"University of Toronto, Mississauga, Canada","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063517583","display_name":"Zeling Zhang","orcid":"https://orcid.org/0009-0007-3583-5269"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Zeling Zhang","raw_affiliation_strings":["University of Toronto, Toronto, Canada"],"raw_orcid":"https://orcid.org/0009-0005-2678-205X","affiliations":[{"raw_affiliation_string":"University of Toronto, Toronto, Canada","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5053683828","display_name":"Runlong Ye","orcid":"https://orcid.org/0000-0003-1064-2333"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Runlong Ye","raw_affiliation_strings":["University of Toronto, Toronto, Canada"],"raw_orcid":"https://orcid.org/0000-0003-1064-2333","affiliations":[{"raw_affiliation_string":"University of Toronto, Toronto, Canada","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006025182","display_name":"Joshua D. A. Jung","orcid":"https://orcid.org/0000-0002-2694-7265"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Joshua D. A. Jung","raw_affiliation_strings":["University of Toronto, Mississaga, Canada"],"raw_orcid":"https://orcid.org/0000-0002-2694-7265","affiliations":[{"raw_affiliation_string":"University of Toronto, Mississaga, Canada","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022204507","display_name":"Ilya Musabirov","orcid":"https://orcid.org/0000-0003-2246-0094"},"institutions":[{"id":"https://openalex.org/I141945490","display_name":"University of British Columbia","ror":"https://ror.org/03rmrcq20","country_code":"CA","type":"education","lineage":["https://openalex.org/I141945490"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Ilya Musabirov","raw_affiliation_strings":["University of British Columbia, Vancouver, Canada"],"raw_orcid":"https://orcid.org/0000-0003-2246-0094","affiliations":[{"raw_affiliation_string":"University of British Columbia, Vancouver, Canada","institution_ids":["https://openalex.org/I141945490"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5074634692","display_name":"Bogdan Simion","orcid":"https://orcid.org/0000-0002-2554-8705"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Bogdan Simion","raw_affiliation_strings":["University of Toronto, Mississauga, Canada"],"raw_orcid":"https://orcid.org/0000-0002-2554-8705","affiliations":[{"raw_affiliation_string":"University of Toronto, Mississauga, Canada","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041109825","display_name":"Carlos An\u00edbal Su\u00e1rez","orcid":"https://orcid.org/0000-0002-6012-932X"},"institutions":[{"id":"https://openalex.org/I2135383","display_name":"Escuela Superior Politecnica del Litoral","ror":"https://ror.org/04qenc566","country_code":"EC","type":"education","lineage":["https://openalex.org/I2135383"]}],"countries":["EC"],"is_corresponding":false,"raw_author_name":"Carlos An\u00edbal Su\u00e1rez","raw_affiliation_strings":["Escuela Superior Polit\u00e9cnica del Litoral, Guayaquil, Ecuador"],"raw_orcid":"https://orcid.org/0000-0002-6012-932X","affiliations":[{"raw_affiliation_string":"Escuela Superior Polit\u00e9cnica del Litoral, Guayaquil, Ecuador","institution_ids":["https://openalex.org/I2135383"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041047487","display_name":"Paul Vrbik","orcid":"https://orcid.org/0000-0003-4131-6004"},"institutions":[{"id":"https://openalex.org/I165143802","display_name":"The University of Queensland","ror":"https://ror.org/00rqy9422","country_code":"AU","type":"education","lineage":["https://openalex.org/I165143802"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Paul Vrbik","raw_affiliation_strings":["University of Queensland, Brisbane, Australia"],"raw_orcid":"https://orcid.org/0000-0003-4131-6004","affiliations":[{"raw_affiliation_string":"University of Queensland, Brisbane, Australia","institution_ids":["https://openalex.org/I165143802"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047964559","display_name":"Andrew Petersen","orcid":"https://orcid.org/0000-0003-1337-7985"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Andrew Petersen","raw_affiliation_strings":["University of Toronto, Mississauga, Canada"],"raw_orcid":"https://orcid.org/0000-0003-1337-7985","affiliations":[{"raw_affiliation_string":"University of Toronto, Mississauga, Canada","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5069503439","display_name":"Angela Zavaleta Bernuy","orcid":"https://orcid.org/0000-0002-1228-5774"},"institutions":[{"id":"https://openalex.org/I98251732","display_name":"McMaster University","ror":"https://ror.org/02fa3aq29","country_code":"CA","type":"education","lineage":["https://openalex.org/I98251732"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Angela Zavaleta Bernuy","raw_affiliation_strings":["McMaster University, Hamilton, Canada"],"raw_orcid":"https://orcid.org/0000-0002-1228-5774","affiliations":[{"raw_affiliation_string":"McMaster University, Hamilton, Canada","institution_ids":["https://openalex.org/I98251732"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5017029944","display_name":"Michael Liut","orcid":"https://orcid.org/0000-0003-2965-5302"},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Michael Liut","raw_affiliation_strings":["University of Toronto, Mississauga, Canada"],"raw_orcid":"https://orcid.org/0000-0003-2965-5302","affiliations":[{"raw_affiliation_string":"University of Toronto, Mississauga, Canada","institution_ids":["https://openalex.org/I185261750"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"583","last_page":"589"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.2425999939441681,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.2425999939441681,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T13034","display_name":"Information Systems Education and Curriculum Development","score":0.032499998807907104,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T13820","display_name":"SAS software applications and methods","score":0.02879999950528145,"subfield":{"id":"https://openalex.org/subfields/2204","display_name":"Biomedical Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7001000046730042},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.5270000100135803},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.453900009393692},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.4138999879360199},{"id":"https://openalex.org/keywords/data-management","display_name":"Data management","score":0.40799999237060547},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.3521000146865845},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.3239000141620636}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7915999889373779},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7001000046730042},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5270000100135803},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.47189998626708984},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.453900009393692},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4138999879360199},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.40799999237060547},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3521000146865845},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.3239000141620636},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.3181000053882599},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3133000135421753},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3034000098705292},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.30309998989105225},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.295199990272522},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.2883000075817108},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.2840000092983246},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2831999957561493},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.2759999930858612},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.2703999876976013},{"id":"https://openalex.org/C33762810","wikidata":"https://www.wikidata.org/wiki/Q461671","display_name":"Data integrity","level":2,"score":0.2612999975681305},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.257999986410141}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3803400.3809307","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3803400.3809307","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 31st ACM Conference on Innovation and Technology in Computer Science Education V. 1","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3803400.3809307","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3803400.3809307","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 31st ACM Conference on Innovation and Technology in Computer Science Education V. 1","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W1857060863","https://openalex.org/W1982866217","https://openalex.org/W3041823931","https://openalex.org/W3211756673","https://openalex.org/W4323037334","https://openalex.org/W4386719007","https://openalex.org/W4391584344","https://openalex.org/W4396833300","https://openalex.org/W4406803685","https://openalex.org/W4412731808"],"related_works":[],"abstract_inverted_index":{"Motivation:":[0],"Database":[1],"courses":[2],"focus":[3],"on":[4,130,134,149],"SQL":[5,157],"querying":[6],"(DQL)":[7],"while":[8],"treating":[9],"schema":[10,28,161,174],"definition":[11],"(DDL)":[12],"and":[13,30,48,76,91,99,118,123,176,197],"data":[14,31,40,58,87,177],"manipulation":[15,178],"(DML)":[16],"as":[17,51,179,187],"side":[18],"topics,":[19],"even":[20],"though":[21],"real-world":[22],"database":[23,170],"work":[24],"begins":[25],"with":[26,155,195],"understanding":[27],"design":[29,175],"updates.":[32],"This":[33],"misalignment":[34],"leaves":[35],"students":[36],"underprepared":[37],"for":[38],"authentic":[39],"management":[41],"practice.":[42,82],"Method:":[43],"We":[44,83,101,168],"integrated":[45],"scaffolded":[46],"DDL":[47],"DML":[49],"exercises":[50],"a":[52,56],"core":[53,180],"concept":[54],"in":[55,69],"third-year":[57],"course":[59],"across":[60,97,121],"three":[61],"offerings":[62],"(2023-2025).":[63],"Students":[64,126],"completed":[65],"structured":[66],"weekly":[67],"tasks":[68,132,151],"an":[70],"LMS":[71,115],"that":[72,160],"provides":[73],"immediate":[74],"feedback":[75],"unlimited":[77],"attempts,":[78],"encouraging":[79],"low-stakes,":[80],"iterative":[81],"analyzed":[84,102],"student":[85],"interaction":[86],"(number":[88],"of":[89,114],"attempts":[90,117,129],"performance)":[92],"to":[93,172,182],"examine":[94],"learning":[95],"patterns":[96],"DDL/DML":[98,122,131],"DQL.":[100,124],"9,071":[103],"total":[104],"exercise":[105,116],"submissions":[106],"from":[107],"669":[108],"students,":[109],"examining":[110],"both":[111],"the":[112],"number":[113],"assignment":[119],"performance":[120,148],"Results:":[125],"required":[127],"fewer":[128],"than":[133],"traditional":[135],"DQL":[136],"tasks,":[137],"indicating":[138],"strong":[139],"receptiveness":[140],"when":[141],"these":[142,191],"topics":[143,181],"were":[144],"properly":[145],"scaffolded.":[146],"Early":[147],"schema-definition":[150],"was":[152],"moderately":[153],"correlated":[154],"later":[156],"performance,":[158],"suggesting":[159],"competence":[162],"supports":[163],"subsequent":[164,200],"query":[165,201],"learning.":[166,202],"Implications:":[167],"encourage":[169],"educators":[171],"teach":[173],"strengthen":[183],"students'":[184],"conceptual":[185],"foundations,":[186],"our":[188],"results":[189],"suggest":[190],"skills":[192],"are":[193],"learnable":[194],"scaffolding":[196],"may":[198],"support":[199]},"counts_by_year":[],"updated_date":"2026-07-15T18:14:33.161393","created_date":"2026-07-06T00:00:00"}