Monday, May 11, 2015

New course: Learn SQL interactively on Khan Academy

There are millions of SQL users around the world. Who are these people, what is SQL, and what are they all using it for?

SQL stands for "Structured Query Language" and it's the standard way to interact with relational databases, a way we store data in apps and websites. Like if we actually had a database of all the people in the world and the things they use, we could find out the exact number who use SQL with a query like this:

SELECT COUNT(*) FROM people WHERE things_they_use LIKE "%sql%";

It's not just the database admins that are using it; it's the engineers that are writing code to send data to it, it's the product managers that are making decisions based on it, it's the marketing managers checking if their campaign was successful.

So that's why we decided to teach SQL on Khan Academy. We think it's the kind of skill that a huge range of people can use in their everyday life, and even if they don't, it's a great introduction to data storage and manipulation.

We started with just an Hour of SQL back in December, and based on its popularity, we're releasing a full introductory SQL course today. You'll learn more ways to query complex data, how to join data across multiple tables, how to update and delete data, and see a lot of real world examples along the way. And of course, like with all of our programming courses, you'll be writing the SQL yourself in our interactive editor.

Whether you're learning SQL for work or play, we hope you'll join us! Get started with the welcome video, or if you already did the Hour of SQL, jump in on the advanced queries tutorial:

Monday, May 4, 2015

Step 1) Learn English, Step 2) Learn to code ?

I just watched this TEDx talk where a kid shares his story of learning English and then learning JS on Khan Academy (fast-forward to 4:20):

It's awesome how much people can learn on the internet with enough motivation. Hopefully, we'll keep building out our translations so that more people can learn to code before they even learn English.