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…