Self-paced, instructor-assisted approach to teaching SQL
We present a novel approach to teaching Structured Query Language (SQL), which is suitable for both college classroom environment and asynchronous remote instruction. Instead of sitting passively and listening to a lecture, students work at their own pace through bite-sized tutorials, examples, exer...
Gespeichert in:
| Veröffentlicht in: | Journal of computational and applied mathematics Jg. 472; S. 116837 |
|---|---|
| 1. Verfasser: | |
| Format: | Journal Article |
| Sprache: | Englisch |
| Veröffentlicht: |
Elsevier B.V
15.01.2026
|
| Schlagworte: | |
| ISSN: | 0377-0427 |
| Online-Zugang: | Volltext |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| Abstract | We present a novel approach to teaching Structured Query Language (SQL), which is suitable for both college classroom environment and asynchronous remote instruction. Instead of sitting passively and listening to a lecture, students work at their own pace through bite-sized tutorials, examples, exercises, practical tasks, and quizzes. Their work is checked in real time by an AI-based software platform which also provides instant personalized adaptive guidance. Students must prove mastery of each concept before being allowed to tackle the next one. In this way, they are active 100% of the time, and get much more hands-on practice than in traditional instruction. The instructor does not lecture, which allows him or her to interact with students individually. It turns out that students not only enjoy the one-to-one interaction with their instructor much more than listening to lectures, but they also greatly benefit from it. In this paper we provide a concise overview of the teaching method, and then we focus on automated server-side analysis and grading of SQL queries, which is the cornerstone of the self-paced SQL course. We introduce a number of Python-based SQL analyzers for various types of queries, and present links to three live SQL assignments for the reader to experiment with. Our SQLgrader library is available on Github under an open source license. |
|---|---|
| AbstractList | We present a novel approach to teaching Structured Query Language (SQL), which is suitable for both college classroom environment and asynchronous remote instruction. Instead of sitting passively and listening to a lecture, students work at their own pace through bite-sized tutorials, examples, exercises, practical tasks, and quizzes. Their work is checked in real time by an AI-based software platform which also provides instant personalized adaptive guidance. Students must prove mastery of each concept before being allowed to tackle the next one. In this way, they are active 100% of the time, and get much more hands-on practice than in traditional instruction. The instructor does not lecture, which allows him or her to interact with students individually. It turns out that students not only enjoy the one-to-one interaction with their instructor much more than listening to lectures, but they also greatly benefit from it. In this paper we provide a concise overview of the teaching method, and then we focus on automated server-side analysis and grading of SQL queries, which is the cornerstone of the self-paced SQL course. We introduce a number of Python-based SQL analyzers for various types of queries, and present links to three live SQL assignments for the reader to experiment with. Our SQLgrader library is available on Github under an open source license. |
| ArticleNumber | 116837 |
| Author | Solin, Pavel |
| Author_xml | – sequence: 1 givenname: Pavel orcidid: 0009-0005-8781-975X surname: Solin fullname: Solin, Pavel email: solin@unr.edu, pavel@nclab.com organization: University of Nevada, Reno, 1664 N Virginia St, Reno, NV 89557, USA |
| BookMark | eNp9z0tOwzAQgGEvikRbOAC7HIAET-L4IVao4iVFQqiwtmxnDK7aJLINErcnVVmzmtn8o_lWZDGMAxJyBbQCCvxmVzlzqGpatxUAl41YkCVthCgpq8U5WaW0o5RyBWxJ5Bb3vpyMw_66CEPK8cvlMZYmpZAy9oWZpjga91nkscg4L2H4KLav3QU582af8PJvrsn7w_3b5qnsXh6fN3dd6eoWcsnAKWFZw4VSvvVeAmDbMCd5T6010jIlqXKC1SiY9ZS1Fjhvba08ouplsyZwuuvimFJEr6cYDib-aKD6yNU7PXP1katP3Lm5PTU4P_YdMOrkAg6zMUR0Wfdj-Kf-BbCvYDU |
| Cites_doi | 10.1080/03797720802522627 10.1007/s11786-023-00560-z 10.1145/362384.362685 10.1007/s11786-021-00499-z |
| ContentType | Journal Article |
| Copyright | 2025 Elsevier B.V. |
| Copyright_xml | – notice: 2025 Elsevier B.V. |
| DBID | AAYXX CITATION |
| DOI | 10.1016/j.cam.2025.116837 |
| DatabaseName | CrossRef |
| DatabaseTitle | CrossRef |
| DatabaseTitleList | |
| DeliveryMethod | fulltext_linktorsrc |
| Discipline | Mathematics |
| ExternalDocumentID | 10_1016_j_cam_2025_116837 S0377042725003516 |
| GroupedDBID | --K --M -~X .~1 0R~ 1B1 1RT 1~. 1~5 4.4 457 4G. 5GY 7-5 71M 8P~ 9JN AABNK AAEDT AAEDW AAIKJ AAKOC AAOAW AAQFI AATTM AAXKI AAXUO ABAOU ABJNI ABMAC ACDAQ ACGFS ACRLP ACVFH ADBBV ADCNI ADEZE AEBSH AEIPS AEKER AENEX AEUPX AFJKZ AFPUW AFTJW AGCQF AGUBO AGYEJ AHHHB AIEXJ AIGII AIGVJ AIIUN AIKHN AITUG AKBMS AKRWK AKYEP ALMA_UNASSIGNED_HOLDINGS AMRAJ ANKPU APXCP ARUGR AXJTR BKOJK BLXMC CS3 DU5 EBS EFJIC EFKBS EO8 EO9 EP2 EP3 F5P FDB FEDTE FIRID FNPLU FYGXN G-Q GBLVA HVGLF IHE IXB J1W KOM LG9 M26 M41 MHUIS MO0 N9A O-L O9- OAUVE OK1 OZT P-8 P-9 P2P PC. Q38 RNS ROL RPZ SDF SDG SDP SES SEW SPC SPCBC SSW T5K TN5 UPT XPP YQT ZMT ~02 ~G- 29K 5VS 9DU AAFWJ AALRI AAQXK AAYWO AAYXX ABDPE ABEFU ABFNM ABWVN ABXDB ACLOT ACRPL ADMUD ADNMO ADVLN AEXQZ AGHFR AGQPQ ASPBG AVWKF AZFZN CITATION D-I EFLBG EJD FGOYB G-2 HZ~ NHB R2- SSZ WUQ ZY4 ~HD |
| ID | FETCH-LOGICAL-c251t-41c97b436799f5ff811e534c86d0bba8b49809c742e74bf045b1665b29fee9d83 |
| ISICitedReferencesCount | 0 |
| ISICitedReferencesURI | http://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=Summon&SrcAuth=ProQuest&DestLinkType=CitingArticles&DestApp=WOS_CPL&KeyUT=001517183300001&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D |
| ISSN | 0377-0427 |
| IngestDate | Sat Nov 29 07:42:38 EST 2025 Sat Aug 23 17:12:45 EDT 2025 |
| IsPeerReviewed | true |
| IsScholarly | true |
| Keywords | Structured query language (SQL) Competency-based education (CBE) Learning-by-doing Asynchronous learning Online learning Self-paced learning |
| Language | English |
| LinkModel | OpenURL |
| MergedId | FETCHMERGED-LOGICAL-c251t-41c97b436799f5ff811e534c86d0bba8b49809c742e74bf045b1665b29fee9d83 |
| ORCID | 0009-0005-8781-975X |
| ParticipantIDs | crossref_primary_10_1016_j_cam_2025_116837 elsevier_sciencedirect_doi_10_1016_j_cam_2025_116837 |
| PublicationCentury | 2000 |
| PublicationDate | 2026-01-15 |
| PublicationDateYYYYMMDD | 2026-01-15 |
| PublicationDate_xml | – month: 01 year: 2026 text: 2026-01-15 day: 15 |
| PublicationDecade | 2020 |
| PublicationTitle | Journal of computational and applied mathematics |
| PublicationYear | 2026 |
| Publisher | Elsevier B.V |
| Publisher_xml | – name: Elsevier B.V |
| References | Andrews, Higson (b12) 2008; 33 Solin, Freyer (b7) 2023; 17 Solin (b6) 2021; 15 Melton, Simon (b8) 1993 Bennett, Richardson, MacKinnon (b14) 2016 Connolly, Begg (b17) 2006; 17 Pane, Myers (b16) 2000; vol. 12, no. 1 Codd (b9) 1970; 13 Archer, Davison (b11) 2008 Chaudhuri (b10) 1998 T.W. Burns, W. Yeoh, Bridging the SQL Skills Gap: Curriculum and Pedagogical Improvements in an Introductory Database Course, in: Proceedings of the EDSIG Conference on Information Systems and Computing Education, 2015. Radford, Lansley (b18) 2016; 8 SQLParse Library Olivier, Matray (b4) 2018; 29 (Accessed 20 December 2024). NCLab Katsaros, Katsanou, Tzimikas (b1) 2020; 57 Visual, Sibley, Hammond (b2) 2022; 27 Krogstie, Christensen (b5) 2017; 112 Levine, Van Pelt (b19) 2021 MySQL World Sample Database Sabin, Kafali (b3) 2019; 29 Mourshed, Farrell, Barton (b13) 2012 Radford (10.1016/j.cam.2025.116837_b18) 2016; 8 Codd (10.1016/j.cam.2025.116837_b9) 1970; 13 Pane (10.1016/j.cam.2025.116837_b16) 2000; vol. 12, no. 1 Melton (10.1016/j.cam.2025.116837_b8) 1993 Andrews (10.1016/j.cam.2025.116837_b12) 2008; 33 Mourshed (10.1016/j.cam.2025.116837_b13) 2012 Connolly (10.1016/j.cam.2025.116837_b17) 2006; 17 Chaudhuri (10.1016/j.cam.2025.116837_b10) 1998 Bennett (10.1016/j.cam.2025.116837_b14) 2016 Katsaros (10.1016/j.cam.2025.116837_b1) 2020; 57 Archer (10.1016/j.cam.2025.116837_b11) 2008 Levine (10.1016/j.cam.2025.116837_b19) 2021 Solin (10.1016/j.cam.2025.116837_b7) 2023; 17 10.1016/j.cam.2025.116837_b15 Solin (10.1016/j.cam.2025.116837_b6) 2021; 15 Sabin (10.1016/j.cam.2025.116837_b3) 2019; 29 Visual (10.1016/j.cam.2025.116837_b2) 2022; 27 Olivier (10.1016/j.cam.2025.116837_b4) 2018; 29 10.1016/j.cam.2025.116837_b20 Krogstie (10.1016/j.cam.2025.116837_b5) 2017; 112 10.1016/j.cam.2025.116837_b21 10.1016/j.cam.2025.116837_b22 |
| References_xml | – reference: . (Accessed 20 December 2024). – volume: 57 start-page: 2028 year: 2020 end-page: 2047 ident: b1 article-title: A comparative study on teaching SQL programming through traditional and gamified approaches publication-title: J. Educ. Comput. Res. – reference: T.W. Burns, W. Yeoh, Bridging the SQL Skills Gap: Curriculum and Pedagogical Improvements in an Introductory Database Course, in: Proceedings of the EDSIG Conference on Information Systems and Computing Education, 2015. – volume: 8 start-page: 1 year: 2016 end-page: 16 ident: b18 article-title: Addressing the SQL skills gap: An experiential learning approach publication-title: Int. J. Database Manag. Syst. (IJDMS) – year: 2021 ident: b19 article-title: The Great Upheaval: Higher Education’s Past, Present, and Uncertain Future – volume: 13 start-page: 377 year: 1970 end-page: 387 ident: b9 article-title: A relational model of data for large shared data banks publication-title: Commun. ACM – year: 2008 ident: b11 article-title: Graduate employability: The view of employers publication-title: Lond.: Counc. Ind. High. Educ. (CIHE) – year: 2016 ident: b14 article-title: Enacting strategies for graduate employability: How universities can best support students to develop generic skills publication-title: National Centre for Student Equity in Higher Edu- cation – start-page: 34 year: 1998 end-page: 43 ident: b10 article-title: An overview of query optimization in relational systems publication-title: Proc. ACM SIGMOD Int. Conf. Manag. Data – volume: 33 start-page: 411 year: 2008 end-page: 422 ident: b12 article-title: Graduate employability, ’soft skills’ versus ’hard’ business knowledge: A European study publication-title: High. Educ. Eur. – volume: vol. 12, no. 1 start-page: 53 year: 2000 end-page: 60 ident: b16 article-title: Improving the learnability of SQL publication-title: Proceedings of the ACM CHI 2000 Conference on Human Factors in Computing Systems – year: 2012 ident: b13 article-title: Education to Employment: Designing a System that Works – volume: 17 year: 2023 ident: b7 article-title: Self-paced, instructor-assisted approach to teaching python programming publication-title: Math. Comput. Sci. – volume: 112 start-page: 92 year: 2017 end-page: 105 ident: b5 article-title: An experiment in teaching SQL using collaborative problem solving in online learning environments publication-title: Comput. Educ. – volume: 15 year: 2021 ident: b6 article-title: Self-paced, instructor-assisted approach to teaching linear algebra publication-title: Math. Comput. Sci. – reference: . MySQL World Sample Database, – volume: 29 start-page: 155 year: 2019 end-page: 164 ident: b3 article-title: Teaching SQL query formulation through semantic mapping and visualization publication-title: J. Comput. Sci. Educ. – year: 1993 ident: b8 article-title: Understanding the new SQL: A complete guide – reference: . SQLParse Library, – reference: . NCLab, – volume: 27 start-page: 527 year: 2022 end-page: 543 ident: b2 article-title: Interactive visual learning tools for teaching SQL and database concepts publication-title: Educ. Inf. Technol. – volume: 29 start-page: 155 year: 2018 end-page: 164 ident: b4 article-title: Flipped classrooms in teaching SQL: Student perceptions and learning outcomes publication-title: J. Inf. Syst. Educ. – volume: 17 start-page: 43 year: 2006 end-page: 53 ident: b17 article-title: A constructivist-based approach to teaching database analysis and design publication-title: J. Inf. Syst. Educ. – year: 1993 ident: 10.1016/j.cam.2025.116837_b8 – volume: 29 start-page: 155 issue: 4 year: 2019 ident: 10.1016/j.cam.2025.116837_b3 article-title: Teaching SQL query formulation through semantic mapping and visualization publication-title: J. Comput. Sci. Educ. – volume: 27 start-page: 527 year: 2022 ident: 10.1016/j.cam.2025.116837_b2 article-title: Interactive visual learning tools for teaching SQL and database concepts publication-title: Educ. Inf. Technol. – start-page: 34 year: 1998 ident: 10.1016/j.cam.2025.116837_b10 article-title: An overview of query optimization in relational systems publication-title: Proc. ACM SIGMOD Int. Conf. Manag. Data – ident: 10.1016/j.cam.2025.116837_b21 – ident: 10.1016/j.cam.2025.116837_b22 – volume: 29 start-page: 155 issue: 3 year: 2018 ident: 10.1016/j.cam.2025.116837_b4 article-title: Flipped classrooms in teaching SQL: Student perceptions and learning outcomes publication-title: J. Inf. Syst. Educ. – volume: 33 start-page: 411 issue: 4 year: 2008 ident: 10.1016/j.cam.2025.116837_b12 article-title: Graduate employability, ’soft skills’ versus ’hard’ business knowledge: A European study publication-title: High. Educ. Eur. doi: 10.1080/03797720802522627 – ident: 10.1016/j.cam.2025.116837_b15 – volume: 17 start-page: 43 issue: 1 year: 2006 ident: 10.1016/j.cam.2025.116837_b17 article-title: A constructivist-based approach to teaching database analysis and design publication-title: J. Inf. Syst. Educ. – year: 2012 ident: 10.1016/j.cam.2025.116837_b13 – volume: vol. 12, no. 1 start-page: 53 year: 2000 ident: 10.1016/j.cam.2025.116837_b16 article-title: Improving the learnability of SQL – year: 2021 ident: 10.1016/j.cam.2025.116837_b19 – volume: 17 issue: 2 year: 2023 ident: 10.1016/j.cam.2025.116837_b7 article-title: Self-paced, instructor-assisted approach to teaching python programming publication-title: Math. Comput. Sci. doi: 10.1007/s11786-023-00560-z – volume: 112 start-page: 92 year: 2017 ident: 10.1016/j.cam.2025.116837_b5 article-title: An experiment in teaching SQL using collaborative problem solving in online learning environments publication-title: Comput. Educ. – year: 2008 ident: 10.1016/j.cam.2025.116837_b11 article-title: Graduate employability: The view of employers publication-title: Lond.: Counc. Ind. High. Educ. (CIHE) – volume: 57 start-page: 2028 issue: 8 year: 2020 ident: 10.1016/j.cam.2025.116837_b1 article-title: A comparative study on teaching SQL programming through traditional and gamified approaches publication-title: J. Educ. Comput. Res. – year: 2016 ident: 10.1016/j.cam.2025.116837_b14 article-title: Enacting strategies for graduate employability: How universities can best support students to develop generic skills – volume: 13 start-page: 377 issue: 6 year: 1970 ident: 10.1016/j.cam.2025.116837_b9 article-title: A relational model of data for large shared data banks publication-title: Commun. ACM doi: 10.1145/362384.362685 – ident: 10.1016/j.cam.2025.116837_b20 – volume: 8 start-page: 1 issue: 4 year: 2016 ident: 10.1016/j.cam.2025.116837_b18 article-title: Addressing the SQL skills gap: An experiential learning approach publication-title: Int. J. Database Manag. Syst. (IJDMS) – volume: 15 issue: 4 year: 2021 ident: 10.1016/j.cam.2025.116837_b6 article-title: Self-paced, instructor-assisted approach to teaching linear algebra publication-title: Math. Comput. Sci. doi: 10.1007/s11786-021-00499-z |
| SSID | ssj0006914 |
| Score | 2.4611928 |
| Snippet | We present a novel approach to teaching Structured Query Language (SQL), which is suitable for both college classroom environment and asynchronous remote... |
| SourceID | crossref elsevier |
| SourceType | Index Database Publisher |
| StartPage | 116837 |
| SubjectTerms | Asynchronous learning Competency-based education (CBE) Learning-by-doing Online learning Self-paced learning Structured query language (SQL) |
| Title | Self-paced, instructor-assisted approach to teaching SQL |
| URI | https://dx.doi.org/10.1016/j.cam.2025.116837 |
| Volume | 472 |
| WOSCitedRecordID | wos001517183300001&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D |
| hasFullText | 1 |
| inHoldings | 1 |
| isFullTextHit | |
| isPrint | |
| journalDatabaseRights | – providerCode: PRVESC databaseName: Elsevier SD Freedom Collection Journals 2021 issn: 0377-0427 databaseCode: AIEXJ dateStart: 20211211 customDbUrl: isFulltext: true dateEnd: 99991231 titleUrlDefault: https://www.sciencedirect.com omitProxy: false ssIdentifier: ssj0006914 providerName: Elsevier |
| link | http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtV3PS8MwFA46PehB_Im_6cGTGFmztEmOQxQVFWUTditJm8CGdrIN2Z_va5N0OjdwBy-hlDYN72uTL6_vfQ-hM06pVJpoTKQ0mGoRYpEpiY2sR0SmHL51WRabYE9PvNMRz65W-bAsJ8DynI_H4uNfoYZzAHaROrsA3FWncAKOAXRoAXZo_wR8S78ZDDth68XsOoXY_gADTS4wzSod8ZJ3-mjK1svDHKKaloUfvNOwFHd11PW90nytmHmr7yrAP8tPF43vfAqk9CnYrEqfS8UYLqpwfJ8nqa2x42a6MIy5lWv5NQlbf0APNthFqj-JLifX_hS8nlqIqvBAH3nWS6CLpOgisV0soxXCIsFraKV5d925r9bcWFgVdz9u__-6jOSbGsdsBvKNVbQ30YazctC0MG6hJZ1vo_XHiV13EJ8AehHMgDPwcAajfuDhDADOXfR6c92-usWu3gVOgWWOMA1TwRRtxEwIExnDw1BHDZryOKsrJbmigtdFyijRjCoDZFyFcRwpIozWIuONPVTL-7neR0GWMS0L3Z9IGkoFUaaRpUJqkykKq3P9AJ17GyQfVtYkmWv1A0S9lRLHyyzfSgDx-bcdLvKMI7Q2eRGPUQ1sqU_Qavo56g4Hpw7uL55nWDA |
| linkProvider | Elsevier |
| openUrl | ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=Self-paced%2C+instructor-assisted+approach+to+teaching+SQL&rft.jtitle=Journal+of+computational+and+applied+mathematics&rft.au=Solin%2C+Pavel&rft.date=2026-01-15&rft.issn=0377-0427&rft.volume=472&rft.spage=116837&rft_id=info:doi/10.1016%2Fj.cam.2025.116837&rft.externalDBID=n%2Fa&rft.externalDocID=10_1016_j_cam_2025_116837 |
| thumbnail_l | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=0377-0427&client=summon |
| thumbnail_m | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=0377-0427&client=summon |
| thumbnail_s | http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=0377-0427&client=summon |