Moodle Administrators are very much interested in running different SQL queries to extract various reports and information from the Moodle database. For a new Moodle administrator, it may be a daunting task at first but if you are aware of the tools which can be used for running SQL queries then it may become very easy and productive.
James MacNee, West College Scotland delivered a workshop for the Scottish Moodle Users Group (SMUG). The presentation provides a basic overview for all new Moodle administrator’s about running SQL queries on Moodle database. You can check out the presentation below:
Tools to run SQL queries:
The tools to run database queries as covered by James are as follows:
Apart from all the above, you can also run the database queries through the MySQL server but you should be fully conversant with writing the queries. And before proceeding make sure that you take a backup of your database before running any write queries to manipulate the database.
You would also be interested in this forum thread , and in this Moodle docs to know about various useful SQL queries.
What are the other ways for new Moodle administrators to learn about running database queries on Moodle Database? Share you experience with us in the comments section below.