sql-zoo

SQLZoo: Here Was My Experience Learning SQL on SQLZoo

I’m a tech writer. Not a programmer. And until a short time ago, I had never written a single line of code in my life. But then something changed: SQLBot challenged me to review SQLZoo’s Structured Query Language course…

SQLZoo is a free, “learn-by-doing” SQL course that has you punching out queries and wracking your brain for the solutions from the very beginning. It’s fun (if you like puzzles), but more importantly: Does SQLZoo teach you what you need to know?

undefined

Long story short, I completed the course and have the green bars of progress to prove it. If you want to know if I actually learned SQL, keep reading. In this review I’ll cover the following:

  1. What’s SQLZoo?
  2. What’s It Like to Learn SQL with SQLZoo?
  3. Tips for getting the most from the course
  4. How long does SQLZoo take to finish?
  5. But will SQLZoo teach me to code in SQL?

1) What’s SQLZoo?

Before I started SQLZoo, I burrowed around for some information on the course—while looking for a ray of plan to motivate me to finish it! The issue was, SQLZoo doesn’t make any promises on their website aside from that they offer ” tutorials and reference to support individuals learning SQL” and ” everyone on the planet is free to use our site and the material on it in any way they see fit.”

I highly recommend SQLZoo at SQLZOO. The exercises are interactive, and they will walk you through the basics of writing SQL queries, including selects, aggregations, and various kinds of joins. The best part is that you get to run the SQL queries live.

I’d recommend it for both learning SQL from scratch and refreshing SQL.

William Chen, Former Data Science Manager at Quora

Digging deeper, I discovered that SQLZoo is anything but “new.” Most SQL veterans know it’s the “old-school” way to learn Structured Query Language. In fact, SQLZoo.net has been around—and experienced numerous revisions and modernizations—since the dialup internet days of 1999.

The SQLZoo folks are a pretty funny too. They refer to their SQL systems as “inmates,” while assuring novice users they’re not dangerous. According to SQLZoo:

They have been tamed, caged and defanged so that members of the public can pet them or poke them or gawk at them. In the wild, these engines are dangerous, needy beasts but in the confines of SQLzoo they are relatively safe. Once you have an idea of what SQL is and how it works you should install an SQL engine on your own computer and play with the real thing.

Last but not least: SQLZoo is free! Considering that SQL coders earn an average salary of $70k in the U.S. (and sometimes more than $100k). SQLZoo is offering an extremely valuable service.

  • So far so good. SQLZoo was offering:
  • A thoroughly-recommended SQL course.
  • A long-standing reputation of being the “tried-and-true” way to learn SQL.
  • A sense of humor.
  • A tremendous value to everyone in the world (for free)

I was ready to take the plunge.

2) What’s It Like to Learn SQL with SQLZoo?

The SQLZoo course features nine primary lessons that take you from easy-beginner to brain-destroyingly-complicated in no time. Here’s the format:

  1. SELECT basics, quiz
  2. SELECT from world, quiz
  3. SELECT from nobel, quiz
  4. SELECT in SELECT, quiz
  5. SUM and COUNT, quiz
  6. JOIN, quiz
  7. More JOIN, quiz
  8. Using NULL, quiz
  9. Self JOIN, quiz

The course is an immersive, learn-it-by-doing-it format. From the start, you’ll be typing code, clicking submit, and hoping that your queries produce the correct answer. When you get it right, a smiley face appears:

4) How Long Does SQLZoo Take to Finish?

The one thing I wanted to know most before starting SQLZoo was: How long is this going to take? In the end, SQLZoo took me 18 to 20 hours of study time to finish. I wasn’t moving fast, and I wasn’t “on-task” during all those hours (I took a couple of coffee breaks!).

Basically, on the off chance that you had to finish the course in an end of the week, you could dig in and do it. Your head will be buzzing with INNER JOINs and WHERE clauses. You’ll be lost in infinite loops of nested SELECT statements. And you’ll be dreaming of wonderful queries and infinite datasets. Be that as it may, in the end, SQLZoo will teach you several university courses worth of material in no time.

) But Will SQLZoo Teach Me to Code in SQL?

SQLZoo will teach you the foundations and basics of SQL—on top of some very advanced skills. You’ll have the tools required to write complex queries and create, edit, update and modify databases.

I’m not a SQL expert or guru (yet). But the fact I scored 100% on this test says a lot for the SQLZoo course. I was a complete “newbie” before taking it, and all I did was proceed through the lessons, step-by-step without any additional coursework or studying—just a fair amount of banging my head against the wall.

Going through SQLZoo reminded me of learning a foreign language. At first, you’re stretching your brain to understand the simplest of concepts, but before you know it, things start clicking together. In the meantime, SQLZoo has given me a command of SQL that’s good enough to write (what seems to me like) intermediate-level queries.

By the time you finish the lessons, you’ll have an excellent understanding of nested SELECT statements, INNER JOINs, LEFT and RIGHT JOINs, SUMs and COUNTs, ORDER BY, COALESCE and you’ll also be able to update, modify and create new databases.

 

 

Related Posts