SQL Pattern Design and Development
Huda Al-Shuaily, Karen Renaud · 2014
This paper presents the processes involved in the design and development of a set of Structure Query Language (SQL) patterns. The intention is to support novices during SQL acquisition. This process is grounded in the SQL learning model developed from learning theory literature and empirical investigations into SQL acquisition. One of the crucial crosscutting factors identified during the development of this model was the quality of the instructional material provided to learners to support the acquisition process. Since patterns have been successfully deployed in other areas to support knowledge transfer, we set out to develop SQL patterns to meet this need for effective instructional material. We detail the process by which we identified the required components of SQL patterns. Our patterns were also informed based on observations of how novices and experts solved SQL queries. We conclude by presenting our proposed SQL pattern content and structure. Keywords-Pattern; SQL; Expert