Data, Data, Data! Get

4 Ways To Get Data From The Moodle Database (Good Luck Getting This Granular From Another LMS)
AI in Education Leaderboard Post Page
Ai In Education Square Post Page

--- Advertisement ---

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:

The presentation is from 2016, but the methods remain sound and the plugins up-to-date with the latest

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.

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

The Latest

The eLearn Podcast

--- Advertisement ---

Subscribe to our newsletter

Education technology has the power to change lives. 

To get the latest news, information and resources about online learning from around the world by clicking on the button below.