Understanding Students' Identification and Use of Patterns while Writing SQL Queries

Zahra Hatami, Peter Wolcott

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

SQL (Structured Query Language) is a standard language to communicate with a relational database system. SQL is a core competency for people in the data management field and is, therefore, a foundational skill taught to users in information systems. This research analyzes data from the group of students with two different problem sets. The data set consisted of student activity, log data, captured by the database management system as students executed queries. The primary goal of analyzing data in this research is to observe the exact sequence of attempts while students formulate SQL queries, understand the patterns students use and how these patterns help them learn SQL for the purpose of finding better ways to teach these skills. This research will try to improve students? learning processes and how they can be taught more efficiently about the SQL language and its usage.

Original languageEnglish (US)
Title of host publicationSIGITE 2020 - Proceedings of the 21st Annual Conference on Information Technology Education
PublisherAssociation for Computing Machinery, Inc
Pages20-25
Number of pages6
ISBN (Electronic)9781450370455
DOIs
StatePublished - Oct 7 2020
Event21st Annual Conference of the Special Interest Group in Information Technology Education, SIGITE 2020 - Virtual, Online, United States
Duration: Oct 7 2020Oct 9 2020

Publication series

NameSIGITE 2020 - Proceedings of the 21st Annual Conference on Information Technology Education

Conference

Conference21st Annual Conference of the Special Interest Group in Information Technology Education, SIGITE 2020
CountryUnited States
CityVirtual, Online
Period10/7/2010/9/20

Keywords

  • knowledge
  • log data
  • pattern
  • sql

ASJC Scopus subject areas

  • Computational Theory and Mathematics
  • Artificial Intelligence
  • Computer Science Applications
  • Software

Fingerprint Dive into the research topics of 'Understanding Students' Identification and Use of Patterns while Writing SQL Queries'. Together they form a unique fingerprint.

Cite this