Better Living Through Queries
March 1, 2012 1:54 PM Subscribe
Help me help myself- Please recommend books or websites that will help me to better understand SQL.
posted by bluejayway to computers & internet (11 answers total) 33 users marked this as a favorite
I'm a learn-through-projects kind of person. My personal project of the week is playing around with the Lahman Baseball Database in MS Access. I'm a novice, but not a complete beginner. All of my simple queries are working out fine, but now that I'm beginning to write queries that calculate complex stats using multiple JOINs (is that bad?), I'm getting all kinds of screwy results.
I'd like to get a solid understanding of JOINS, nested JOINS, subqueries, etc. All of the examples I have found on the internet are either so simple that I don't think they'll scale or too complex and without good explanations.
Also, I am sticking with Access. It's what I have. I realize it's not great.
So, SQL guru's and DIY'ers, what are your recommendations?