What is Digg?Sponsored by HTC
Who knows you better than your phone? view!
youtube.com - See you from the perspective of your phone.
25 Comments
- inactive, on 10/12/2007, -0/+5extremly handy for someone looking to get into sql
- r121, on 10/12/2007, -0/+2You can always install MySQL or something else yourself, and practice that way. That's what I did.
- B0SS, on 10/12/2007, -0/+2Totally awesome man! its very usefull, I've always wanted something like this! 10x :)
- seanmc303, on 10/12/2007, -0/+2Are you kidding? If you click on any of the links in the "tutorial" section, you should notice text fields on the right side with a "Submit Query" button. That is where you try the SQL out.
- byronm, on 10/12/2007, -0/+2Its always great to learn sql, but this best thing is to learn how to apply it to your process. Don't get stuck in the trap that because you can do it through a crazy sql statement that stored procedures, functions and other rdbms specific addons wouldn't be a better approach :)
I always recommend learning sql. Its great for developers, great for people who compile data and most importantly great for those looking to beef up there resume and have more job opportunities.
for me inner and outter joins get so convoluted - especially people coming from access world that i preferr to teach data normalization, stored procedures, functions and other re-usable components that free up sql to be the lightweight interface it is while leaving some of the logic in a standard package/interface.
just my 2 cents :) - Burmask, on 10/12/2007, -1/+3There is a god - http://sqlzoo.net/noads/
- getrealnow, on 10/12/2007, -2/+3I looked at it for about 15 mins, where do I try to use the commands myself?
- pretentious, on 10/12/2007, -0/+1Perfect timing... just starting a transition from FoxPro to SQL. This will certainly help in taking the training wheels off. Good Digg
- dfsiii, on 10/12/2007, -0/+1The best way to learn is to have examples to try on your own, see how what you do changes the end result, and to have answers to all of the questions. I wish more tutorial sites were like this.
PS Some of the tables (like track in the join tutorial) have moved or aren't there anymore? - MasterTreb, on 10/12/2007, -0/+1bookmarked, I need to learn SQL one of these days. Great link digg++.
- pauleric, on 10/12/2007, -0/+1Do they teach drop table in their textarea? No, I'm not saying to try it!
- AssultMonkey, on 10/12/2007, -0/+1Good work diggers, you broke the db so now I can't test the queries. (FYI)
- subcodec, on 10/12/2007, -0/+1When I was in school, the instructor took us to this site for various examples and tutorials. I already had this site bookmarked, but I digg this because it is a good help for beginners.
- jiggersaurus, on 10/12/2007, -0/+1I'm proud to say the owner/creator of this site was my honours project tutor back in 04/05. he is a fine chap, and deserves all the Kudos he gets!
- ABadInAlbany, on 10/12/2007, -0/+1Osbourne's SQL reference > *
- seanmc303, on 10/12/2007, -1/+2This is the first tutorial that that allows people to test out their own queries right off the website. I'm sure they restricted the web user account to only select privileges, and that is why there are no tutorials for Insert, Delete, Drop, and all those other fun queries. This is a great reference source.
- HisTumness, on 10/12/2007, -0/+1Still can't wait for the movie "UPDATE bodies SET status = 'DEAD'" to come out.
http://www.qwantz.com/index.pl?comic=153 - mohmar, on 10/12/2007, -0/+1This is a pretty good reference, but for an introduction, wouldn't learning the ODBC supported commands be a better start? Then, if you get more into SQL you can pick up a specific flavor and further optimize your queries. But I would think those base-level commands would be much more important knowledge in the long run, because at least you know how to write basic queries that will always work...
- jeugeorge, on 10/12/2007, -0/+0If you have any questions on SQL you can post them at the TEKPOOL forums. http://www.tekpool.com/forums
- lukasmach, on 10/12/2007, -0/+0O'Reilly's book "SQL Cookbook" is great.
- cjakeman, on 10/12/2007, -0/+0I've used parts of this for 3 years to help teach SQL at degree level. The students love it.
Also the different engines have subtle differences in the commands they will accept - a valuable lesson once this is discovered.
Andrew Cumming deserves lots of credit for making this generally available. - gharding, on 10/12/2007, -0/+0I wish they'd included the actual standard as well. If you can figure one out, all you need to do to move to one of the others is figure out the little nuances. Honestly, I find this site far more useful, since I'm a forgetful folk and work with mySQL, pgSQL, Oracle, msSQL and db2 on a nearly daily basis:
http://troels.arvin.dk/db/rdbms/ - cbmeeks, on 10/12/2007, -2/+1Nice. I guess.
http://www.codershangout.com/blogs/cbmeeks/ - Resilient, on 10/12/2007, -1/+0A great resource. Definately helpful for those thinking of sql as a daunting experience like myself. I'm pretty lazy when it comes to learning new programming languages, this will definately motivate me to give it a shot in the least.
- Funny192, on 10/12/2007, -12/+1Who hasn't been to this site already if you are a programmer, though?
© Digg Inc. 2009
— Content created and posted by Digg users is