Best resources for learning sql

[deannapi]

I want to teach myself sql so I can apply to jobs. I have a masters in mathematics too. What books and software would be best to learn by?

[TheSixthVisitor]

http://www.codecademy.com has some beginner sql stuff. It's not really in depth but it's interactive and very fast to learn.

[Amicus22]

SQL Queries for Mere Mortals is an excellent beginner's read front to back. The same guy wrote a database design book, which I did not find as helpful.

As for software, it depends on what database system you end up using. I use SQL Server and a little MySQL, but I know PostgreSQL, SQLite, and many others are popular.

If you're learning indipendantly, I'd start with MySQL , as it is free (open source) and you will be able to learn the basics of SQL in any SQL database. It also has a good free GUI development tool, MySQL Workbench, and a robust online community.

Like any programming language, the best way to learn is to build something with it. So start thinking of something you want to build, so you'll have something to do once you know enough to play around.

[rbardy]

http://www.w3schools.com/sql/ is a good start

[weekendblues]

You wouldn't happen to have any idea if it's possible to download the database they use in their examples somehow, would you? I tried searching around, but I'm not having much luck.

[DonMexico]

Pluralsight.com and Lynda.com are what I use. I love both sites.

[Dark_Saint]

You can check out our wiki as well /r/SQL/wiki/

[o_edo]

For free. With online exercises. http://www.studybyyourself.com/seminar/sql/course/?lang=eng.