IntelliBoard - Your Data. Right Here. Right Now
Tags Mysql

Tag: mysql

We have earlier covered the Useful SQL queries in the past and now few more queries are added to the Ad-hoc contributed reports page by Elizabeth Dalton to provide learning analytics at the iMoot 2015. The newly added reports includes: Weekly...
In this week multiple jobs are posted in the Moodle Jobs database, here are few of them which caught my attention: Moodle reports developer(freelance) - Bodhi Health Education,- looking for moodle developer to develop custom course level reports for student...
If you setup SQL access through PHPmyAdmin or through a program like MySQL Workbench you can directly query your site's database to extract lots more information than you'll find available through the admin interface, logs or just as a...
Moodle adminer which is based on the popular database management tool "Adminer" is updated to a new version which is compatible for Moodle 2.8 & 2.9 versions and is based on the Adminer version - 4.2.1. Moodle adminer is a...
In a recent post on Moodle.org forums, Marcus Green posted the Entity Relationship diagram for the LTS version of Moodle i.e. 2.7. The Entity Relationship diagram is a graphical representation of entities and their relationships to each other, within databases....
If you are a Moodle site administrator, then probably this is the best collection of SQL queries which can be utilized to make custom reports on your Moodle site. https://docs.moodle.org/28/en/ad-hoc_contributed_reports https://docs.moodle.org/22/en/Custom_SQL_queries_report https://moodle.org/mod/forum/discuss.php?d=153059 Few of the useful SQl queries are: Student (user) COUNT in each...
Frederic Nevers, who did a multi-part series on Gamification in Moodle (his 1st person experience) has done another great multi-part series on his thoughts and experience on Optimizing a Moodle Server. While the posts are chalked with disclaimers, the...
Here's a super simple block that allows you a quick reference for your Moodle, PHP and mySQL versions.  The block was designed to help admins and develops quickly see the versions of the foundations of a running site. Check...
Are you a Moodle Administrator with knowledge of the OS of your Moodle server and what database you're using?  Help Moodle HQ out by answering this survey here: http://moodle.org/mod/forum/discuss.php?d=193926