[Vince]

When used correctly it can be very powerful, but it takes a lot of time. About 40 hours to learn the basics and then a whole lot more for the advanced stuff. I'm not trying to scare you are anything, but if you're only going to use it once and aren't fully motivated to learn then you'll have a hard time understanding it all.

The basics:

• SELECT-component
• WHERE-component
• Scalar functions
• Joins
• Subqueries
• SET-function
• GROUP BY
• SET-operators

Good SQL tutorials are scarce and I learned most of what I know in college. Unfortunately I am not allowed to share those course documents.