3 ms·
Ask HN: Best way to learn SQL?
I need recommendations on the best introduction to SQL.
About 10 years ago, "Access Database Design & Programming" http://www.amazon.com/dp/0596002734 was my introduction to relational algebra, and "The Guru's Guide to Transact-SQL" http://www.amazon.com/dp/0201615762 filled in the details on queries required for each day's new minor emergency.
Today I'm looking for the best online CBT options (teamtreehouse or whatever), online courses, better books, and/or any other options I might not even have considered ([online] user groups/communities, tutorials included with database servers, etc.?)
I was promised "an upcoming blog post specially focusing on learning SQL" back when Zipfian Academry rounded up their "Practical Intro to Data Science" a month ago https://news.ycombinator.com/item?id=5508261 , but I'm out of time to wait. (If anyone has additional recommendations specifically for learning more about business intelligence and/or data warehousing I'd greatly appreciate those too!)
Thanks for your time, and keep up the good work!
- tjr 14y agoOld but good: http://philip.greenspun.com/sql/ http://philip.greenspun.com/sql/ Supplement with a good resource specific to the RDBMS you are using.
- j_s 14y agoNice to know this is still worth digging into... I'd forgotten about it.
- macarthy12 14y agoJoe Celkos books http://www.amazon.com/Joe-Celko/e/B000ARBFVQ http://www.amazon.com/Joe-Celko/e/B000ARBFVQ
- j_s 14y agoThanks! Is there a specific one that has been the most helpful to you?
- codegeek 14y agoI am writing an ebook (leanpub) for beginner-intermediate SQL and if you are interested, check it out: https://leanpub.com/sqlfromscratch https://leanpub.com/sqlfromscratch
- j_s 14y agoI look forward to checking it out! Hopefully I'll already have the bases covered by the time you release; I certainly will try to get you some usable feedback.
- codegeek 14y agodefinitely. Would love any feedback. To be honest, I am writing this because I get a lot of queries like yourself in my field of work and I decided to give something back to the community. I am expecting to have this ready in next 30 days.
- j_s 14y agoRecommendation number one: if you're wrapping it up in less than a month, don't leave your sales page saying you are 1% done!
- makeitsonumber1 14y agoI swear by O'Reilly's SQL Cookbook (http://www.amazon.com/Cookbook-Cookbooks-OReilly-Anthony-Molinaro/dp/0596009763 http://www.amazon.com/Cookbook-Cookbooks-OReilly-Anthony-Mol...). The examples start of easy and get more complicated as you go along, all with detailed explanations. The book is a bit out of date but it's still useful. IMHO, it will turn you from a novice to an intermediate in no time.
- duggieawesome 14y agoFor something interactive, checkout http://sqlzoo.net/ http://sqlzoo.net/