MoodleBites SQL Reporting enables Moodle administrators to understand how the SQL database works in terms of Moodle, and enables participants to confidently query and report on data using SQL commands. For details regarding fees, start date, and other course information please see the full course outline.

MBSQL1 Introduction to Apache, PHP and MySQL

This course starts with a foundation level introduction to Apache, MySQL and PHP in the context of Moodle.

MBSQL2 Terminals and the Moodle database

This course introduces Terminals and the CLI (command line interface) and explores how the Moodle database is structured.

MBSQL3 Building a basic MySQL database

This course covers all the basics of creating, deleting, viewing and manipulating MySQL databases and tables.

MBSQL4 Exploring SELECT queries and clauses

This week we look at the power of SELECT queries and clauses to retrieve MySQL data.

MBSQL5 Advanced SQL queries and the Moodle database

This week features some more advanced work around SQL queries and reports specifically using a real Moodle database.

MBSQL6 Reporting and essential Moodle plugins

This course explores some of the more powerful MySQL reporting and essential Moodle plugins that should be in your toolkit.

MBSQL7 Get to know MySQL workbench

This course looks at the MySQL Workbench application, and investigates how it can be used by Moodle administrators.

MBSQL8 Catchall area (for everything else)

This course is a 'Catchall area for essential Moodle and SQL topics that don't get covered in the earlier topics.

MBSQLCert MoodleBites SQL Reporting in Moodle

This area is used by successful MoodleBites SQL Reporting participants to access a Certificate of Completion, and download a Badge.