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

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
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%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

60
Total Citations
View Citations
1,062
Total Downloads

Downloads (Last 12 months)40
Downloads (Last 6 weeks)5

Reflects downloads up to 09 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

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
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
Rivas PSchwartz DQuevedo E(2023)BERT Goes to SQL School: Improving Automatic Grading of SQL Statements2023 Congress in Computer Science, Computer Engineering, & Applied Computing (CSCE)10.1109/CSCE60160.2023.00019(83-90)Online publication date: 24-Jul-2023
https://doi.org/10.1109/CSCE60160.2023.00019
Shin S(2022)Effect of semantic distance on learning structured query language: An empirical studyFrontiers in Psychology10.3389/fpsyg.2022.99636313Online publication date: 9-Nov-2022
https://doi.org/10.3389/fpsyg.2022.996363
Fekete ARöhm U(2022)Teaching about Data and DatabasesACM SIGMOD Record10.1145/3552490.355250451:2(52-60)Online publication date: 29-Jul-2022
https://dl.acm.org/doi/10.1145/3552490.3552504
Nayak SAgarwal RKhatri S(2022)Review of Automated Assessment Tools for grading student SQL queries2022 International Conference on Computer Communication and Informatics (ICCCI)10.1109/ICCCI54379.2022.9740799(1-4)Online publication date: 25-Jan-2022
https://doi.org/10.1109/ICCCI54379.2022.9740799
Show More Cited By

View Options

Get Access

Login options

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

Cited By

Index Terms

Recommendations

SQLator: an online SQL learning workbench

An Online Learning Community Integrated with Web-Enhanced Collaborative Learning and Self-Regulated Learning

The effects of web-based learning experience, perceived-initiative, and perceived-performance on learners' attitudes toward mobile learning