Journal Article

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

Albert, Leslie J, Chen, Yu, Zheng, Dailin

2025

Overview

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

• Publisher: EDSIG
• Subject: 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