Publication: Promoting students' understanding of SQL in a database management course: A learning cycle approach
Issued Date
2011-05-16
Resource Type
ISSN
14479540
14479494
14479494
Other identifier(s)
2-s2.0-79955792557
Rights
Mahidol University
Rights Holder(s)
SCOPUS
Bibliographic Citation
International Journal of Learning. Vol.17, No.11 (2011), 325-338
Suggested Citation
Hongsiri Piyayodilokchai, Pintip Ruenwongsa, Watcharee Ketpichainarong, Parames Laosinchai, Patcharin Panjaburee Promoting students' understanding of SQL in a database management course: A learning cycle approach. International Journal of Learning. Vol.17, No.11 (2011), 325-338. Retrieved from: https://repository.li.mahidol.ac.th/handle/20.500.14594/12885
Research Projects
Organizational Units
Authors
Journal Issue
Thesis
Title
Promoting students' understanding of SQL in a database management course: A learning cycle approach
Other Contributor(s)
Abstract
SQL (Structured Query Language) is an important topic that can help students understand database management concepts because this language can be applied to solve problems, manipulate data, and extract meaningful information. One often finds teaching and learning of SQL difficult because of the abstraction of conditions, hard-to-understand queries and ill-defined errors. In traditional classes, the teachers describe each command, followed by an example from a textbook, while students remain passive. In this study, an SQL learning unit based on the learning cycle approach was developed to promote undergraduate students' understanding. For each command, the students started by exploring a statement and were asked to predict and verify its outcome using Microsoft Office Access. Next, the command syntax was explained and the errors were discussed. Finally, the students performed their own task in couple or individually. Results from this study revealed that the proposed learning unit based on the learning cycle approach could help students to improve their understanding of SQL in a Database Management course. This research study provided a useful guideline for further the development of the learning unit. © Common Ground, Hongsiri Piyayodilokchai, Pintip Ruenwongsa, Watcharee Ketpichainarong, Parames Laosinchai, Patcharin Panjaburee.