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

Saved in:
Bibliographic Details
Title: Bridging SQL Mastery and Career Confidence for Undergraduate Students Through Simulated Job Interviews
Authors: Zheng, Dailin, Chen, Yu, Albert, Leslie J.
Source: Faculty Research, Scholarly, and Creative Activity
Publisher Information: SJSU ScholarWorks
Publication Year: 2025
Collection: San José State University: SJSU ScholarWorks
Subject Terms: Experiential learning & education, Scenario-based design, Structured query language (SQL), Student learning success, Student preparedness, Information Systems and Technology
Description: 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).
Document Type: text
File Description: application/pdf
Language: unknown
Relation: https://scholarworks.sjsu.edu/faculty_rsca/6476; https://scholarworks.sjsu.edu/context/faculty_rsca/article/7476/viewcontent/Bridging_20SQL_20Mastery_20and_20Career_20Confidence_20for_20Undergraduate_20Students_20Through_20Simulated_20Job_20Interviews.pdf
DOI: 10.62273/YPKC5140
Availability: https://scholarworks.sjsu.edu/faculty_rsca/6476
https://doi.org/10.62273/YPKC5140
https://scholarworks.sjsu.edu/context/faculty_rsca/article/7476/viewcontent/Bridging_20SQL_20Mastery_20and_20Career_20Confidence_20for_20Undergraduate_20Students_20Through_20Simulated_20Job_20Interviews.pdf
Accession Number: edsbas.4D8468C3
Database: BASE
Description
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).
DOI:10.62273/YPKC5140