Skip to main content

Teaching SQL — Which Pedagogical Horse for This Course?

  • Conference paper
Key Technologies for Data Management (BNCOD 2004)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 3112))

Included in the following conference series:

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

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others

References

  1. Bergin, J.: Fourteen pedagogical patterns. Web Document (February 2004), http://csis.pace.edu/bergin/PedPat1.3.html

  2. Alexander, C.: A Pattern Language: towns, buildings, construction. Oxford University Press, Oxford (1977)

    Google Scholar 

  3. AntiPatterns: Portland pattern repository. Web Document (2004), http://c2.com/cgi/wiki

  4. 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

  5. Johnson-Laird, P.N., Byrne, R.M.J.: Precis of deduction. Behavioural and Brain sciences 16, 323–334 (1993)

    Article  Google Scholar 

  6. Byrne, R.: Mental models website. Web Document (2003), http://www.tcd.ie/Psychology/RuthByrne/mentalmodels/theory.html

  7. 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)

    Google Scholar 

  8. 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)

    Article  Google Scholar 

  9. Draper, S.: Constructivism and instructional design. Web Document (2004), http://www.psy.gla.ac.uk/steve/constr.html

  10. 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)

    Google Scholar 

  11. 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)

    Google Scholar 

  12. Gennick, J.: On the importance of mental model. Web Document (12/2/2004) (2004), http://gennick.com/mentalmodels.html

  13. Matos, V.M., Grasser, R.: A simpler (and better) SQL approach to relational division. Journal of Information Systems Education 13, 85–88 (2002)

    Google Scholar 

  14. 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)

    Google Scholar 

  15. 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)

    Google Scholar 

  16. 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)

    Google Scholar 

  17. Experts: Exchange. Microsoft Graph — What is datasheet view all about? Web Document (2004), http://www.experts-exchange.com/Databases/MSAccess/Q20822093.html

  18. Dringus, L.P., Terrell, S.: A framework for directed online learning environments. Internet and Higher Education 2, 55–67 (1999)

    Article  Google Scholar 

  19. Mayes, J.T., Fowler, C.J.: Learning technology and usability: a framework for understanding courseware. Interacting with Computers 11, 485–497 (1999)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints 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

Publish with us

Policies and ethics