Relational database theory and best practices.
I've read subjects on normalization, using lookup tables, pk/fk ideas.. etc.. But some of it's not easily understandable, or the reasons are not clear. For instance, Barand's tutorial about Data Joins was good, I realized I should use them, and how they can be applied.. but I didn't quite grasp why the tables were separated as such.
Also, on the same topic, better ways of getting a result from joined tables to display in HTML output through php loops. How to properly join the tables is the main part; the outputting of the data, I can't think of a complicated example at this moment.