{"id":"https://openalex.org/W2216374816","doi":"https://doi.org/10.1145/1656255.1656257","title":"Learning SQL Programming with Interactive Tools","display_name":"Learning SQL Programming with Interactive Tools","publication_year":2010,"publication_date":"2010-01-01","ids":{"openalex":"https://openalex.org/W2216374816","doi":"https://doi.org/10.1145/1656255.1656257","mag":"2216374816"},"language":"en","primary_location":{"id":"doi:10.1145/1656255.1656257","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1656255.1656257","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":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5037674585","display_name":"Peter Brusilovsky","orcid":"https://orcid.org/0000-0002-1902-1464"},"institutions":[{"id":"https://openalex.org/I170201317","display_name":"University of Pittsburgh","ror":"https://ror.org/01an3r305","country_code":"US","type":"education","lineage":["https://openalex.org/I170201317"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Peter Brusilovsky","raw_affiliation_strings":["University of Pittsburgh"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Pittsburgh","institution_ids":["https://openalex.org/I170201317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024385593","display_name":"Sergey Sosnovsky","orcid":"https://orcid.org/0000-0001-8023-1770"},"institutions":[{"id":"https://openalex.org/I170201317","display_name":"University of Pittsburgh","ror":"https://ror.org/01an3r305","country_code":"US","type":"education","lineage":["https://openalex.org/I170201317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sergey Sosnovsky","raw_affiliation_strings":["University of Pittsburgh"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Pittsburgh","institution_ids":["https://openalex.org/I170201317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055898004","display_name":"Michael Yudelson","orcid":"https://orcid.org/0000-0002-8280-0348"},"institutions":[{"id":"https://openalex.org/I170201317","display_name":"University of Pittsburgh","ror":"https://ror.org/01an3r305","country_code":"US","type":"education","lineage":["https://openalex.org/I170201317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Michael V. Yudelson","raw_affiliation_strings":["University of Pittsburgh"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Pittsburgh","institution_ids":["https://openalex.org/I170201317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5015596585","display_name":"Danielle Lee","orcid":"https://orcid.org/0000-0003-2106-716X"},"institutions":[{"id":"https://openalex.org/I170201317","display_name":"University of Pittsburgh","ror":"https://ror.org/01an3r305","country_code":"US","type":"education","lineage":["https://openalex.org/I170201317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Danielle H. Lee","raw_affiliation_strings":["University of Pittsburgh"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Pittsburgh","institution_ids":["https://openalex.org/I170201317"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055251632","display_name":"Vladimir Zadorozhny","orcid":null},"institutions":[{"id":"https://openalex.org/I170201317","display_name":"University of Pittsburgh","ror":"https://ror.org/01an3r305","country_code":"US","type":"education","lineage":["https://openalex.org/I170201317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Vladimir Zadorozhny","raw_affiliation_strings":["University of Pittsburgh"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Pittsburgh","institution_ids":["https://openalex.org/I170201317"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5038970324","display_name":"Xin Zhou","orcid":"https://orcid.org/0000-0003-0383-9250"},"institutions":[{"id":"https://openalex.org/I170201317","display_name":"University of Pittsburgh","ror":"https://ror.org/01an3r305","country_code":"US","type":"education","lineage":["https://openalex.org/I170201317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xin Zhou","raw_affiliation_strings":["University of Pittsburgh"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Pittsburgh","institution_ids":["https://openalex.org/I170201317"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5037674585"],"corresponding_institution_ids":["https://openalex.org/I170201317"],"apc_list":null,"apc_paid":null,"fwci":3.7275,"has_fulltext":false,"cited_by_count":48,"citation_normalized_percentile":{"value":0.9363711,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"9","issue":"4","first_page":"1","last_page":"15"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.9876999855041504,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.9876999855041504,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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.9833999872207642,"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/T14025","display_name":"Educational Technology and Assessment","score":0.9599999785423279,"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/computer-science","display_name":"Computer science","score":0.8211480379104614},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5246627330780029},{"id":"https://openalex.org/keywords/multimedia","display_name":"Multimedia","score":0.4358025789260864},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.42238855361938477},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3846520781517029},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.33253899216651917},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.16249680519104004}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8211480379104614},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5246627330780029},{"id":"https://openalex.org/C49774154","wikidata":"https://www.wikidata.org/wiki/Q131765","display_name":"Multimedia","level":1,"score":0.4358025789260864},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.42238855361938477},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3846520781517029},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.33253899216651917},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.16249680519104004},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1656255.1656257","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1656255.1656257","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"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6299999952316284,"display_name":"Quality Education","id":"https://metadata.un.org/sdg/4"}],"awards":[{"id":"https://openalex.org/G4071032715","display_name":null,"funder_award_id":"DUE-0633494","funder_id":"https://openalex.org/F4320337408","funder_display_name":"Division of Undergraduate Education"}],"funders":[{"id":"https://openalex.org/F4320337408","display_name":"Division of Undergraduate Education","ror":"https://ror.org/02kd4km72"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":31,"referenced_works":["https://openalex.org/W107038654","https://openalex.org/W162507755","https://openalex.org/W192428607","https://openalex.org/W1480916553","https://openalex.org/W1485710154","https://openalex.org/W1494213487","https://openalex.org/W1512762573","https://openalex.org/W1527903961","https://openalex.org/W1549668994","https://openalex.org/W1594781181","https://openalex.org/W1596596196","https://openalex.org/W1835654028","https://openalex.org/W1905666496","https://openalex.org/W1970493359","https://openalex.org/W1991140109","https://openalex.org/W1993221100","https://openalex.org/W2011607672","https://openalex.org/W2044919367","https://openalex.org/W2049128813","https://openalex.org/W2115111591","https://openalex.org/W2122632599","https://openalex.org/W2124023547","https://openalex.org/W2125054539","https://openalex.org/W2131924543","https://openalex.org/W2142635908","https://openalex.org/W2147275720","https://openalex.org/W2159297191","https://openalex.org/W4235706597","https://openalex.org/W4299999595","https://openalex.org/W4378898217","https://openalex.org/W6607746322"],"related_works":["https://openalex.org/W2748952813","https://openalex.org/W2769255368","https://openalex.org/W304855073","https://openalex.org/W2088661596","https://openalex.org/W2032169142","https://openalex.org/W2511882081","https://openalex.org/W938111471","https://openalex.org/W2518250394","https://openalex.org/W4321848582","https://openalex.org/W2267221041"],"abstract_inverted_index":{"Rich,":[0],"interactive":[1,44,73],"eLearning":[2],"tools":[3,20,46,92],"receive":[4],"a":[5,51],"lot":[6],"of":[7,18,27,41,50,72,79,90,96],"attention":[8],"nowadays":[9],"from":[10],"both":[11,87],"practitioners":[12],"and":[13,38,93],"researchers.":[14],"However,":[15],"broader":[16],"dissemination":[17],"these":[19],"is":[21],"hindered":[22],"by":[23],"the":[24,36,48,80,88,94],"technical":[25,37],"difficulties":[26],"their":[28],"integration":[29,89],"into":[30],"existing":[31],"platforms.":[32],"This":[33],"article":[34],"explores":[35],"conceptual":[39],"problems":[40],"using":[42],"several":[43,70,91],"educational":[45],"in":[47,86],"context":[49],"single":[52],"course.":[53],"It":[54],"presents":[55],"an":[56,62],"integrated":[57],"Exploratorium":[58,81],"for":[59],"database":[60],"courses,":[61],"experimental":[63],"platform,":[64],"which":[65],"provides":[66],"personalized":[67,97],"access":[68],"to":[69],"types":[71],"learning":[74],"activities.":[75],"Several":[76],"classroom":[77],"studies":[78],"have":[82],"demonstrated":[83],"its":[84],"value":[85],"provision":[95],"access.":[98]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":7},{"year":2020,"cited_by_count":5},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":6},{"year":2015,"cited_by_count":5},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":4},{"year":2012,"cited_by_count":2}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}