What is an SQL Test? An SQL test assesses participants' skills in working with structured query language (SQL), which is used to manage and manipulate data in databases.

Step by step on how to create an SQL module #

You can opt to create an “SQL”, which will lead you to the following page:

This module has already been automatically generated but has not been completed yet! Every component here is crucial, so please review each element meticulously.

1. Module name _^IMPORTANT
   Initially, we will populate it with the title “Untitled Module” by default.
2. Module detail bar
   You can configure specific details for this particular module.
   • Module duration _^IMPORTANT
     You can select the maximum duration within which participants are allowed to work on this assessment. The range varies from 5 minutes to a maximum of 1 hour.
   • Module language
     You have the option to choose English, Bahasa Indonesia, or both languages. Simply click on the desired language(s) until they turn blue.
   • Description
     Provide a description to inform other users about the content and purpose of this module.
   • Instruction
     Change the instructions to guide participants on what to expect and any specific preparations they need to make before starting the test. Rest assured, we have already provided default content by default. Therefore, there’s no need to worry about making changes.
   • Difficulty level
     You can choose from options such as ‘No Difficulty,’ ‘Easy,’ ‘Medium,’ and ‘Complex’ to indicate the level of difficulty for this module.”
   • Category _^IMPORTANT
     Tagging under the appropriate category that best suits this test.
   • Suitable Position _^IMPORTANT
     Tagging under the appropriate job category that best suits this test.

1. Question description _^IMPORTANT
   Enter the question description in this space. You are welcome to include images or files to enhance the content.
2. SQL Configuration _^IMPORTANT
   • Allow mutation: Allow user to use INSERT, UPDATE & DELETE Commands.
   • Use grading case: Add separate Migration & Result which will be tested during submission
3. Test Case _^IMPORTANT
   In order to specify the anticipated result of a test case, you will have to provide JSON data that defines the expected outcome. Our system comes with pre-existing tables available for your use as a default option. You are welcome to modify the table as per your requirements
4. Solution _^IMPORTANT
   Lastly, you can implement the solution and proceed to test it to verify the accuracy of your test case data.
5. To complete the process, click ‘Save’ to submit your final changes. If you’d like to see a preview of the module, click on ‘Preview’.

FAQ On SQL Module #

Can I add multiple questions to this module type? #

No, Algobash 2.0 does not support multiple questions within this module type. Each module is designed to focus on a single question.

What occurs if I activate multiple languages? #

If you activate more than one language, participants will be able to view and interact with the assessment in their preferred language. However, it’s important to note that you’ll need to input translations for question descriptions and options in each of the activated languages to ensure a seamless experience for participants.

Can I preview the module before finalizing it? #

Yes, you can preview the module by clicking the “Preview” button. This enables you to review how the module will appear to participants before saving the changes.

What if I want to make changes after creating the module? #

You can always edit and modify the module by accessing it from your module list:

Click the ‘Details’ button and click the “Edit” button.

Can I reuse the same module for different assessments? #

Yes, you can reuse the same module for different assessments within your organization. This feature streamlines the creation process and ensures consistency.

Can I tailor the test to specific roles or industries? #

Absolutely, you can customize the programming test to align with the specific skills and tasks relevant to roles within your organization.

Alternatively, we can create a custom module tailored to your specific requirements.

Which database engine is utilized in Algobash? #

Algobash’s SQL modules operate on MariaDB v10.3.