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 către Andrzej Wójtowicz-
Număr de răspunsuri: 1
Ca răspuns la Andrzej Wójtowicz
Re: Templates for Microsoft SQL Server, PostgreSQL and MySQL
de către Richard Lobb-
Many thanks for the interesting contribution, Andrzej.