We’re excited to announce the new database questions on assignments! We hear you and understand the value and demand for better tools for database courses, which is why we have improved support for this type of question in assignments to the following relational databases:
Microsoft SQL Server
After you get started on the Database Question, Mimir Classroom guides you through a similar setup to code questions and test cases with four newly added test case types specifically for database questions: Query Results Tests, Keywords Tests, SQL Post Hook Query Tests, and Python Post Hook Script Tests.
Here are some tips and tricks to get you excited:
You can create datasets once and reuse them throughout the assignment
Query results are displayed as tables
You can utilize a wide range of database features by accessing the database connection object in custom database test cases
You can find more documentation on Database Code Questions in our Help Docs.