Hi,
I would like to share the SQL templates for the Microsoft SQL Server, PostgreSQL, and MySQL database servers. We use them for classes like "Introduction to Databases", and with them, you can check not only the queries returned but also, at a basic level of analysis of the grammar of a given SQL dialect, what query techniques were used by the student.
Question templates, installation instructions, and sample questions are available in the GitHub repository. In addition, I encourage you to read our paper recently presented at the SIGCSE TS 2025 conference.
I hope you will find it helpful for your classes.
Templates for Microsoft SQL Server, PostgreSQL and MySQL
de Andrzej Wójtowicz -
Número de respuestas: 2
En respuesta a Andrzej Wójtowicz
Re: Templates for Microsoft SQL Server, PostgreSQL and MySQL
de Richard Lobb -
Many thanks for the interesting contribution, Andrzej.
En respuesta a Andrzej Wójtowicz
Re: Templates for Microsoft SQL Server, PostgreSQL and MySQL
de Andrzej Wójtowicz -
Following up on my previous post - I'd like to share a new set of CodeRunner question templates, now extended with support for DCL statements (e.g., GRANT and REVOKE) for Microsoft SQL Server, PostgreSQL, and MySQL. This makes it possible to automatically assess student exercises on database access control. Question templates, installation instructions, and sample questions are available in the GitHub repository. For more details on the approach, see the paper from DataEd workshop. If you teach database administration topics, you might find it handy.