Time for action – install and experiment with the Custom SQL query tool
Installation of the Custom SQL query tool is a straightforward process that resembles the process for installing blocks, modules, and other plugins. To install the tool follow these steps:
From the Moodle.org, Modules and Plugins page, search for Custom SQL queries.
Click on the Custom SQL queries name link found in the search results and then on the Download for 1.9 link found at the bottom-right corner of the explanation window.
Unzip the
customsql.zip
package and place the resultingcustomsql
directory in the admin reports directory found in your Moodle directory at/yourmoodledirectory/admin/reports
.Click on the Notifications link found in the Site Administration block to finish the installation process. You will see a screen that confirms that the customsql plugin has been set up correctly, as shown in the following screenshot:
Click on the Continue button to finish the installation and then navigate to the front page...