I need to REALLY learn SQL - Book recommendations please
Moderator: General Moderators
I need to REALLY learn SQL - Book recommendations please
Alright, I've put it off for too long. I know just enough SQL to get me by, but honestly I only partly know what joins do. I'm an SQL-tard. It's time I learn it and learn it thoroughly. I'm looking for recommendations on SQL in general, but the two RDBMS's I plan on using to any extent are Mysql and Postgres. There is a small possibility I'll use SQLite, but probably not any time soon. If anybody has a good recommendation, please let me know. Thanks!
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
I'm assuming that you are looking for an advanced SQL reference? (I can't believe the Ninja needs help with simple joins, etc.! There's ample beginners' SQL tutorials online.) Even then, there are some pretty good online tutorials. Check out http://www.smart-soft.co.uk/Oracle/adva ... part-2.htm or http://www.1keydata.com/sql/sql.html or the old standby, http://www.w3schools.com/sql/sql_join.asp.
The trouble I've had with SQL books, especially advanced ones, is that the authors are often real academics who have to pad the book with every possible feature, forcing you to read 400 pages just to learn how to do a join that could be explained in a short paragraph.
The trouble I've had with SQL books, especially advanced ones, is that the authors are often real academics who have to pad the book with every possible feature, forcing you to read 400 pages just to learn how to do a join that could be explained in a short paragraph.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Queries, I'm not really interested in managing the database server, although I am the proud owner of this little doozy:
http://www.amazon.com/High-Performance- ... 034&sr=8-5
http://www.amazon.com/High-Performance- ... 034&sr=8-5
I'm not familiar with that one. Is it good? O'Reilly books usually have good authors.The Ninja Space Goat wrote:Queries, I'm not really interested in managing the database server, although I am the proud owner of this little doozy:
http://www.amazon.com/High-Performance- ... 034&sr=8-5
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA