Main content
Hour of Code
Course: Hour of Code > Unit 1
Lesson 3: Creating SQL databasesGo beyond the hour
Congratulations on completing our hour of databases! You’ve now learned the basics of using SQL to create tables, insert data, query data, and aggregate that data. There are developers all over the world that use SQL like that every day to control the databases on their servers and their applications.
There’s much more to SQL, like to update data, delete data and combine data across tables in interesting ways. All of that is possible in our SQL environment here, so if you want to keep learning, you can go through our full SQL course on Khan Academy. If you want to keep experimenting with the basics, you can also create a new SQL script.
If you just have another hour free, you can also try out another Hour of Code tutorial.
Whatever you decide to do, keep practicing. Most programmers code every day, and that’s how we keep our skills sharp. And hey, it’s fun!
Want to join the conversation?
I really enjoy SQL but haven't been able to find extensive interactive tutorials. I've done both SQLcourse and SQLcourse2. Any idea when an advanced version will be hitting KA?(62 votes)
From the author:We now have a full SQL course on Khan Academy: https://www.khanacademy.org/computing/computer-programming/sql(21 votes)
sqlcourse.com and sqlcourse2.com are dead links.(12 votes)
Remove the "s" from https://
There, it should work now.(11 votes)
- How can I use SQL on my computer? I see under my programs that I have SQL Server 2012 installed, but is there a way to 'open' SQL through command prompt?(8 votes)
MS SQL is ok, but kind of overkill unless you will be getting into complex, multi-user things. (Same for PostgreSQL and MySQL)
SQLite Browser (which includes SQLite) is probably a better choice after KA's courses:
http://sqlitebrowser.org(4 votes)
is SQL the languae that websites use to make search bars lke the one at the top of KA?(4 votes)- From the author:Some of them! We use Amazon CloudSearch on KA, ourselves, but Coursera uses SQL for theirs.(10 votes)
How do I make a new program?(5 votes)
How do I get a project Reviewed?(4 votes)
The SQL challenges and projects are evaluated by an auto-grader.(2 votes)
I enjoyed SQL but I still have some confusion on certain databases. I didn't finish the Challenge: Box office hits database. How can you get a hint of what you are doing in each lesson?(3 votes)
They give you hints. If you still don't get it, then you might want to see the previous article.(3 votes)
- How many different Hour of Codes are there?(2 votes)
There are three of them.
How of Drawing with Code:
https://www.khanacademy.org/computing/hour-of-code/hour-of-drawing-code/v/welcome-hour-of-code
Hour of Webpages:
https://www.khanacademy.org/computing/hour-of-code/hour-of-html/v/making-webpages-intro
and Hour of Databases:
https://www.khanacademy.org/computing/hour-of-code/hour-of-sql/v/welcome-to-sql(3 votes)
- I've finished every computer programming challenge and tutorial offered on Khan Academy. Is there another website I could go to to expand my knowledge of coding further? What should I learn next?(2 votes)
- If you want to improve at the sort of web development stuff that Khan Academy teaches, W3Schools is a relatively beginner friendly site. If you want even more depth, MDN is way better.
I also find that OSSU has a boat-load of free resources related to computer science(2 votes)
- I am anxious to go a bit further. This is a good introduction. When can we expect an expansion of this section?(2 votes)
- From the author:We now have a full SQL course on Khan Academy: https://www.khanacademy.org/computing/computer-programming/sql(1 vote)
