Can anyone recommend a good reference or tutorial that explains the principles of spatial references, projections, and coordinate systems?

We are a small team of programmers working with GIS technology, and we often get snagged when working with data in different SRS/CS because we don't understand the concepts.