Bridging SQL Mastery and Career Confidence for Undergraduate Students Through Simulated Job Interviews

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 SQ...

Full description

Saved in:
Bibliographic Details
Published in:Journal of information systems education Vol. 36; no. 4; pp. 331 - 341
Main Authors: Zheng, Dailin, Chen, Yu, Albert, Leslie J
Format: Journal Article
Language:English
Published: West Lafayette EDSIG 01.10.2025
Subjects:
Business communication
Business students
Candidates
Careers
College students
Concepts
Confidence
Customer relationship management
Data analysis
Data models
Database Design
Database Management Systems
Deep learning
Design
Education
Employers
Employment interviews
Experiential learning
Feedback
Intention
Interviews
Knowledge
Language
Language disorders
Learner Engagement
Learning
Learning activities
Learning Modules
Learning Motivation
Occupational Surveys
Occupations
Polls & surveys
Problem solving
Professionals
Programming Languages
Query languages
Relational data bases
Responses
Skills
Structured Query Language-SQL
Student Participation
Student Surveys
Students
Teaching
Technical Occupations
Time
Undergraduate students
Undergraduate study
Video Technology
World problems
ISSN:1055-3096, 2574-3872
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary: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 realworld 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).
Bibliography:ObjectType-Article-1
SourceType-Scholarly Journals-1
ObjectType-Feature-2
content type line 14
ISSN:1055-3096
2574-3872
DOI:10.62273/YPKC5140