Blended Learning for Improving Flexibility of Learning Structure Query Language (SQL)

  • Verayuth LertnatteeEmail author
  • Perayot Pamonsinlapatham
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 10309)


The Structural Query Language (SQL) is the popular language used for managing and retrieving data and information from relational databases. To support the decision making for healthcare professionals including pharmacists, learning SQL is one of an important topic in a database course. The objective of this research was to introduce blended learning for improving flexibility of learning SQL. The learning process was discussed and planned. Contents in this topic and examples of relational databases were designed and implemented. The SQLite was selected as a relational database management system due to its flexibility of using and managing. After a face-to-face class, students could practice their exercises with any of their computing devices, i.e., computers, tablets and smartphones. Moreover, these devices could operate with or without Internet connection. Students could practice and manage their exercises at any time and from anywhere. With evaluations from students, the results showed that the flexibility of the system enhanced their ability for learning SQL.


Blended learning Structure query language (SQL) SQLite Mobile device 



This work was supported by Instructional Innovation Development Project, Silpakorn University (2016).


  1. 1.
    Mailloux, A., Cummings, S., Mugdh, M.: A decision support tool for identifying abuse of controlled substances by forwardhealth medicaid members. J. Hosp. Mark. Public Relat. 20, 34–55 (2010)CrossRefGoogle Scholar
  2. 2.
    Graiser, M., Moore, S.G., Victor, R., Hilliard, A., Hill, L., Keehan, M.S., Flowers, C.R.: Development of query strategies to identify a histologic lymphoma subtype in a large linked database system. Cancer Inform. 4(3), 149–158 (2007)Google Scholar
  3. 3.
    Sujansky, W., Faus, S., Stone, E., Brennan, P.: A method to implement fine-grained access control for personal health records through standard relational database queries. J. Biomed. Inform. 43, S46–S50 (2010)CrossRefGoogle Scholar
  4. 4.
    Foster, E.C., Shripad, G.: Overview of SQL. In: Database Systems, pp. 205–209 (2016)Google Scholar
  5. 5.
    Kaur, M.: Blended learning - its challenges and future. Procedia – Soc. Behav. Sci. 93, 612–617 (2013)CrossRefGoogle Scholar
  6. 6.
    Allen, I.E., Seaman, J.: Changing Course: Ten Years of Tracking Online Education in the United States. Sloan Consortium, PO Box 1238, Newburyport, MA 01950 (2013)Google Scholar
  7. 7.
    Chew, E., Jones, N., Turner, D.: Critical review of the blended learning models based on maslow’s and vygotsky’s educational theory. In: Proceedings of the 1st International Conference on Hybrid Learning and Education, pp. 40–53 (2008)Google Scholar
  8. 8.
    Okaz, A.: Integrating blended learning in higher education. Procedia – Soc. Behav. Sci. 186, 600–603 (2015)CrossRefGoogle Scholar
  9. 9.
    Nizkodubov, G., Evseeva, A.: Planning and implementation of the process aimed at teaching english to adult learners. Mediterr. J. Soc. Sci. 6(2), 643 (2015)Google Scholar
  10. 10.
    Wang, F.L., Fong, J., Choy, M., Wong, T.L.: Blended teaching and learning of computer programming. In: Proceedings of the 6th International Conference on Advances in Web Based Learning, pp. 606–617 (2007)Google Scholar
  11. 11.
    Grønli, M., Hansen J., Ghinea, G., Younas, M.: Mobile application platform heterogeneity: Android vs Windows Phone vs IOS vs Firefox OS. In: IEEE 28th International Conference on Advanced Information Networking and Applications, pp. 635–641. IEEE Press (2014)Google Scholar
  12. 12.
    Owens, M.: The Definitive Guide to SQLite (Definitive Guide). Apress, Berkeley (2006)Google Scholar

Copyright information

© Springer International Publishing AG 2017

Authors and Affiliations

  1. 1.Faculty of PharmacySilpakorn UniversityNakhon PathomThailand

Personalised recommendations