6 ms·

Interactive SQL Tutorial

89 points by sonabinu 14y ago

ubersoldat2k7 14y ago
Very nice! Thanks!
bragh 14y ago
If you want more general knowledge, then db-class.org is pretty awesome too. Going through even some of those materials has probably saved me weeks' worth of work, because not only do you get general SQL knowledge and practice, you get a grounding in theory, XML and NoSQL too.
- sonabinu 14y ago
  thx, that is great info.
- eddie_the_head 14y ago
  10gen is conducting free MongoDB classes on edX (MOOC platform by Harvard+MIT+Berkeley) currently. https://education.10gen.com/courses https://education.10gen.com/courses M101: MongoDB for Developers M102: MongoDB for DBAs
  - sonabinu 14y ago
    Thanks for that input ... I was actually looking for something on those lines, appreciate your comment greatly.
stephenheron 14y ago
Their are two similar sites, one for programming and another for Linux system administration. http://linuxzoo.net/ http://linuxzoo.net/ and http://progzoo.net http://progzoo.net
samzhao 14y ago
Your site is down? http://www.isup.me/sqlzoo.net http://www.isup.me/sqlzoo.net
hayksaakian 14y ago
As someone who started learning databases with NoSQL (mongodb), the familiar syntax (JavaScript) made learning higher order concepts much easier. SQL throws a ton of syntax at you that's only really useful in SQL, and personally put me off learning backend development.
- codewright 14y ago
  OTOH, if you're in a mode of operation where you're interacting with data directly with any regularity, SQL syntax is a massive improvement over MongoDB's JS DSL.
- jiggy2011 14y ago
  Having something that is "only useful in SQL" really sells it quite short. SQL is the bread and butter of the data storage world, since it is compatible with more DBMS systems than anything else. For every mongoDB deployment out there, there will be thousands of Oracle/MSSQL/MySQL/etc databases running critical business functions working with both off the shelf and custom software in everything from family businesses to FTSE 100s. Besides, SQL is not a fully turing complete language which actually makes it easier to reason about and to evaluate. Not to mention the amount of study it has had (COD NF etc) over the years. You can do a lot with a Database by understanding a subset of syntax; SELECT , UPDATE , INSERT, DELETE , INNER JOIN , OUTER (LEFT|RIGHT) JOIN.
  - hayksaakian 14y ago
    While you are correct, I still think NoSQL is a better introduction to databases than SQL. Without the syntax learning curve you can quickly interact with a database and get a feel for how it works for the first time. Once you get a hang of the broad db concepts, it could of course make sense to learn SQL given the reasons you've presented.
skram 14y ago
Can't reach the site since it's down but another site that I've used and recommend is http://sqlfiddle.com/ http://sqlfiddle.com/. Supports several DBMSes
- sonabinu 14y ago
  your recommendation is real good ... thanks for sharing :)
- alttag 14y ago
  I haven't worked on it in some time (it's still very much alpha; and I keep meaning to release it on github), but I'd love some tips on improving http://sqmight.com http://sqmight.com. SQLite backend.
msi77 14y ago
Another interactive tutorial: http://www.sql-tutorial.ru/content.html http://www.sql-tutorial.ru/content.html and exercises: http://sql-ex.ru/exercises/index.php?act=learn http://sql-ex.ru/exercises/index.php?act=learn

89 points by sonabinu 14y ago

Very nice! Thanks!

bragh 14y ago

If you want more general knowledge, then db-class.org is pretty awesome too. Going through even some of those materials has probably saved me weeks' worth of work, because not only do you get general SQL knowledge and practice, you get a grounding in theory, XML and NoSQL too.

sonabinu 14y ago
thx, that is great info.
eddie_the_head 14y ago
10gen is conducting free MongoDB classes on edX (MOOC platform by Harvard+MIT+Berkeley) currently. https://education.10gen.com/courses https://education.10gen.com/courses M101: MongoDB for Developers M102: MongoDB for DBAs
- sonabinu 14y ago
  Thanks for that input ... I was actually looking for something on those lines, appreciate your comment greatly.

stephenheron 14y ago

Their are two similar sites, one for programming and another for Linux system administration. http://linuxzoo.net/ http://linuxzoo.net/ and http://progzoo.net http://progzoo.net

samzhao 14y ago

Your site is down? http://www.isup.me/sqlzoo.net http://www.isup.me/sqlzoo.net

hayksaakian 14y ago

As someone who started learning databases with NoSQL (mongodb), the familiar syntax (JavaScript) made learning higher order concepts much easier. SQL throws a ton of syntax at you that's only really useful in SQL, and personally put me off learning backend development.

codewright 14y ago
OTOH, if you're in a mode of operation where you're interacting with data directly with any regularity, SQL syntax is a massive improvement over MongoDB's JS DSL.
jiggy2011 14y ago
Having something that is "only useful in SQL" really sells it quite short. SQL is the bread and butter of the data storage world, since it is compatible with more DBMS systems than anything else. For every mongoDB deployment out there, there will be thousands of Oracle/MSSQL/MySQL/etc databases running critical business functions working with both off the shelf and custom software in everything from family businesses to FTSE 100s. Besides, SQL is not a fully turing complete language which actually makes it easier to reason about and to evaluate. Not to mention the amount of study it has had (COD NF etc) over the years. You can do a lot with a Database by understanding a subset of syntax; SELECT , UPDATE , INSERT, DELETE , INNER JOIN , OUTER (LEFT|RIGHT) JOIN.
- hayksaakian 14y ago
  While you are correct, I still think NoSQL is a better introduction to databases than SQL. Without the syntax learning curve you can quickly interact with a database and get a feel for how it works for the first time. Once you get a hang of the broad db concepts, it could of course make sense to learn SQL given the reasons you've presented.

skram 14y ago

Can't reach the site since it's down but another site that I've used and recommend is http://sqlfiddle.com/ http://sqlfiddle.com/. Supports several DBMSes

sonabinu 14y ago
your recommendation is real good ... thanks for sharing :)
alttag 14y ago
I haven't worked on it in some time (it's still very much alpha; and I keep meaning to release it on github), but I'd love some tips on improving http://sqmight.com http://sqmight.com. SQLite backend.

msi77 14y ago

Another interactive tutorial: http://www.sql-tutorial.ru/content.html http://www.sql-tutorial.ru/content.html and exercises: http://sql-ex.ru/exercises/index.php?act=learn http://sql-ex.ru/exercises/index.php?act=learn