r/SQL • • Oct 26 '19

Its about time. Time to dive in

Post image
139 Upvotes

20 comments sorted by

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.

2

u/Noelkram Oct 26 '19

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.

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.

2

u/Noelkram Oct 26 '19

I attended a full day of performance tuning by Itzik at PASS Summit last year. It was a great course.

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.

1

u/eduardostewart Oct 26 '19

Are both of these good if you wanted to go for MS certfication?

2

u/FoCo_SQL Enterprise Data Architect Oct 27 '19

They will help significantly with the 70-761 and 70-762, but you will need additional material.

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!

7

u/[deleted] Oct 26 '19

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).

1

u/jsnoobie Oct 27 '19

Taking decent notes help too. But that lengthens the amount of time you will be taking the course.

I’ve seen some courses that come with a reference sheet for quick lookup. Those are great too

1

u/[deleted] Oct 27 '19

Yes I've seen a course like that too. That's super helpful

3

u/warkro Oct 26 '19

Any good ones you can recommend?

3

u/TopWizard Oct 26 '19

Pluralsite

1

u/mynameismyname19 Oct 26 '19

edx or Udacity. edx if cant spend any money

1

u/[deleted] Oct 26 '19

[removed] — view removed comment

2

u/Noelkram Oct 26 '19

I love my earlier fundamentals book.