Eli Weinstock-Herman

SQL Is Hard

Original post posted on Wednesday, June 12, 2013 at LessThanDot.com

SQL is hard. Who's to say whether it's harder for the person that has no technical background or the one that is comfortable with object oriented, procedural, or functional styles and has to cross the great divide to set-based, declarative queries. In either case, there's a journey ahead of you.

Luckily there are a lot of great resources out there to help. From live webcasts like SQLLunch and 24 hours of PASS, to local SQL Saturday events, from recorded TechEd sessions to hundreds of books to blogs posts on sites like this....the list goes on.

But it's still a long road, and building that initial solid foundation can be a hard step.

The Inquisitive Coworker

Over the years I've never had a good answer to the "where can I go to learn more about that" question from coworkers. There's a ton of beginner books out there, but who has the time to weed through them and figure out which ones are more dangerous than they are helpful?

So the thought runs through my head, "How _did_ I learn that CROSS JOIN trick I just used?" and of course I don't remember. Except I'm willing to bet that I learned it while trying to solve a problem. It might have been from a book, from a video, from trying someone else's answer to one of Denis's SQL puzzles. The driver was the fact that I had a problem to solve and that new tool I picked up was what helped me solve it. And I later remembered it, used it again, and learned more about it because it helped me solve a problem.

Learn by Doing

I've always liked the idea behind the TryRuby site, an interactive experience that walks you through the basics of Ruby as you type them into an interactive console. Short of finding a mentor for every person that wants to give Ruby a try, this seems like an excellent way to provide a guided experience and help you build that initial foundation.

Why not do this with SQL?

And why not take it even further? After all, if you have an interactive site that helps build some basic skills with SQL, why can't it also offer a section for more advanced techniques? Sure, you can download a free version of SQL Server Express or one of the other brands of SQL and try to learn these things on your own, but a guided set of exercises on a topic might be the perfect foundation before trying to branch out and try to invent your own problems to solve.

And thus was born the idea of SQLisHard.com.

SQLisHard Screenshot

It's Still Early

It's still in the very early stages with only a single set of exercises, and I've only implemented about half of that set. There's a longer wishlist of features on a Trello board, but the initial focus here was making the core experience work. It's not as whimsical as the TryRuby site (Damnit Jim, I'm a software engineer not a web designer). Most of the fanciest features are focused on helping me choose the right improvements to make; easy deployment, anonymous usage statistics, error capturing and reporting, and so on.

My list of "features I haven't gotten to yet" starts with "finish the first exercise set". After that I have more exercise sets, both foundational and "where can I go to learn that" advanced sets, an ability to save your progress (register/login) while continuing to let people without pre-registering (or without registering at all, up front registration annoys me), more permanent pieces for the few that I took shortcuts on, alternative exercise goals so you can try several queries while learning a single step, performance improvements and retry logic

But most importantly, I'm looking for feedback. Does this seem like something you would point a beginner to? When your coworker asks where they could learn to use windowing functions, could you imagine a method like this being useful?

Check it out: SQLisHard.com

The technologies behind both the site and the deployment process were interesting, I'll have follow-up posts on those soon as well.

Comments are available on the original post at lessthandot.com