Best resources for learning SQL for database newbies
August 20, 2014 9:06 AM Subscribe
I am making a transition from an Excel-based reporting analyst to a database-oriented role in which SQL will be the primary necessary skill. I have next to zero database experience. I'm looking for resources that would be effective at teaching me what I need to learn. More within…
posted by JimBJ9 to Technology (15 answers total) 49 users marked this as a favorite
I'm a reasonably-close to expert-level Excel user with a lot of experience programming in VBA. I've never gotten into high-level math functions of Excel like regression analysis, forecasting, or any calculus-related things, but I pretty much know the ins and outs of the rest. That's my skill set. Other than a little playing around with basic HTML and VERY basic SQL tinkering, I've no other programming experience. I thought that being pretty capable with VBA might making picking up SQL a cinch, but I think my lack of background/familiarity with database theory is making things kind of difficult to conceptualize.
I'm ultimately expected to make my way into the data warehousing world, so SQL is something that I need to develop expert proficiency in. I've seen a lot of options (sql.learncodethehardway.org, sqlcourse.com, New Horizons, etc.), but I'm asking for help identifying which are good for my situation and which might be a waste of time.
Free online stuff would be great, but if there’s a really well-regarded paid course that would be helpful, I might swing it by my bosses and see if my company would spring for it.