Article

SQLator: an online SQL learning workbench

Authors:

Shazia Sadiq,

Maria Orlowska,

Wasim Sadiq,

Joe LinAuthors Info & Claims

ITiCSE '04: Proceedings of the 9th annual SIGCSE conference on Innovation and technology in computer science education

Pages 223 - 227

https://doi.org/10.1145/1007996.1008055

Published: 28 June 2004 Publication History

Get Access

Abstract

SQL (Structured Query Language) is one of the essential topics in foundation databases courses in higher education. Due to its apparent simple syntax, learning to use the full power of SQL can be a very difficult activity. In this paper, we introduce SQLator, which is a web-based interactive tool for learning SQL. SQLator's key function is the evaluate function, which allows a user to evaluate the correctness of his/her query formulation. The evaluate engine is based on complex heuristic algorithms. The tool also provides instructors the facility to create and populate database schemas with an associated pool of SQL queries. Currently it hosts two databases with a query pool of 300+ across the two databases. The pool is divided into 3 categories according to query complexity. The SQLator user can perform unlimited executions and evaluations on query formulations and/or view the solutions. The SQLator evaluate function has a high rate of success in evaluating the user's statement as correct (or incorrect) corresponding to the question. We will present in this paper, the basic architecture and functions of SQLator. We will further discuss the value of SQLator as an educational technology and report on educational outcomes based on studies conducted at the School of Information Technology and Electrical Engineering, The University of Queensland.

References

[1]

J. Biggs. Teaching for quality learning. 2nd Edition Buckingham:SRHE & Open University. Chapter 10 Using educational technology: ET not IT. Pp 213--228. 2003.

Google Scholar

[2]

J. B. Biggs and K. F. Collis (1982) Evaluating the quality of learning. New York and Sydney: Academic Press, 1982.

Google Scholar

[3]

P. Brusilovsky. Adaptive and Intelligent Technologies for Web-based Education. Kunstliche Intelligenz, vol. vol. 4, pp. 19--25, 1999.

Google Scholar

[4]

Stefano Ceri <http://www.informatik.uni-trier.de/ ley/db/indices/a-tree/c/Ceri:Stefano.html>, Georg Gottlob <http://www.informatik.uni-trier.de/ ley/db/indices/a-tree/g/Gottlob:Georg.html>. Translating SQL Into Relational Algebra: Optimization, Semantics, and Equivalence of SQL Queries. TSE 11(4) <http://www.informatik.uni-trier.de/ ley/db/journals/tse/tse11.html>: 324--345. 1985.

Digital Library

Google Scholar

[5]

David Kember, Lyn Gow (1994) Orientations to Teaching and Their Effect on the Quality of Student Learning. The Journal of Higher Education. Volume 65, Issue 1. Jan-Feb 1994.

Google Scholar

[6]

D. Laurillard, Rethinking University Teaching. 2nd Edition. London: Routledge Falmer. Chapter 11 Setting up the Learning Context. Pp 199--213. 2002.

Google Scholar

[7]

P. Mann, "Computing and Virtual Reality Integrated Systems in the Interdisciplinary Design for the Built Environment," University of Cambridge, 2000.

Google Scholar

[8]

J. Melton, A. R. Simon. SQL: 1999 - Understanding Relational Language Components. Morgan Kaufmann Publishers 2002.

Digital Library

Google Scholar

Cited By

View all

Farinetti LCagliero LStone JYuen TShoop LRebelsky SPrather J(2025)A Critical Approach to ChatGPT: An Experience in SQL LearningProceedings of the 56th ACM Technical Symposium on Computer Science Education V. 110.1145/3641554.3701932(318-324)Online publication date: 12-Feb-2025
https://dl.acm.org/doi/10.1145/3641554.3701932
Bhowmick SLi HStone JYuen TShoop LRebelsky SPrather J(2025)Experience Report on Using LANTERN in Teaching Relational Query ProcessingProceedings of the 56th ACM Technical Symposium on Computer Science Education V. 110.1145/3641554.3701812(123-129)Online publication date: 12-Feb-2025
https://dl.acm.org/doi/10.1145/3641554.3701812
Babić TFabijanić MĐambić G(2024)Features, Importance, and Advantages of Knowledge Assessment at Database-Related Courses via AcpSQL SystemAcademic Performance - Students, Teachers and Institutions on the Stage10.5772/intechopen.113243Online publication date: 18-Sep-2024
https://doi.org/10.5772/intechopen.113243
Show More Cited By

Index Terms

SQLator: an online SQL learning workbench
1. Human-centered computing
  1. Collaborative and social computing
    1. Collaborative and social computing systems and tools
2. Information systems
  1. World Wide Web

Recommendations

SQLator: an online SQL learning workbench

SQL (Structured Query Language) is one of the essential topics in foundation databases courses in higher education. Due to its apparent simple syntax, learning to use the full power of SQL can be a very difficult activity. In this paper, we introduce ...
An Online Learning Community Integrated with Web-Enhanced Collaborative Learning and Self-Regulated Learning

This paper investigates two aspects of the growing trend towards collaborative learning CL and self-regulated learning SRL in higher education by examining students' computing skills in a blended learning environment. The author redesigned a course and ...
The effects of web-based learning experience, perceived-initiative, and perceived-performance on learners' attitudes toward mobile learning

This study explored the effects of prior web-based learning experience, perceived-initiative, and perceived-performance on learners' attitudes toward a mobile learning system designed to enhance novices' reflective thinking and problem-solving through ...

Comments

Information & Contributors

Information

Published In

ITiCSE '04: Proceedings of the 9th annual SIGCSE conference on Innovation and technology in computer science education

June 2004

296 pages

ISBN:1581138369

DOI:10.1145/1007996

Conference Chair:
Roger Boyle
University of Leeds, UK
,
Program Chairs:
Martyn Clark
University of Leeds, UK
,
Amruth Kumar
Ramapo College of NJ

ACM SIGCSE Bulletin Volume 36, Issue 3
September 2004
280 pages
ISSN:0097-8418
DOI:10.1145/1026487
Issue’s Table of Contents

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 28 June 2004

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Article

Conference

ITiCSE04

Sponsor:

ITiCSE04: Innovation and Technology in Computer Science Education

June 28 - 30, 2004

Leeds, United Kingdom

Acceptance Rates

Overall Acceptance Rate 552 of 1,613 submissions, 34%

Upcoming Conference

ITiCSE '25

Sponsor:
sigcse

Innovation and Technology in Computer Science Education

June 27 - July 2, 2025

Nijmegen , Netherlands

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

65
Total Citations
View Citations
1,074
Total Downloads

Downloads (Last 12 months)42
Downloads (Last 6 weeks)6

Reflects downloads up to 05 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Farinetti LCagliero LStone JYuen TShoop LRebelsky SPrather J(2025)A Critical Approach to ChatGPT: An Experience in SQL LearningProceedings of the 56th ACM Technical Symposium on Computer Science Education V. 110.1145/3641554.3701932(318-324)Online publication date: 12-Feb-2025
https://dl.acm.org/doi/10.1145/3641554.3701932
Bhowmick SLi HStone JYuen TShoop LRebelsky SPrather J(2025)Experience Report on Using LANTERN in Teaching Relational Query ProcessingProceedings of the 56th ACM Technical Symposium on Computer Science Education V. 110.1145/3641554.3701812(123-129)Online publication date: 12-Feb-2025
https://dl.acm.org/doi/10.1145/3641554.3701812
Babić TFabijanić MĐambić G(2024)Features, Importance, and Advantages of Knowledge Assessment at Database-Related Courses via AcpSQL SystemAcademic Performance - Students, Teachers and Institutions on the Stage10.5772/intechopen.113243Online publication date: 18-Sep-2024
https://doi.org/10.5772/intechopen.113243
Kleiner CHeine FMonga MLonati VBarendsen ESheard JPaterson J(2024)Enhancing Feedback Generation for Autograded SQL Statements to Improve Student LearningProceedings of the 2024 on Innovation and Technology in Computer Science Education V. 110.1145/3649217.3653579(248-254)Online publication date: 3-Jul-2024
https://dl.acm.org/doi/10.1145/3649217.3653579
Wu ZEricson B(2024)SQL Puzzles: Evaluating Micro Parsons Problems With Different Feedbacks as Practice for NovicesProceedings of the 2024 CHI Conference on Human Factors in Computing Systems10.1145/3613904.3641910(1-15)Online publication date: 11-May-2024
https://dl.acm.org/doi/10.1145/3613904.3641910
Abdelhamid SEnfield JAnnapoorna VAddike AMallari T(2024)WIP: Beyond the Classroom - Mystery Games as a Portal to SQL Proficiency2024 IEEE Frontiers in Education Conference (FIE)10.1109/FIE61694.2024.10893145(1-5)Online publication date: 13-Oct-2024
https://doi.org/10.1109/FIE61694.2024.10893145
Akshaya KKaur S(2024)Alert Generation Tool for Messaging SystemsDevelopment of 6G Networks and Technology10.1002/9781394230686.ch18(395-422)Online publication date: 15-Nov-2024
https://doi.org/10.1002/9781394230686.ch18
Cagliero LCanale LFarinetti L(2023)Data-Driven Analysis of Student Engagement in Time-Limited Computer LaboratoriesAlgorithms10.3390/a1610046416:10(464)Online publication date: 2-Oct-2023
https://doi.org/10.3390/a16100464
Wu WDoyle MStephenson BDorn BSoh LBattestilli L(2023)Assessing Peer Correction of SQL and NoSQL QueriesProceedings of the 54th ACM Technical Symposium on Computer Science Education V. 110.1145/3545945.3569884(535-541)Online publication date: 2-Mar-2023
https://dl.acm.org/doi/10.1145/3545945.3569884
Lai P(2023)Reimagining Online Coding Assessment Throughout the Pandemic: The Role of Auto-Grading and Enquiry Features2023 IEEE International Conference on Teaching, Assessment and Learning for Engineering (TALE)10.1109/TALE56641.2023.10398329(1-6)Online publication date: 28-Nov-2023
https://doi.org/10.1109/TALE56641.2023.10398329
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Abstract

References

Cited By

Index Terms

Recommendations