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

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.