Re:Easy Steps to a Complete Understanding of SQL
by zamalek on Tuesday September 03, 2013 @07:03AM
(#6320186)
The way I see SQL in my mind is programming Venn Diagrams ( http://en.wikipedia.org/wiki/Venn_diagram ) followed by creating a projection that uses one or more of the areas within that diagram (contrasting strongly with imperative languages, i.e. logic programming). Unfortunately it's not straight-forward to do that because SQL is a superset of Venn Diagrams, but that line of thinking is where you need to be.
[ Parent
| on HN ]
Re:Easy Steps to a Complete Understanding of SQL
by ams6110 on Tuesday September 03, 2013 @07:08AM
(#6320198)
Yes, exactly. To use SQL well you need to think in terms of sets and set operations. Venn Diagrams are a good idea to help visualize this. If you find yourself writing a lot loops over cursors there's a good chance you're doing it wrong.