Run of Site - Header Banner - IntelliBoard
Tags SQL

Tag: SQL

Entity relationship diagram (ERD) is released for the latest Moodle 3.0 by Marcus Green. The ERD for Moodle 3.0 is based on "reverse engineering" the code from a fresh install of Moodle 3.0 The diagram was generated by using the...
This view of Moodle SQL helps to show the relationship between Moodle modules and each module itself in great detail. Marcus Green has updated the diagram for 3.0 using MySQL Workbench, it's the latest in several versions of the...
Marcus Green has published an updated Relationship Diagram (ER) for Moodle 2.8 in the forums. This update includes additional relationships which were not previously included and has also included the field comments which are usually removed during the process. You...
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...
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...
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...
The Moodle Jobs board at Moodle.org gets numerous postings every week for full time, part time, remote, location based, contract and other types of work needed by someone in the Moodle community. If you're a contractor, between gigs, or...