I personally love SQL. It's beautiful to write, and once you "get it" the syntax is truly powerful. There always seems to be a lot of hate around it, and sometimes I think that's simply because it's an "old" technology. As someone who's recently out of school, many of my peers prefer NoSQL due to the rapid speed of iteration and low learning cost (until it's too late, that is).
Also, relational database design is hard to wrap your mind around at first - but once it clicks it's quite the eureka moment. I think people forget that it is a learned pattern and can be frustrating to someone who hasn't taken the time to learn, so the alternative of a NoSQL db is much more attractive.