Robert Sheldon is writing a series of articles on the building blocks of writing code that works in MySQL. These are the items that have been published so far:

1. Getting started with MySQL
2. Working with MySQL tables
3. Working with MySQL views
4. Working with MySQL stored procedures
5. Working with MySQL stored functions
6. Introducing the MySQL SELECT statement
7. Introducing the MySQL INSERT statement
8. Introducing the MySQL UPDATE statement
9. Introducing the MySQL DELETE statement
10. Subqueries in MySQL
11. Introducing the MySQL Common Table Expression
12. Retrieving MySQL data from within Python
13. Modifying MySQL data from within Python
14. Importing data into a MySQL database using LOAD DATA
15. Working with MySQL transactions
16. Exporting data from a MySQL database using SELECT…INTO OUTFILE
17. Working with MySQL constraints
18. MySQL joins