To many programmers, SQL is a bit of a beast. It is one of the few declarative languages out there, and as such, behaves in entirely different ways from imperative, object-oriented, or even functional languages (although, some say that SQL is also somewhat functional).

I’m writing SQL every day, embracing SQL with myOpen Source Software jOOQ. I thus feel compelled to bring the beauty of SQL a bit closer to those of you still struggling with it. The following tutorial is destined for

• readers who have already worked with SQL but never completely understood it
• readers who know SQL well but have never really thought about its syntax
• readers who want to teach SQL to others

This tutorial will focus on SELECT statements only. Other DML statements will be covered in another tutorial. Here are…

10 Easy Steps to a Complete Understanding of SQL – Tech.Pro.