SQL Book Recommendations? 34
Daniel Myers
asks:
"I'm designing a MySQL database as a senior project, and I
need a decent book on SQL. I've looked at the ORA Msql/MySQL
book, but it's not going to be published soon enough for me
to use, so does anyone have a decent recommendation? I have
some SQL knowledge, but not much (I can write basic
SELECT/INSERT/UPDATE statements, but that's about it)."
Sadly the new edition isn't out until August (Score:1)
James Hoffman's SQL Tutorial (Score:1)
Well, the first thing I would do is thoroughly read James Hoffman's SQL tutorial at
http://w3.one.net/~jhoffman/sqltut.htm [one.net].
That should get you started quite well with SQL.
MySQL has plenty of documentation online, use it.
Still skrewd up (Score:1)
^D
The UberReference (Score:1)
by Martin Gruber Every big database expert I've met has this book. Not going to explain the deep inner secrets of SQL, but it comes in pretty handy when your perfecting that perfect statement. Explains basics of SQL and RDBMS's, explains syntax and compliance level for each statement. Good stuff.
Recommendations on Database Theory books? (Score:1)
Check out Phil Greenspun's site (Score:1)
They usually come back with an awed look on their face and tell me they never thought computers could be that complicated. If they're lucky.
The best database design book is Database Design for Mere Mortals.
The best beginner's SQL reference book is SQL: A Reference Manual.
The best advanced SQL book is SQL for Smarties.
The best book which actually ties all of it together and shows you how it works with a web site or an application is probably Web Tools Review, or Oracle Design. IMNSHO
Wash that book out of your mouth (Score:1)
"Due to a spelling error, all instances of the word struct have been replace with the word strict. In order to save trees, we have elected not to reprint the book, and ask you to see in your mind a struct for a strict."
Halfway through the book there's a phrase "[...] what do we use for this ADT? Why, it's our old friend the strict."
I was young and stupid. Never again.
Whoops, use http://www.photo.net/wtr (Score:1)
The web tools review is Phil Greenspun's book. He also has a high signal forum at
http://www.photo.net/bboard/q-and-a.tcl?topic=w
Great textbook (Score:1)
Check out the Second Edition of "Database Systems, A Practical Approach toDesign, Implementation, and Management" by Thomas Connolly and Carolyn Begg. It's and excellent book, but it's not a "how to do SQL in 30 seconds" kind of book. It's a solid 3-inch think text book. It covers everything in a lot of detail, with a good amount of background info to help everything soak in. One of the best database beeks I've ever seen. It's by Addison-Wesly, an excellent publishing company. Their books are excellent.
Also check out "Understanding SQL: a complete guide" By Melton and Simon. It's a great guide to the SQL-92 standard, but with a much better explanation.
SQL book recommendation (Score:1)
ISBN: 0-201-56545-5
This has been the most helpful general SQL reference I've been able to find in a single book.
Don't worry about its age (1992) or the Oracle in the title
Check out Phil Greenspun's site (Score:1)
Thanks!
SQL Book: I prefer Joe Celko's 'SQL For Smarties' (Score:1)
He assumes that you've had about a year or so of SQL, and goes ahead and shows you the caveats and emptors of what you are currently doing. He then covers many advanced problems, and shows good solutions to them.
This book took my SQL writing to the next level.
Greenspun also has an online SQL book (Score:1)
It's not all new - he's pulled pieces from his other books, but it's got some useful stuff in it, and the price is right.
Phillip's new book - "Phillip and Alex's Guide to Web Publishing" - has a fair amount of SQL within it. Phillip's book will be out anytime, but the entire text of the book is available on-line. Check out www.photo.net/wtr [photo.net] for this and other resources.
SQL for Dummies (Score:1)
select (Score:1)
SQL is pretty easy.
the company I work for has computer based training on sql so cannot recommend a book...
however it is as easy as
there is a bit more than that .. the best place to get books is with the db.. ie Oracle has a collection of books that you can get when you get there dabase software..
More of an Anti-SQL book.. (Score:1)
SELECT...SQL (Score:1)
The Practical SQL Handbook Highly Recommended (Score:1)
Re:SQL Book: I prefer Joe Celko's 'SQL For Smartie (Score:1)
Very rewarding if you really sit down with it.
We've been passing it around the office for 6 months now.
cool, but... (Score:1)
by Fleming and von Halle
Leads you through all three levels of database design from start to finsh. Exhaustive and not for the faint-hearted but probably the definitive work on the subject.
The UberReference (Score:1)
Cheers,
Shaar
Good, but same as MS SQL 6.5's on-line help! (Score:1)
However, I was pretty floored to read much of the text, verbatim, in the on-line help for Microsoft's SQL Server 6.5. I don't know which came first, but definitely spookey!
SQL books worth looking at (Score:1)
The Linux Database (Score:1)
I could find it on Amazon.com, Barnes & Noble, and Books.com. Probably there are other places where you may find it. The price is around $30.00 and $40.00.
Title: The Linux Database
Authors: Butzen, Fred and Forbes, Dorothy
Publisher: MIS Press
ISBN 1558284915
SQL books (Score:1)