Spatial reference for dummies?
Personally, for the cliff's notes I find the ESRI ArcGIS desktop software help system useful, and and also the ESRI book Understanding Map Projections, its first 30 pages are not unlike a short textbook, followed by ~70 pages of appendix on individual projections, their uses, strengths, weaknesses, etc.
From these, you'll quickly understand all the pieces of a complete SR - spheroid + datum + meridian + unit of measure => GCS; and projection + parameters + unit of measure + GCS => PCS.
For all the math, try the classic USGS Professional Paper 1395 by John P. Synder - Map Projections - A Working Manual. You might find a PDF somewhere if you google it.
Finally, take a look at the 'documentation' links at the bottom of the page for the Proj.4 library.
And as a DB of spatial references, I tend to refer to http://www.spatialreference.org/ or another ESRI list provided as part of the docs for their ArcGIS Server REST API.
Hope that helps.
Answering a question about the difference between a projection and a datum, Bill Huber links to his article in the Directions Magazine where he gives introductory explanations of georeferencing, datums, spheroids, and the like.
As short and concise as it can be!
I think Carlos Furuti's tutorial is a really good resource.
http://www.progonos.com/furuti/MapProj/CartIndex/cartIndex.html