• May 14, 2019 News!IJIET Vol. 7, No. 9-Vol. 8, No. 8 have been indexed by EI (Inspec).   [Click]
  • Apr 15, 2019 News![Call for Papers] Special Issue on Education, Research and Innovation   [Click]
  • Jul 26, 2019 News!Vol. 9, No. 9 issue has been published online!   [Click]
General Information
    • ISSN: 2010-3689 (Online)
    • Abbreviated Title: Int. J. Inf. Educ. Technol.
    • Frequency: Monthly
    • DOI: 10.18178/IJIET
    • Editor-in-Chief: Prof. Dr. Steve Thatcher
    • Executive Editor: Ms. Nancy Y. Liu
    • Abstracting/ Indexing: Scopus (Since 2019), EI(INSPEC, IET), EBSCO, Electronic Journals Library, Google Scholar, Crossref, etc.
    • E-mail: ijiet@ejournal.net
Editor-in-chief
Prof. Dr. Steve Thatcher
CQUniversity, Australia
It is my honor to be the editor-in-chief of IJIET. The journal publishes good-quality papers which focous on the advanced researches in the field of information and education technology. Hopefully, IJIET will become a recognized journal among the scholars in the related fields.

IJIET 2019 Vol.9(4): 241-249 ISSN: 2010-3689
doi: 10.18178/ijiet.2019.9.4.1207

Learning Database through Developing Database Web Applications

Ching-Yu Huang
Abstract—Databases play a very important role in the modern software system, especially in the big data age. It is the centralized repository for all kinds of data. Therefore, all students majoring in technology and computer science related fields should take database courses. However, learning about databases could be challenging without hands-on exercises. It is very important for students to be familiar with database commands and the associated clauses so they can write better database queries. Since the data resides in the database, it is hard for students to imagine the results, especially if there are a lot of records. Visualizing the intermediate results will help students to learn how to write better queries and troubleshoot. It is not practical to just use the command line to interact with the database server. Students must learn the industry standard 3-tier method to retrieve, insert, update and delete thousands of data from databases, and how to write web programs to do so. Designing an E-commerce platform should be the core of fundamental database curriculum - including a friendly graphic user interface for customers to sign up for accounts, search items, place orders and view histories. The instructors should not focus on teaching the database topics, but also show students how to manage the database server and user accounts in the classes. This paper proposes an integrated curriculum for learning about databases through developing database web applications.

Index Terms—Apache, database web applications, PHP, MySQL, XAMPP.

Ching-Yu Huang is with School of Computer Science, Kean University, Union, New Jersey, USA (e-mail: chuang@kean.edu).

[PDF]

Cite: Ching-Yu Huang, "Learning Database through Developing Database Web Applications," International Journal of Information and Education Technology vol. 9, no. 4, pp. 241-249, 2019.

Copyright © 2008-2019. International Journal of Information and Education Technology. All rights reserved.
E-mail: ijiet@ejournal.net