This is a mini-course on MySQL that will only last a couple weeks. There will be a sandbox MySQL database to play with on the UReddit server here - username is "sandbox" and password is "password".
Update: this class is now over. Additional topics may be added at a later date by request.
A general overview of the motivation for the use of a database and a brief introduction to how databases work.
An introduction to the Structured Query Language, or SQL for short, and how it can be used to interact with the MySQL database system.
Here, indexes are introduced and their usefulness examined.
How do we effectively use data that is spread over more than one table? The answer is SQL Join, and it is introduced here.
Given a complex set of relationships between tables and/or a large number of fields, is there any way to avoid often writing very complex queries? SQL Views can be helpful; here are the basics of how they work.
I will be periodically uploading a PDF onto the UReddit server here. Topics covered so far, with links to the respective PDFs:
This website runs on MySQL and I wrote it.