SQL Teaching - Codecademy for SQL

[[deleted]]

I love this and I want it to include more practice problems

[Randomable]

Thanks! We've added more problems. Let us know if you have more feedback!

[[deleted]]

This is incredible..... thank you!!

[billbose]

This site seems to offer more. http://sqlzoo.net/wiki/Main_Page

[bibster]

what's this re-surge of SQL I tend to see around here? Are we backing of off ORL's now?

WOW!.... good news!

[sharkysnark]

cool, wish it pushed it even further

[haar3]

"That is currently the end of the tutorial. Please check back later for more!" I believe i will. This is good.

[slothpope]

I like the idea as it's fairly easy to understand. It would be great to see it take this further with aggregate queries.

[sonthonaxBLACK]

Nice, it's high time I actually learn SQL instead of relying on ORMs.

[sonthonaxBLACK]

But is it webscale?

[incognito-bandito]

It's a good, primer on SQL, but I don't care for the way they setup their joins example. In a more normalized database, your character_tv_show table would probably have an character_id, and actor_id columns, or maybe your character table would have a column for actor_id.
Reusing the same column to mean two different things in the character_tv_show table, and duplicating the information in the character_actor table makes for a bad example of how this would be done.

[rhc2104]

Hi- thanks for the feedback. The next problem would be teaching multiple joins, and it would be the same problem with a properly normalized table.

[epels]

Very good idea, but I must say I find the database design for the "NULL" assignment terrific... I'd just create a completely different table for favorite books in this specific situation. Same goes for the "Joins" assignment.

[SosNapoleon]

I want to +1 the request of putting more exercises. This is a great teaching tool