1878 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.
- Introduction
A general overview of the motivation for the use of a database and a brief introduction to how databases work.
- SQL
An introduction to the Structured Query Language, or SQL for short, and how it can be used to interact with the MySQL database system.
- Indexes
Here, indexes are introduced and their usefulness examined.
- Joins
How do we effectively use data that is spread over more than one table? The answer is SQL Join, and it is introduced here.
- Views
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.
None.
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.
Latest Twitter post:
@buzzfeedpartner Hmm. Yes, indeed. http://t.co/T9BQONtM7P
Top Reddit Post:
[Offer] Basic blacksmithing
Latest WordPress Post:
Featured class: Microsoft Excel - Lessons & Training
Latest GitHub commit:
" added tracking of adding/dropping classes for Google Analytics "