How can I practice SQL?
when i run queries there it just gives 500 errs
wil
2010-10-15 23:29:22
@wil - I just did and it worked.. What errors exactly are you getting?
Oren A
2010-10-15 23:30:37
+4
A:
I recommend just downloading a database server (MySQL is good) and running some queries in the SQL shell (MySQL Command Line Client on Windows).
Also the W3School's SQL tutorial has some "Try-it" sections that might be handy.
alpha123
2010-10-15 23:01:50
A:
Install an opensource web server like MAMP XAMPP that has Apache/MYSQL and PHPMyAdmin ready to rock out of the box.
woodscreative
2010-10-15 23:06:08
I would like to do that, but I am an idiot and I can't figure out how to hook it up to my website.
wil
2010-10-15 23:13:32
@wil you said you wanted to practice SQL, not deploy it to a live website. web servers like MAMP are a "one-click and it works" solution that will help you practice with sql.
Moses
2010-10-15 23:18:34
You would upload your application files, dump your database and drop it into your web server. Website deployed. Your local server would be a mirror of your web (live) server.
woodscreative
2010-10-15 23:29:33
I think before you start working with SQL you may need to learn not only a programming language but also about web development in general. See you in a couple of years!
woodscreative
2010-10-15 23:41:50
A:
SQLZoo is good for exercises as well as this tutorial from firstsql.com, which I used while learning.
edit: sorry was ambiguous
jly
2010-10-15 23:14:03
A:
I don't know what source material you'll be learning from, or how much of a beginner you are, but I've always liked Allen G. Taylor's SQL For Dummies. Yes, it's a Dummies title, but aside from the corny chapter headings and the cartoons, you wouldn't know it.
Andy Lester
2010-10-15 23:19:17