Abstract
A student with a Computing Science degree is expected to have reached a reasonable level of expertise in writing SQL. SQL is a non-trivial skill to master and is taught with different degrees of success at different institutions. When teaching any skill we have to take both previous learning and experience into consideration as well as the best possible way of teaching the skill.
When learning a new skill humans form mental models of particular problems and formulate internal patterns for solving these problems. When they encounter the same problem later they apply these previously internalised patterns to solve the problem. This reality has to be taken into account when selecting a teaching approach because changing an existing mental model is difficult and much more difficult than encoding the correct model in the first place.
This paper considers two different pedagogical approaches to teaching SQL and compares and contrasts these in terms of mental models and cognition. We conclude by making recommendations about the tools that should be used in teaching SQL if the afore-mentioned mental models are to be constructed to support a coherent and correct understanding of SQL semantics and not merely the syntax thereof.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Bergin, J.: Fourteen pedagogical patterns. Web Document (February 2004), http://csis.pace.edu/bergin/PedPat1.3.html
Alexander, C.: A Pattern Language: towns, buildings, construction. Oxford University Press, Oxford (1977)
AntiPatterns: Portland pattern repository. Web Document (2004), http://c2.com/cgi/wiki
Johnson-Laird, P.N., Girottoa, V., Legrenzi, P.: Mental models: a gentle guide for outsiders. Web document (2003), http://www.si.umich.edu/ICOS/gentleintro.htm
Johnson-Laird, P.N., Byrne, R.M.J.: Precis of deduction. Behavioural and Brain sciences 16, 323–334 (1993)
Byrne, R.: Mental models website. Web Document (2003), http://www.tcd.ie/Psychology/RuthByrne/mentalmodels/theory.html
Halland, K., Malan, K.: Reflections by teachers learning to program. In: Eloff, J., Kotze, P., Engelbrecht, A., Eloff, M. (eds.) SAICSIT 2003, IT Research in Developing Countries (2003)
Kettanurak, V., Ramamurthy, K., Haseman, W.D.: User attitude as a mediator of learning performance improvement in an interactive multimedia environment: an empirical investigation of the degree of interactivity and learning styles. International Journal Human-Computer Studies 54, 541–583 (2001)
Draper, S.: Constructivism and instructional design. Web Document (2004), http://www.psy.gla.ac.uk/steve/constr.html
Kananoja, T.: Teacher training in technological education in finland. In: Proc. Conference on Pupil’s Attitudes towards Technology, Linköping, pp. 10.5–14.5 (1996)
Kearns, R., Shead, S., Fekete, A.: A teaching system for SQL. In: Proceedings of the second Australasian conference on Computer Science education, Melbourne, Australia, pp. 224– 231 (1997)
Gennick, J.: On the importance of mental model. Web Document (12/2/2004) (2004), http://gennick.com/mentalmodels.html
Matos, V.M., Grasser, R.: A simpler (and better) SQL approach to relational division. Journal of Information Systems Education 13, 85–88 (2002)
Halland, K., Malan, K.: Bad examples for teaching programming. In: Proceedings of the 33 rd annual conference of the South African Computer Lecturers’ Association (2003)
Hyyppä, K., Tamminen, S., Hautala, I., Repokari, L.: The effect of mental models guiding user’s action in mobile phone answering situations. In: Proceedings from Design vs. Design, 1st Nordic Conference on Human-Computer Interaction, Nordichi 2000, Stockholm, Sweden (2000)
van Biljon, J.A., Renaud, K.V.: Investigating the difference between interaction approaches in advisory support systems for curriculum planning. In: Rauterberg, M., Menozzi, M., Wesson, J. (eds.) Proceedings Interact 2003 (2003)
Experts: Exchange. Microsoft Graph — What is datasheet view all about? Web Document (2004), http://www.experts-exchange.com/Databases/MSAccess/Q20822093.html
Dringus, L.P., Terrell, S.: A framework for directed online learning environments. Internet and Higher Education 2, 55–67 (1999)
Mayes, J.T., Fowler, C.J.: Learning technology and usability: a framework for understanding courseware. Interacting with Computers 11, 485–497 (1999)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Renaud, K., van Biljon, J. (2004). Teaching SQL — Which Pedagogical Horse for This Course?. In: Williams, H., MacKinnon, L. (eds) Key Technologies for Data Management. BNCOD 2004. Lecture Notes in Computer Science, vol 3112. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-27811-5_22
Download citation
DOI: https://doi.org/10.1007/978-3-540-27811-5_22
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-22382-5
Online ISBN: 978-3-540-27811-5
eBook Packages: Springer Book Archive