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

Celý popis

Uloženo v:
Podrobná bibliografie
Vydáno v:Journal of information systems education Ročník 36; číslo 4; s. 331 - 341
Hlavní autoři: Zheng, Dailin, Chen, Yu, Albert, Leslie J
Médium: Journal Article
Jazyk:angličtina
Vydáno: West Lafayette EDSIG 01.10.2025
Témata:
ISSN:1055-3096, 2574-3872
On-line přístup:Získat plný text
Tagy: Přidat tag
Žádné tagy, Buďte první, kdo vytvoří štítek k tomuto záznamu!
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 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).
AbstractList 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).
Author Albert, Leslie J
Chen, Yu
Zheng, Dailin
Author_xml – sequence: 1
  givenname: Dailin
  surname: Zheng
  fullname: Zheng, Dailin
– sequence: 2
  givenname: Yu
  surname: Chen
  fullname: Chen, Yu
– sequence: 3
  givenname: Leslie
  surname: Albert
  middlename: J
  fullname: Albert, Leslie J
BookMark eNotjTtPwzAYAC1UJNrCwD-wxBxw4mdGiHgUggC1HZgqx_6cpip2sRMQ_55IMN1w0t0MTXzwgNB5Ti5FUUh69f76VPGckSM0LbhkGVWymKBpTjjPKCnFCZqltCMk56UQU-RuYmfbzrd4-VbjZ516iD9Ye4srHQEiroJ3nQVvALsQ8dpbiG3UdtA94GU_jKpPeLWNYWi3eNl9DPvRWPwYGrzwY-2rg-90io6d3ic4--ccre9uV9VDVr_cL6rrOjvkhPSZKbVrqChNI51RjdJMWyGl4gCMF1pxLYQ0lGvCFQjDnDPOEgDlgOZKGDpHF3_dQwyfA6R-swtD9ONyQwtZMEYkYfQX4KZazQ
ContentType Journal Article
Copyright Copyright EDSIG 2025
Copyright_xml – notice: Copyright EDSIG 2025
DBID 0-V
3V.
4T-
4U-
7WY
7WZ
7XB
87Z
88B
8AL
8AO
8FE
8FG
8FK
8FL
8G5
ABUWG
AFKRA
AHOVV
ALSLI
ARAPS
AZQEC
BENPR
BEZIV
BGLVJ
CCPQU
CJNVE
CNYFK
DWQXO
FRNLG
F~G
GNUQQ
GUQSH
HCIFZ
JQ2
K60
K6~
K7-
L.-
M0C
M0N
M0P
M1O
M2O
MBDVC
P5Z
P62
PHGZM
PHGZT
PKEHL
PQBIZ
PQBZA
PQEDU
PQEST
PQGLB
PQQKQ
PQUKI
PRINS
PRQQA
Q9U
S0X
DOI 10.62273/YPKC5140
DatabaseName ProQuest Social Sciences Premium Collection
ProQuest Central (Corporate)
Docstoc
University Readers
ABI/INFORM Collection
ABI/INFORM Global (PDF only)
ProQuest Central (purchase pre-March 2016)
ABI/INFORM Collection
Education Database (Alumni Edition)
Computing Database (Alumni Edition)
ProQuest Pharma Collection
ProQuest SciTech Collection
ProQuest Technology Collection
ProQuest Central (Alumni) (purchase pre-March 2016)
ABI/INFORM Collection (Alumni Edition)
ProQuest Research Library
ProQuest Central (Alumni)
ProQuest Central UK/Ireland
Education Research Index
Social Science Premium Collection
Advanced Technologies & Computer Science Collection
ProQuest Central Essentials
ProQuest Central
Business Premium Collection
Technology Collection
ProQuest One Community College
Education Collection
Library & Information Science Collection
ProQuest Central
Business Premium Collection (Alumni)
ABI/INFORM Global (Corporate)
ProQuest Central Student
Research Library Prep
SciTech Premium Collection
ProQuest Computer Science Collection
ProQuest Business Collection (Alumni Edition)
ProQuest Business Collection
Computer Science Database
ABI/INFORM Professional Advanced
ABI/INFORM Global (OCUL)
Computing Database
Education Database
Library Science Database
ProQuest Research Library
Research Library (Corporate)
Advanced Technologies & Aerospace Database
ProQuest Advanced Technologies & Aerospace Collection
ProQuest Central Premium
ProQuest One Academic
ProQuest One Academic Middle East (New)
ProQuest One Business
ProQuest One Business (Alumni)
One Education
ProQuest One Academic Eastern Edition (DO NOT USE)
ProQuest One Applied & Life Sciences
ProQuest One Academic (retired)
ProQuest One Academic UKI Edition
ProQuest Central China
One Social Sciences
ProQuest Central Basic
SIRS Editorial
DatabaseTitle ProQuest One Education
ProQuest Business Collection (Alumni Edition)
Research Library Prep
Computer Science Database
ProQuest Central Student
ProQuest Advanced Technologies & Aerospace Collection
ProQuest Central Essentials
ProQuest Computer Science Collection
SciTech Premium Collection
ProQuest Central China
ABI/INFORM Complete
ProQuest One Applied & Life Sciences
Library & Information Science Collection
ProQuest Central (New)
Advanced Technologies & Aerospace Collection
Business Premium Collection
Social Science Premium Collection
ABI/INFORM Global
Education Collection
ProQuest One Academic Eastern Edition
ProQuest Technology Collection
ProQuest Business Collection
ProQuest Social Sciences Premium Collection
ProQuest One Academic UKI Edition
Docstoc
ProQuest One Academic
ProQuest One Academic (New)
ABI/INFORM Global (Corporate)
ProQuest One Business
University Readers
Technology Collection
ProQuest One Academic Middle East (New)
SIRS Editorial
ProQuest Central (Alumni Edition)
ProQuest One Community College
Research Library (Alumni Edition)
ProQuest Pharma Collection
ProQuest Central
ABI/INFORM Professional Advanced
ProQuest Library Science
ProQuest Central Korea
ProQuest Research Library
ABI/INFORM Complete (Alumni Edition)
ProQuest Computing
ProQuest One Social Sciences
ABI/INFORM Global (Alumni Edition)
ProQuest Central Basic
ProQuest Education Journals
ProQuest Computing (Alumni Edition)
ProQuest SciTech Collection
Advanced Technologies & Aerospace Database
ProQuest One Business (Alumni)
ProQuest Education Journals (Alumni Edition)
ProQuest Central (Alumni)
Business Premium Collection (Alumni)
DatabaseTitleList ProQuest One Education
Database_xml – sequence: 1
  dbid: BENPR
  name: ProQuest Central
  url: https://www.proquest.com/central
  sourceTypes: Aggregation Database
DeliveryMethod fulltext_linktorsrc
Discipline Education
Computer Science
EISSN 2574-3872
EndPage 341
GroupedDBID -W8
.4I
.GO
0-V
29K
3V.
4T-
4U-
5GY
77I
7WY
7XB
8AL
8AO
8FE
8FG
8FK
8FL
8FW
8G5
8R4
8R5
8VB
96U
AAHSB
AAKPC
ABDBF
ABUWG
ACGFO
ACIHN
AEAQA
AFAZI
AFFHD
AFKRA
AHOVV
AHQJS
AKVCP
ALMA_UNASSIGNED_HOLDINGS
ALSLI
ARALO
ARAPS
AZQEC
BAIFH
BBTPI
BENPR
BEZIV
BGLVJ
BPHCQ
CCPQU
CJNVE
CNYFK
D-I
DWQXO
E3Z
EAP
EBO
EBU
EDJ
ELW
ESX
FRNLG
GNUQQ
GUQSH
HCIFZ
IAO
ICD
IEA
IER
INH
INR
ITC
JQ2
K1G
K60
K6V
K6~
K7-
L.-
M0C
M0N
M0P
M1O
M2O
MBDVC
N95
OK1
P2P
P62
PHGZM
PHGZT
PKEHL
PQBIZ
PQBZA
PQEDU
PQEST
PQGLB
PQQKQ
PQUKI
PRG
PRINS
PROAC
PRQQA
PV9
Q2X
Q9U
QF4
QM7
QN7
QWB
RWL
RXW
RZL
S0X
TAE
TAF
TH9
U5U
UNMZH
XH6
ZL0
~8M
ID FETCH-LOGICAL-p100t-c9afb369cb7fc8b8a4ad67785ee452a85a667c35a058e6c4ffcfd0ee8fe3186c3
IEDL.DBID 7WY
ISSN 1055-3096
IngestDate Tue Nov 18 00:11:58 EST 2025
IsPeerReviewed true
IsScholarly true
Issue 4
Language English
LinkModel DirectLink
MergedId FETCHMERGED-LOGICAL-p100t-c9afb369cb7fc8b8a4ad67785ee452a85a667c35a058e6c4ffcfd0ee8fe3186c3
Notes ObjectType-Article-1
SourceType-Scholarly Journals-1
ObjectType-Feature-2
content type line 14
PQID 3272440704
PQPubID 25848
PageCount 11
ParticipantIDs proquest_journals_3272440704
PublicationCentury 2000
PublicationDate 20251001
PublicationDateYYYYMMDD 2025-10-01
PublicationDate_xml – month: 10
  year: 2025
  text: 20251001
  day: 01
PublicationDecade 2020
PublicationPlace West Lafayette
PublicationPlace_xml – name: West Lafayette
PublicationTitle Journal of information systems education
PublicationYear 2025
Publisher EDSIG
Publisher_xml – name: EDSIG
SSID ssj0015966
Score 2.318582
Snippet Employers increasingly prioritize candidates who can solve real-world Structured Query Language (SQL) problems, particularly during technical interviews....
SourceID proquest
SourceType Aggregation Database
StartPage 331
SubjectTerms 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
Title Bridging SQL Mastery and Career Confidence for Undergraduate Students Through Simulated Job Interviews
URI https://www.proquest.com/docview/3272440704
Volume 36
hasFullText 1
inHoldings 1
isFullTextHit
isPrint
journalDatabaseRights – providerCode: PRVPQU
  databaseName: ABI/INFORM Global
  customDbUrl:
  eissn: 2574-3872
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0015966
  issn: 1055-3096
  databaseCode: M0C
  dateStart: 20020101
  isFulltext: true
  titleUrlDefault: https://search.proquest.com/abiglobal
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: Advanced Technologies & Aerospace Database
  customDbUrl:
  eissn: 2574-3872
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0015966
  issn: 1055-3096
  databaseCode: P5Z
  dateStart: 20020101
  isFulltext: true
  titleUrlDefault: https://search.proquest.com/hightechjournals
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: Computer Science Database
  customDbUrl:
  eissn: 2574-3872
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0015966
  issn: 1055-3096
  databaseCode: K7-
  dateStart: 20020101
  isFulltext: true
  titleUrlDefault: http://search.proquest.com/compscijour
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: Education Database
  customDbUrl:
  eissn: 2574-3872
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0015966
  issn: 1055-3096
  databaseCode: M0P
  dateStart: 20020101
  isFulltext: true
  titleUrlDefault: https://search.proquest.com/education
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: Library Science Database
  customDbUrl:
  eissn: 2574-3872
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0015966
  issn: 1055-3096
  databaseCode: M1O
  dateStart: 20020101
  isFulltext: true
  titleUrlDefault: https://search.proquest.com/libraryscience
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: ProQuest ABI/INFORM Collection
  customDbUrl:
  eissn: 2574-3872
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0015966
  issn: 1055-3096
  databaseCode: 7WY
  dateStart: 20020101
  isFulltext: true
  titleUrlDefault: https://www.proquest.com/abicomplete
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: ProQuest Central
  customDbUrl:
  eissn: 2574-3872
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0015966
  issn: 1055-3096
  databaseCode: BENPR
  dateStart: 20020101
  isFulltext: true
  titleUrlDefault: https://www.proquest.com/central
  providerName: ProQuest
– providerCode: PRVPQU
  databaseName: ProQuest Research Library
  customDbUrl:
  eissn: 2574-3872
  dateEnd: 99991231
  omitProxy: false
  ssIdentifier: ssj0015966
  issn: 1055-3096
  databaseCode: M2O
  dateStart: 20020101
  isFulltext: true
  titleUrlDefault: https://search.proquest.com/pqrl
  providerName: ProQuest
link http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwpZ3PT8IwFMcbBQ9eRFHjDyQ9eG3otnY_TkYIxIjgFIzghXRtZzgIyMDE_96-bujBxIuXlyzLkqV77Xt77ft-ELrUjqY04ZI4glMC6igkUowTkK4yHiAjxpSFTQT9fjgaRXFRcMuKY5WbNdEu1GouoUbe8NzARCLjoOxq8U6AGgW7qwVCYxuVTaDmQDAInsffuwg8snuVwIAknsnVc2Uh3zUhuzGOuy2TLNBfa7ANLJ3Kf19pH-0VKSW-zn3gAG3pWRVVNrgGXMzeKgCai8MchyhtQqOWCVt48HCHewLkEj6xmCkMDUnmKegEzHmj2KS12OKRXpdCrU1uige5IGaGhznlBw-mb4AB0wrfzhNsq4xW5PQIPXXaw9YNKZALZOFQuiIyEmni-ZFMglSGSSiYUCAxx7Vm3BUhF74fSI8LykPtS5amMlVU6zCFWqovvWNUms1n-gThIOLKSVwaSmV-Is1X95Mk5FwqypzAS9kpqm1GdVLMm2zyM6Rnf98-R7sukHjtsboaKq2Wa32BduTHapot69YN6qjcbPfjR3PVDYixPdqyNgbr3IN1wcb85Qt9PsQq
linkProvider ProQuest
linkToHtml http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMw1V25TsQwEB1xSdBwI25cQGnhJHaOAiFOAXsA2kWCanFsB23BLuwB2p_iG_E4CRRIdBTUUSIl8zKn5z2AXeMZxlKhqCcFo8iOQhPNBUXqKosAlXCundhEVK_H9_fJzRh8lLsweKyy9InOUeuuwh75fuBHNhJZgPLDl1eKqlE4XS0lNHJYVMzo3ZZs_YPLU2vfPd8_P2ueXNBCVYC-eIwNqEpklgZhotIoU3EaSy41sqgJY7jwZSxkGEYqEJKJ2ISKZ5nKNDMmzrBdGKrAPnccJpFXD_-omnf9NbUQiZuNouYkDWxtkDMZhb5NEfYfbionNjlhP3y-C2Tnc__tE8zDbJEyk6Mc4wswZjqLMFfKUZDCOy2iAHVxWGUJsmNcRLNhmTRuq6QmkQ5iRGRHE1y4snfhpmOup0ps2k6c_NNTT-qhzb1JIyf87JNmrmJEGu1nlDkzmlx1U-K6qI7EdRnu_uTNV2Ci0-2YVSBRIrSX-ixW2hbJFtVhmsZCKM24FwUZX4PN0oqtwi_0W98mXP_98g5MXzRr1Vb1sl7ZgBkfVYfdEcJNmBj0hmYLptTboN3vbTsIEnj8a4N_AsUcHVQ
linkToPdf http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMw1V25TsNAEB1BQIiGcIqbLaBcZW3v-igQ4oqAQBQISFCF9R6IggRygPg1vo5ZH1Ag0VFQW7a0nqe5duY9gG3jGcZSoagnBaOOHYUmmgvqqKsQASrhXGdiE1GzGd_eJq0x-Ch3YdxYZekTM0ete8r1yGuBH2EkQoDymi3GIlpH9b3nF-oUpNxNaymnkUOkYd7fsHwb7J4eoa13fL9-fH14QguFAfrsMTakKpE2DcJEpZFVcRpLLrVjVBPGcOHLWMgwjFQgJBOxCRW3VlnNjImtax2GKsDvjsNEFGDRU4GJg-Nm6-rrDkMk2U2pU6CkAVYKOa9R6GPCULtrNQ4xVWE_IkAW1urV__xDZmGmSKbJfo7-ORgz3XmolkIVpPBb806auhhjWQB74FbUMGCT9uU5uZCOKOKdyK4mbhUL33I7kLnSKsGEnmTCUA99qUeYlZN2TgU6INe5vhFpPz45ATSjyVkvJVl_NaN3XYSbPzn5ElS6va5ZBhIlQnupz2KlsXxGvIdpGguhNONeFFi-AuulRTuFxxh0vs25-vvjLZhCO3fOT5uNNZj2nRxxNlu4DpVhf2Q2YFK9Dh8H_c0CjwTu_9rin9NpJ3M
openUrl ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=Bridging+SQL+Mastery+and+Career+Confidence+for+Undergraduate+Students+Through+Simulated+Job+Interviews&rft.jtitle=Journal+of+information+systems+education&rft.au=Zheng%2C+Dailin&rft.au=Chen%2C+Yu&rft.au=Albert%2C+Leslie+J&rft.date=2025-10-01&rft.pub=EDSIG&rft.issn=1055-3096&rft.eissn=2574-3872&rft.volume=36&rft.issue=4&rft.spage=331&rft.epage=341&rft_id=info:doi/10.62273%2FYPKC5140&rft.externalDBID=HAS_PDF_LINK
thumbnail_l http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=1055-3096&client=summon
thumbnail_m http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=1055-3096&client=summon
thumbnail_s http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=1055-3096&client=summon