![](https://www.moodlebites.com/pluginfile.php/3270/course/overviewfiles/mbsql1.jpg)
This course starts with a foundation level introduction to Apache, MySQL and PHP in the context of Moodle.
- Facilitator: Jeff Mitchell
![](https://www.moodlebites.com/pluginfile.php/3549/course/overviewfiles/mbsql2.jpg)
This course introduces Terminals and the CLI (command line interface) and explores how the Moodle database is structured.
- Facilitator: Jeff Mitchell
![](https://www.moodlebites.com/pluginfile.php/3559/course/overviewfiles/mbsql3.jpg)
This course covers all the basics of creating, deleting, viewing and manipulating MySQL databases and tables.
- Facilitator: Jeff Mitchell
![](https://www.moodlebites.com/pluginfile.php/3564/course/overviewfiles/mbsql4.jpg)
This week we look at the power of SELECT queries and clauses to retrieve MySQL data.
- Facilitator: Jeff Mitchell
![](https://www.moodlebites.com/pluginfile.php/3554/course/overviewfiles/mbsql5.jpg)
This week features some more advanced work around SQL queries and reports specifically using a real Moodle database.
- Facilitator: Jeff Mitchell
![](https://www.moodlebites.com/pluginfile.php/4375/course/overviewfiles/mbsql6.jpg)
This course explores some of the more powerful MySQL reporting and essential Moodle plugins that should be in your toolkit.
- Facilitator: Jeff Mitchell
![](https://www.moodlebites.com/pluginfile.php/4903/course/overviewfiles/mbsql7.jpg)
This course looks at the MySQL Workbench application, and investigates how it can be used by Moodle administrators.
- Facilitator: Jeff Mitchell
![](https://www.moodlebites.com/pluginfile.php/4934/course/overviewfiles/mbsql8.jpg)
This course is a 'Catchall area for essential Moodle and SQL topics that don't get covered in the earlier topics.
- Facilitator: Jeff Mitchell
![](https://www.moodlebites.com/pluginfile.php/17912/course/overviewfiles/mb4d_cert.jpg)
This area is used by successful MoodleBites SQL Reporting participants to access a Certificate of Completion, and download a Badge.