Templates for Microsoft SQL Server, PostgreSQL and MySQL

Templates for Microsoft SQL Server, PostgreSQL and MySQL

by Andrzej Wójtowicz -
Number of replies: 1

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.

In reply to Andrzej Wójtowicz

Re: Templates for Microsoft SQL Server, PostgreSQL and MySQL

by Richard Lobb -
Many thanks for the interesting contribution, Andrzej.