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.

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

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

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

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

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

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

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

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

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