Slashdot Mirror
SQL Book Recommendations?
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)."
please say it ain't so. I fear any industry that can do something that horrible.
most of the software in FreeBSD /ports collection compiles with some tweaking on other unices like Linux. There is a lot of different ported software and maybe there is something unknown :>
http://www.freebsd.org/ports/japanese.ht ml
if you own a PC98 computer, etc. there is support for several PC98 cards in XFree86 3.3.3.1 and FreeBSD should enable you to compile X11 from source by just typing make install after cd to proper dir.
PS. I use OpenBSD and I just compiled X11R6 from the X11 dir, not on PC98 computer, but including fonts other than latin, I can read japanese encoded html pages in Netscape okai.
unfortunately he probably isn't. Macmillan books (under the Que, SAMS, etc. label) are generally lousy. I'm sure there are some exceptions, but the average quality is not worth your money. I have experience w/ C++ in 21 Days, _2nd_ Edition and it was filled with typos (makes the author look lousy when it's largely the copy editor's responsibility). The sad part is I thought the book was otherwise well-written.
Why is it that when i click on "Japanese with X?" I end up at SQL reference book?
Conceptual Schema and Relational Database Design, by Halpin. (2nd ed)
www.orm.net
Teach Yourself SQL In 21 Days
I think it's by Sams Publishing.
It's a very good book.
You are sooo right!
;-)
I stopped reading it because it was making me cry
-iain
hey, in an associated topic, does anybody have any good book recommendations for database design? thanks...
I've bought myself Addison Wesley's "The Practical SQL Handbook" which I find to be very good. One bad thing about it though is that you'll start cursing over the (many) limitations in MySQL pretty fast when you're using this book as a tutorial.
Anyway - The book handles SQL in a pretty generic way, but when it does reference any particular flavor of SQL it references Sybase.
Amazon.com has it down as a special order and suggests that it isn't available till August 1999. The ISBN on the new edition is 0782125395.
Posted by DiegoGuy:
Well, the first thing I would do is thoroughly read James Hoffman's SQL tutorial at
http://w3.one.net/~jhoffman/sqltut.htm.
That should get you started quite well with SQL.
MySQL has plenty of documentation online, use it.
It's Saturday 7pm, and it's still broken. I guess Rob is taking a break away from /.
^D
In Soviet Russia, Jesus asks: "What Would You Do?"
SQL Instant Reference
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.
Gonna be a dental floss tycoon
I suppose while we're on the subject, we could talk about database theory. I've been looking for some good books on distributed object databases -- anyone have any recommendations?
I've had 5 different people including the guy who works at the coffeehouse ask me about the web and databases, and I always refer them to Phil Greenspun's site @ http://www.photo.net/webdb
:-).
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
I have never trusted SAMs publishing ever since I bought a book as an innocent undergrad only to find a note in the front page...
"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.
Sorry about that, URL was wrong.
e b/db
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
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.
"Eye halve a spelling chequer, It came with my pea sea, It plainly marques four my revue, Miss steaks eye kin knot sea"
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
You're a legend! Your link is stuffed, but I found a reall great article about higher education on the domain while I was searching for it :)
Thanks!
Believe with me, my saplings.
Joe has easrned my respect by writing a humorous book that is filled practical solutions to my daily problems.
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.
Phillip Greenspun has an on-line SQL book that he's working on called "SQL For Web Nerds". It's a little hidden at his site - look for www.photo.net/sql.
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 for this and other resources.
Surprisingly (or not), This is a fairly good explanation of ANSI-92 SQL. It covers SQL nicely, and throws in some DB design basics: Normalization, etc. It's easy to read (aren't they supposed to be?), and fairly complete.
Matthew Vanecek For 93 million miles, there is nothing between the sun and my shadow except me. I'm always getting i
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..
Only 'flamers' flame!
If you're more interested the relational theory behind SQL databases, try An Introduction to Database Systems by Chris Date.
The Practical SQL Handbook is a good reference to use while learning SQL. I referred to it often while "cutting my teeth" on Informix's perverse database.
One of the only books that addresses the hairy issue of creating complicated hierarchies in SQL.
Very rewarding if you really sit down with it.
We've been passing it around the office for 6 months now.
"Handbook of Relational Database Design"
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.
I have to second this book, it is a great reference. Also, note that a new edition (1999) of it is available at Amazon.com, just search for "SQL Instant Reference". I haven't seen the new edition yet, so I can't comment on any changes.
Cheers,
Shaar
I recently read through this book and found it to be a very understandable guide to SQL. It's pretty easy to jump around in, too, which helps when you just need to quickly figure out one kind of query type.
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!
Instant SQL by WORX Teach Yourself SQL in 21 days Teach Yourself T-SQL in 21 days (This is aimed at MS SQL, but I was able to pick up a lot of non-standard transaction programming which work with mySQL). Then there is always the SQL for dummies if you don't want to learn much and just need to steal some code for a quick query.
Some months ago I've read "The Linux Database" (look at the information below). I had no prior experience with SQL, and with this book I could learn the basics, and a little more.
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
I like Joe Selko's SQL for Smarties- the best advanced SQL book, and the Sam's book Learn SQL in 21 Days, which teaches the basics of SQL programming through batch SQL, plus has good info on the inner workings of SQL Server. If you aren't planning to use M$ SQL, this book might not be for you.