4 Ways To Get Data From The Moodle Database

4 Ways To Get Data From The Moodle Database (Good Luck Getting This Granular From Another LMS)

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.

Post Pages - Post Inline - WIRIS

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.

Previous articleWhy your Online Courses are the perfect beast for Data Driven Marketing with John Ainsworth on the Elearning Podcast With Stephen Ladek
Next articleThe 10 Best Udemy Courses for Self-Improvement


Please enter your comment!
Please enter your name here

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