ITx Rutherford 2019 Programme

Jump to: Wednesday 9th | Thursday 10th | Friday 11th

Using a mobile device?
Visit programme on mobile site

The ITx Rutherford 2019 Programme may change without notice

SQL and PL-SQL: Analysing teaching methods

Friday 12:20pm - 12:50pm, CITRENZ (Ara Room 3)

Knowledge on Database systems is essential in qualifications related to Information Technology, Information Systems, Computer Science, and Software Engineering.

It is an expectation from the industry that graduates with these qualifications are competent with working on database systems. For learners to be proficient in the concepts of database systems, a good understanding of SQL and PL-SQL is core. However, many learners perceive it to be difficult to grasp even the basic concepts, especially in a flipped classroom model.

In this paper we reflect on the challenges faced in teaching and learning SQL and PL-SQL and we present the factors that contribute to these learning difficulties. We review the literature of teaching methods that can be applied to overcome these perceptions and difficulties. The focus is to enable learners to gain the necessary knowledge and skill to create scripts in a professional manner. We aim to describe a teaching approach to improve student engagement and completion rates while providing a holistic learning experience.


Sunitha Prabhu


Sunitha Prabhu is a Senior Academic Staff member at the Centre for Information Technology, Waikato Institute of Technology (Wintec).

Sunitha has over 20 years of experience teaching Information Technology in New Zealand. She specialises in teaching Mathematics, Programming, Databases, and supervises IT projects and internships.