Create SQL Modules #

To create SQL questions you can follow these steps:

• On the “Library” menu, click “+ Create Module” button.

• There will be a pop-up for you to insert the module name and choose the “SQL Test” module type. Click Save to proceed.

1. Module General Info #

You’ll be redirected to the “Manage module” page > Tab “Module General Info”.

1. Module name(mandatory): you can edit the module name here.
2. Module format (mandatory): this never will be editable.
3. Total time (mandatory): maximum time spent on this specific module. This would be the default value every time you assign this module.
4. Complexity (mandatory): choose easy, medium, or complex.
5. Tags: input tagging to help other recruiters filter this specific module.
6. Description: put your internal notes for other recruiters here.
7. Translations (mandatory to choose one): Algobash now supports 2 languages (Bahasa Indonesia and English). This will affect the questions and answers settings. You can activate 1 or both languages.
8. Module introduction (mandatory): you can put a module introduction for this specific module. When the language is activated for both languages, you can use the dropdown to adjust the content for each language.
9. Click “Next” to go to the next tab or click “Cancel” to drop the changes.

2. Add Questions #

You’ll be redirected to the “Manage module” page > Tab “Add Questions”.

You’ll see an empty question list. To add your first question, do click “+Add Question”

1. Question name (mandatory): define your programming question here. Example: Palindrome, etc.
2. Question text language (mandatory): when you enable more than 1 language, you will need to add the content for question text description and answers in each language.
3. Question text description (mandatory): add your description for questions here.
4. User Configuration: Check if you want to separate testing and grading cases.

There will be some cases you’ll need to configure for the test case:

• Test Case Migration: by default, we already have tables that you can use.
• Test Case Result: you’ll need to input JSON for the expected result.
• Solution Query: put your query solution here for checking. This will not be visible to candidates.

You can always enable candidates to use DML commands.

Database Engine #

Algobash SQL modules are using MariaDB v10.3.

Once all of your mandatory fields are filled, you can add more questions or you can click “Finish” to save the module.

Edit SQL Modules #

To edit you can always follow the steps for adding modules above.