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.
- 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
- J. B. Biggs and K. F. Collis (1982) Evaluating the quality of learning. New York and Sydney: Academic Press, 1982.Google Scholar
- P. Brusilovsky. Adaptive and Intelligent Technologies for Web-based Education. Kunstliche Intelligenz, vol. vol. 4, pp. 19--25, 1999.Google Scholar
- 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. Google ScholarDigital Library
- 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
- D. Laurillard, Rethinking University Teaching. 2nd Edition. London: Routledge Falmer. Chapter 11 Setting up the Learning Context. Pp 199--213. 2002.Google Scholar
- P. Mann, "Computing and Virtual Reality Integrated Systems in the Interdisciplinary Design for the Built Environment," University of Cambridge, 2000.Google Scholar
- J. Melton, A. R. Simon. SQL: 1999 - Understanding Relational Language Components. Morgan Kaufmann Publishers 2002. Google ScholarDigital Library
Index Terms
- SQLator: an online SQL learning workbench
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