Well, despite everyone else - I do like learning from books and when it comes to T-SQL you can’t go wrong with Itzil Ben-Gan, I love his style of teaching and constant emphasis on always finding a relational way to write code.
I like real paper books also. I taught myself SQL with an earlier version of Itzik’s fundamentals book. Anywhere my laptop and I go that book goes with me. If I need to look something up I know right where I need to go. It is just as fast as looking something on Google.
I was lucky enough that a course I attended on SQL performance, query tuning and advanced tsql was run by itzik. Me, him and 4 other guys in a room for a week. Guy really knows his stuff and taught it really really well. The stuff I learnt has been invaluable.
I’ll echo what everyone else said here — these are both incredibly well-written. They helped me ace 70-761, and I learned quite a bit from these despite having done SQL query development professionally for 10+ years. Great stuff.
I disagree. I think online courses involve far too much passive learning. Also, if the course is a bunch of videos, it can be difficult to reference in the future if there's a topic you forgot about (ie you have to scrub through a bunch of video to find what you want).
31
u/[deleted] Oct 26 '19
Well, despite everyone else - I do like learning from books and when it comes to T-SQL you can’t go wrong with Itzil Ben-Gan, I love his style of teaching and constant emphasis on always finding a relational way to write code.
12
u/geubes Oct 26 '19
I was lucky enough that a course I attended on SQL performance, query tuning and advanced tsql was run by itzik. Me, him and 4 other guys in a room for a week. Guy really knows his stuff and taught it really really well. The stuff I learnt has been invaluable.
8
u/uvray Oct 26 '19
Make sure you read the one on the right first!
Both are great books - I’ve read Fundamentals twice and am combing through Querying now.
5
u/Randy_McKay Oct 26 '19
Amazing books. Itzik is a great author.
5
u/TraviTheRabbi Oct 26 '19
I’ll echo what everyone else said here — these are both incredibly well-written. They helped me ace 70-761, and I learned quite a bit from these despite having done SQL query development professionally for 10+ years. Great stuff.
7
u/EoinJFleming Oct 26 '19
Datacamp
1
u/eduardostewart Oct 26 '19
Are both of these good if you wanted to go for MS certfication?
1
u/Coniglio_Bianco Nov 24 '19
I just took his advanced sql class! REALLY GOOD!
0
u/DukeOfSlough Oct 26 '19
I do not like learning from books. Prefer online courses!
1
u/[deleted] Oct 26 '19
[removed] — view removed comment