Journal of Information Systems Education (JISE)

Volume 33

Volume 33, Issue 3, Pages 209-228

Summer 2022

Teaching Tip
Using SQL to Create and Mine Large, Customizable Datasets

Reagan Siggard
Utah State University
Logan, UT 84322, USA

Pamela A. Dupin-Bryant
Utah State University
Tooele, UT 84074, USA

Robert J. Mills
Utah State University
Logan, UT 84322, USA

David H. Olsen
Dixie State University
St. George, UT 84770, USA

Abstract: The SQL-Explore Learning Module detailed in this teaching tip provides an opportunity for students to apply database course knowledge beyond solving traditional pre-determined Structured Query Language (SQL) coding questions. In this unique constructivist activity using the apropos 5E Instructional Model, students explore tables to locate data anomalies, trends, and other key findings in a 100,000-invoice dataset. Detailed instructions and the source code needed to facilitate this innovative learning experience are included. Based on student feedback, 100% of study participants strongly agree or somewhat agree that exploring datasets through the SQL-Explore Activity enhances their knowledge of SQL.

Keywords: Structured query language (SQL), Constructivist learning, 5E instructional model, Data exploration, Data anomalies

Download This Article: JISE2022v33n3pp209-228.pdf

Recommended Citation: Siggard, R., Dupin-Bryant, P. A., Mills, R. J., & Olsen, D. H. (2022). Teaching Tip: Using SQL to Create and Mine Large, Customizable Datasets. Journal of Information Systems Education, 33(3), 209-228.