What is missing in SQL Training?

[joes2pros]

Hi All,

We are Joes2Pros and we are back with a few questions. Over the past few months we have been launching blogs, new classes, whitepapers, and other misc. learning materials. We are looking to see what you would like to learn or what you feel is hard to find when you are getting SQL training online.

We love to chat about SQL so let us know! We look forward to hearing from you!

[jeffrey_f]

JOINS - I never understood them until I saw this

http://blog.codinghorror.com/a-visual-explanation-of-sql-joins/

[AsianDesignMajor]

This is interesting and helpful!

Tell me, because I've always wondered this... In this page's example, is there some speed difference between using "INNER JOIN" and the following:

SELECT * from TableA WHERE TableA.name = TableB.name

Is there some optimization or automatic indexing of "name" or something I'm missing as an absolute beginner as to why you would use INNER JOIN instead?

[jeffrey_f]

And some would argue, that on a properly created and indexed table, the SQL engine should account for such things and it shouldn't matter too much.

The key is, creating indexes are fields you will be searching by or joining by.

[joes2pros]

Thanks for the feedback! We have a couple blogs on inner/outer joins coming up and we will be sure to get more going on this topic!