This report describes the purpose, design, development and analysis of SQLTips, an online instructional delivery framework and set of instructional modules relating to advanced features and performance tuning of Oracle's Structured Query Language (SQL). SQLTips was developed using Wiki, server-side software that allows users to edit web pages with almost any browser. The report includes a literature review of existing SQL instructional materials and a review of instructional theory. The report also includes a description of the formative evaluation process and results. These results show that SQLTips is easy and enjoyable to use. Based on a scale of 1 to 7 with 7 being the most positive, the 10 modules comprising SQLTips averaged a 6.1 for ease of use and a 6.2 for enjoyability. Posttest results also showed an average increase of 46% upon completion of the instruction. The report also contains a critique of the project.
College and Department
David O. McKay School of Education; Instructional Psychology and Technology
BYU ScholarsArchive Citation
Rackliffe, Vincent Brian, "Advanced Structured Query Language Instruction for Engineers of the Office of Information Technology at Brigham Young University" (2005). Theses and Dissertations. 720.
structured query language, oracle, instruction, wiki, SQL