it's difficult to shoe examples of stuff made in SQL because it's more backend than front end.
basically it allows you to intelligently select data from a database...
it's one of those things that's easy to get the basics of but powerful when you do advanced stuff...
IMHO the best way to learn it would be through making an application, but to do that you'd have to learn another language as well as the SQL you needed to use.