Publication Date

1-1-2025

Document Type

Article

Publication Title

Journal of Information Systems Education

Volume

36

Issue

4

DOI

10.62273/YPKC5140

First Page

331

Last Page

341

Abstract

Employers increasingly prioritize candidates who can solve real-world Structured Query Language (SQL) problems, particularly during technical interviews. However, many undergraduate students feel underprepared for these interviews because they have not engaged in the deep learning needed to apply SQL concepts confidently. Additionally, students often fail to recognize the career relevance of SQL skills. This Teaching Tip introduces an immersive SQL lesson designed to bridge the gap between conceptual learning and practical application. The lesson includes a mock SQL technical interview, where students apply their knowledge to solve real-world business problems, class discussions on SQL-related careers, and a post-interview debrief to foster reflection and feedback. Results from pre- and post-lesson surveys indicate significant benefits, including enhanced student confidence in their SQL knowledge, student intention to continue learning and using SQL in the future, and student confidence in their ability to perform well in real SQL interviews. Open-ended survey responses support these findings and further reveal that the SQL lesson positively impacts students by clarifying concepts, reinforcing learned skills, and demonstrating the applicability of SQL in real-world scenarios. This approach demonstrates a practical and scalable framework for integrating immersive professional experiences into technical coursework that may be adapted to different class types (e.g., adopting an abridged version) and different courses (e.g., data analysis).

Funding Sponsor

YouTube

Keywords

Experiential learning & education, Scenario-based design, Structured query language (SQL), Student learning success, Student preparedness

Comments

Copyright ©2025 by the Information Systems & Computing Academic Professionals, Inc. (ISCAP). Permission to make digital or hard copies of all or part of this journal for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial use. All copies must bear this notice and full citation. Permission from the Editor is required to post to servers, redistribute to lists, or utilize in a for-profit or commercial use. Permission requests should be sent to the Editorin-Chief, Journal of Information Systems Education, editor@jise.org.

Department

Information Systems and Technology

Download

Share

COinS