{"id":"https://openalex.org/W3041823931","doi":"https://doi.org/10.1145/3398377","title":"SQL Education","display_name":"SQL Education","publication_year":2020,"publication_date":"2020-07-07","ids":{"openalex":"https://openalex.org/W3041823931","doi":"https://doi.org/10.1145/3398377","mag":"3041823931"},"language":"en","primary_location":{"id":"doi:10.1145/3398377","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3398377","pdf_url":null,"source":{"id":"https://openalex.org/S2764465379","display_name":"ACM Transactions on Computing Education","issn_l":"1946-6226","issn":["1946-6226"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Computing Education","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://urn.fi/URN:NBN:fi:jyu-202008175541","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5005256813","display_name":"Toni Taipalus","orcid":"https://orcid.org/0000-0003-4060-3431"},"institutions":[{"id":"https://openalex.org/I94722563","display_name":"University of Jyv\u00e4skyl\u00e4","ror":"https://ror.org/05n3dz165","country_code":"FI","type":"education","lineage":["https://openalex.org/I94722563"]}],"countries":["FI"],"is_corresponding":false,"raw_author_name":"Toni Taipalus","raw_affiliation_strings":["University of Jyvaskyla, Jyvaskyla, Finland"],"raw_orcid":"https://orcid.org/0000-0003-4060-3431","affiliations":[{"raw_affiliation_string":"University of Jyvaskyla, Jyvaskyla, Finland","institution_ids":["https://openalex.org/I94722563"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5005725738","display_name":"Ville Sepp\u00e4nen","orcid":"https://orcid.org/0000-0003-3843-4843"},"institutions":[{"id":"https://openalex.org/I94722563","display_name":"University of Jyv\u00e4skyl\u00e4","ror":"https://ror.org/05n3dz165","country_code":"FI","type":"education","lineage":["https://openalex.org/I94722563"]}],"countries":["FI"],"is_corresponding":false,"raw_author_name":"Ville Sepp\u00e4nen","raw_affiliation_strings":["University of Jyvaskyla, Jyvaskyla, Finland"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Jyvaskyla, Jyvaskyla, Finland","institution_ids":["https://openalex.org/I94722563"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":10.9221,"has_fulltext":true,"cited_by_count":45,"citation_normalized_percentile":{"value":0.98002124,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"20","issue":"3","first_page":"1","last_page":"33"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9927999973297119,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9927999973297119,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9904000163078308,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9718000292778015,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7936315536499023},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7895815372467041},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.5022978782653809},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.4915197789669037},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.4762280583381653},{"id":"https://openalex.org/keywords/mathematics-education","display_name":"Mathematics education","score":0.38579151034355164},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.32906466722488403},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3079069256782532},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.2903461754322052},{"id":"https://openalex.org/keywords/psychology","display_name":"Psychology","score":0.13251376152038574},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.10933792591094971}],"concepts":[{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7936315536499023},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7895815372467041},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5022978782653809},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.4915197789669037},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.4762280583381653},{"id":"https://openalex.org/C145420912","wikidata":"https://www.wikidata.org/wiki/Q853077","display_name":"Mathematics education","level":1,"score":0.38579151034355164},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.32906466722488403},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3079069256782532},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2903461754322052},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.13251376152038574},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.10933792591094971},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3398377","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3398377","pdf_url":null,"source":{"id":"https://openalex.org/S2764465379","display_name":"ACM Transactions on Computing Education","issn_l":"1946-6226","issn":["1946-6226"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"ACM Transactions on Computing Education","raw_type":"journal-article"},{"id":"pmh:oai:jyx.jyu.fi:123456789/71405","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3398377\"","pdf_url":"http://urn.fi/URN:NBN:fi:jyu-202008175541","source":{"id":"https://openalex.org/S4306400563","display_name":"Jyv\u00e4skyl\u00e4 University Digital Archive (University of Jyv\u00e4skyl\u00e4)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I94722563","host_organization_name":"University of Jyv\u00e4skyl\u00e4","host_organization_lineage":["https://openalex.org/I94722563"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":null,"raw_type":"A1"}],"best_oa_location":{"id":"pmh:oai:jyx.jyu.fi:123456789/71405","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3398377\"","pdf_url":"http://urn.fi/URN:NBN:fi:jyu-202008175541","source":{"id":"https://openalex.org/S4306400563","display_name":"Jyv\u00e4skyl\u00e4 University Digital Archive (University of Jyv\u00e4skyl\u00e4)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I94722563","host_organization_name":"University of Jyv\u00e4skyl\u00e4","host_organization_lineage":["https://openalex.org/I94722563"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":null,"raw_type":"A1"},"sustainable_development_goals":[{"score":0.8600000143051147,"id":"https://metadata.un.org/sdg/4","display_name":"Quality Education"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3041823931.pdf","grobid_xml":"https://content.openalex.org/works/W3041823931.grobid-xml"},"referenced_works_count":108,"referenced_works":["https://openalex.org/W2996343","https://openalex.org/W197224857","https://openalex.org/W782406479","https://openalex.org/W932325504","https://openalex.org/W1514596996","https://openalex.org/W1519179082","https://openalex.org/W1588302298","https://openalex.org/W1603605179","https://openalex.org/W1964220204","https://openalex.org/W1964849062","https://openalex.org/W1965187559","https://openalex.org/W1966484608","https://openalex.org/W1968344832","https://openalex.org/W1975675278","https://openalex.org/W1976467438","https://openalex.org/W1977341090","https://openalex.org/W1983101943","https://openalex.org/W1992389722","https://openalex.org/W1995994586","https://openalex.org/W1996794063","https://openalex.org/W1999389087","https://openalex.org/W1999798506","https://openalex.org/W2003088359","https://openalex.org/W2008411739","https://openalex.org/W2012056301","https://openalex.org/W2013012235","https://openalex.org/W2016487901","https://openalex.org/W2020888858","https://openalex.org/W2021489471","https://openalex.org/W2022001143","https://openalex.org/W2023745308","https://openalex.org/W2026765776","https://openalex.org/W2032133388","https://openalex.org/W2037037908","https://openalex.org/W2041191762","https://openalex.org/W2047048300","https://openalex.org/W2050746063","https://openalex.org/W2051629332","https://openalex.org/W2055008679","https://openalex.org/W2069163190","https://openalex.org/W2071087703","https://openalex.org/W2071100465","https://openalex.org/W2073280341","https://openalex.org/W2077924815","https://openalex.org/W2078170084","https://openalex.org/W2083150957","https://openalex.org/W2088579995","https://openalex.org/W2102449305","https://openalex.org/W2117817374","https://openalex.org/W2118525229","https://openalex.org/W2127478418","https://openalex.org/W2128286288","https://openalex.org/W2128421187","https://openalex.org/W2128886782","https://openalex.org/W2128961774","https://openalex.org/W2132032354","https://openalex.org/W2132516581","https://openalex.org/W2142225512","https://openalex.org/W2142913546","https://openalex.org/W2144926975","https://openalex.org/W2146405170","https://openalex.org/W2148109093","https://openalex.org/W2150147167","https://openalex.org/W2153828680","https://openalex.org/W2159913255","https://openalex.org/W2169973224","https://openalex.org/W2185907055","https://openalex.org/W2216374816","https://openalex.org/W2248418826","https://openalex.org/W2274794968","https://openalex.org/W2286501037","https://openalex.org/W2313453726","https://openalex.org/W2473995384","https://openalex.org/W2523102177","https://openalex.org/W2547115911","https://openalex.org/W2566242191","https://openalex.org/W2589828095","https://openalex.org/W2620330344","https://openalex.org/W2771382620","https://openalex.org/W2793987010","https://openalex.org/W2803594882","https://openalex.org/W2809686080","https://openalex.org/W2885090162","https://openalex.org/W2905785337","https://openalex.org/W2916040897","https://openalex.org/W2916175497","https://openalex.org/W2921198338","https://openalex.org/W2945526390","https://openalex.org/W2964115955","https://openalex.org/W2965330894","https://openalex.org/W2969260140","https://openalex.org/W2972483799","https://openalex.org/W2975800273","https://openalex.org/W2992650155","https://openalex.org/W2993700405","https://openalex.org/W3000662571","https://openalex.org/W3010914864","https://openalex.org/W3035517302","https://openalex.org/W3164927089","https://openalex.org/W4250744454","https://openalex.org/W4253645963","https://openalex.org/W4285719527","https://openalex.org/W4300988679","https://openalex.org/W6678407692","https://openalex.org/W6685007085","https://openalex.org/W6727979115","https://openalex.org/W6757014105","https://openalex.org/W7034118277"],"related_works":["https://openalex.org/W650213220","https://openalex.org/W1592149428","https://openalex.org/W1980548249","https://openalex.org/W2042813897","https://openalex.org/W3114457612","https://openalex.org/W151494989","https://openalex.org/W2120791976","https://openalex.org/W3094396153","https://openalex.org/W2974218799","https://openalex.org/W2340883001"],"abstract_inverted_index":{"Structured":[0],"Query":[1],"Language":[2],"(SQL)":[3],"skills":[4],"are":[5,79,273],"crucial":[6],"in":[7,173,212,243],"software":[8],"engineering":[9],"and":[10,21,28,47,56,91,94,97,145,178,186,194,196,227,265],"computer":[11],"science.":[12],"However,":[13],"teaching":[14,100,189,204,241],"SQL":[15,38,66,86,99,225,244,263,278],"effectively":[16],"requires":[17],"both":[18],"pedagogical":[19],"skill":[20],"considerable":[22],"knowledge":[23,239],"of":[24,37,75,84,159,180,223,238,250],"the":[25,35,118,138,152,181,206],"language.":[26],"Educators":[27],"scholars":[29],"have":[30,68],"proposed":[31],"numerous":[32,46],"considerations":[33,42],"for":[34,52,102,210],"betterment":[36],"education,":[39],"yet":[40],"these":[41],"may":[43],"be":[44],"too":[45],"scattered":[48],"among":[49],"different":[50],"fora":[51],"educators":[53,103],"to":[54,80,95,104,131,142,150,275],"find":[55],"internalize,":[57],"as":[58],"no":[59],"systematic":[60,124,221],"mappings":[61],"or":[62],"literature":[63],"reviews":[64],"regarding":[65],"education":[67,245],"been":[69],"conducted.":[70],"The":[71],"two":[72],"main":[73],"goals":[74],"this":[76],"mapping":[77,119,125],"study":[78,126],"provide":[81,219],"an":[82,235],"overview":[83],"educational":[85,224,277],"research":[87,89,112,143,226,229],"topics,":[88],"types,":[90],"publication":[92],"fora,":[93],"collect":[96],"propagate":[98],"practices":[101,242],"utilize.":[105],"Additionally,":[106],"we":[107,165,218,233,255],"present":[108,234],"a":[109,123,220,247],"short":[110],"future":[111,228],"agenda":[113],"based":[114],"on":[115,240,261,267],"insights":[116],"from":[117],"process.":[120],"We":[121,136,201],"conducted":[122],"complemented":[127],"by":[128,155],"snowballing":[129],"techniques":[130],"identify":[132],"applicable":[133],"primary":[134,139,153,163,207],"studies.":[135],"classified":[137],"studies":[140,154,208,260,266],"according":[141],"type":[144],"utilized":[146],"directed":[147],"content":[148],"analysis":[149],"classify":[151],"their":[156],"topic.":[157],"Out":[158],"our":[160],"selected":[161],"89":[162],"studies,":[164,259],"identified":[166],"six":[167],"recurring":[168],"topics:":[169],"(i)":[170],"student":[171],"errors":[172],"query":[174],"formulation;":[175],"(ii)":[176],"characteristics":[177],"presentation":[179],"exercise":[182],"database;":[183],"(iii)":[184],"specific":[185],"(iv)":[187],"non-specific":[188],"approach":[190],"suggestions;":[191],"(v)":[192],"patterns":[193],"visualization;":[195],"(vi)":[197],"easing":[198],"teacher":[199],"workload.":[200],"list":[202],"66":[203],"approaches":[205],"argued":[209],"(and":[211],"some":[213],"cases":[214],"against).":[215],"For":[216,231],"researchers,":[217],"map":[222],"agenda.":[230],"educators,":[232],"aggregated":[236],"body":[237],"over":[246],"time":[248],"frame":[249],"30":[251],"years.":[252],"In":[253],"conclusion,":[254],"suggest":[256],"that":[257],"replication":[258],"advanced":[262],"concepts,":[264],"aspects":[268],"other":[269],"than":[270],"data":[271],"retrieval":[272],"needed":[274],"further":[276],"research.":[279]},"counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":11},{"year":2024,"cited_by_count":7},{"year":2023,"cited_by_count":12},{"year":2022,"cited_by_count":7},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2020-07-16T00:00:00"}