SQL in a Nutshell: A Desktop Quick Reference
||Author: Kevin Kline|
List Price: $29.95
Our Price: Click to see the latest and low price
Publisher: O'Reilly & Associates (01 December, 2000)
Sales Rank: 7,371
Average Customer Rating: 3.54 out of 5
Customer ReviewsRating: 5 out of 5
This book is great for a desktop reference. It contains loads of SQL commands and it shows how to use them for different database packages, like MySQL.
Rating: 5 out of 5
What the book is, and what it is not.
This book is designed as a reference -- the book that you keep
near your workstation after you learn the basics, because you
haven't got everything memorised yet. It's great for that. I
refer to it when I have a question.
But actually I picked up this book with no prior knowledge of
SQL (except that I knew it was for doing database stuff) and
learned enough to get started in a couple of days. The intro
is great for that.
The great thing about this book is that it covers the four
major SQL implementations in a relatively unbiased fashion.
This is nice because if you switch from one to another you
don't have to go looking for a new book. (Otherwise, you
would; as you will see from reading this book, the various
implementations differ considerably and also differ from
the unimplemented standard, which the book also covers.)
This book is not, and is not intended to be, a tutorial for
people who are utterly unfamiliar with the very concept of
a database, but it's okay to be utterly unfamiliar with SQL.
This book also is not a strategy guide for how to plan and
organise your database; this is an _implementation_ book.
As such, it doesn't cover things like deciding which data
to put in which table, when to create another table and
when to create an entirely separate database, or that sort
of thing. What it does tell you is what query syntax you
need to create and interact with your database, your tables,
and the data in your tables. It also explains datatypes,
because they vary considerably between the different SQL
implementations, and table types and the various attributes
(indeces and whatnot).
Additionally, this book is not a security guide. It does
include information about permissions, but only in terms of
the syntax used, not in terms of strategy.
Rating: 4 out of 5
good choice if you work with more than one flavor of SQL
If you find yourself tripping over the different flavors of SQL in MS SQL Server, MySQL, Postgre, and Oracle, then buy this book. This is not a good book to learn SQL or set theory. Nor is this a good book to use to learn how to manage or tune a database. This is a small enough reference that you can easily carry it out of the house or office.
· ASP in a Nutshell, 2nd Edition
· SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
· Sams Teach Yourself SQL in 24 Hours (3rd Edition)
· Sams Teach Yourself SQL in 10 Minutes (2nd Edition)