- Paperback: 467 pages
- Publisher: Morgan Kaufmann Publishers In (July 1995)
- Language English
- ISBN-10: 1558603239
- ISBN-13: 978-1558603233
- Product Dimensions: 22.4 x 17.8 x 2.5 cm
- Average Customer Review: 3.9 out of 5 stars See all reviews (10 customer reviews)
-
Amazon Bestsellers Rank:
648,270 in Books (See Top 100 in Books)
- #84 in Books > Computers & Internet > Computer Science > Databases > SQL
- See Complete Table of Contents
Joe Celko's SQL for Smarties, Third Edition
and over one million other books are available for Amazon Kindle .
Learn more
| ||||||||||||||||||||||||
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
|
There is a newer edition of this item:
|
Product details |
More About the Author
Product Description
Amazon.co.uk Review
In the SQL database community, Joe Celko is a well-known columnist and purveyor of valuable insights. In Joe Celko's SQL for Smarties: Advanced SQL Programming, he picks up where basic SQL training and experience leaves many database professionals and offers tips, techniques and explanations that help readers extend their capabilities to top-tier SQL programming.
Although Celko denies that the book is about database theory, he often alludes to theory to buttress his practical points. This title is not for novices, as the author points out. Instead its intended audience is SQL programmers with at least a year's experience. The book maintains a fine balance between technical discussion and practical explanation--picking hot topics and offering advice on a wide range of subjects.
The book uses ANSI SQL-89 as its baseline standard, with some mention of SQL-92 features. However, it does not focus on any commercial product but rather zeroes in on the SQL language. Celko covers all aspects of database design, optimisation and manipulation, with easy-to-understand explanations of key issues such as why not to use too many nulls, how to use practical normalisation and how to optimise queries.
This insightful text is manna for all the day-to-day SQL coders banging their heads over the language's subtle challenges. --Stephen W.Plain
Topics covered:
Database design and normalisation, SQL data types, querying, grouping, set operations, optimisation, data scaling and encoding.
Review
"If you work with SQL in any way, shape, or form, the most recent edition of Joe Celko's SQL for Smarties needs to be on your bookshelf!"--Data Technology Today Blog
--This text refers to an alternate
Paperback
edition.
Inside This Book
(Learn More)
Browse and search another edition of this book.
Browse and search another edition of this book.
First Sentence
"THIS CHAPTER DISCUSSES the DDL (Data Definition Language), which is used to create a database schema, and it is related to the next chapter on the theory of database normalization." Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
"THIS CHAPTER DISCUSSES the DDL (Data Definition Language), which is used to create a database schema, and it is related to the next chapter on the theory of database normalization." Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Suggested Tags from Similar Products(What's this?)Be the first one to add a relevant tag (keyword that's strongly related to this product)
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
6 of 6 people found the following review helpful
Format:Paperback
If you like writing massive stored procedures, using cursors and other non-relational and non standard features of your database then this book probably won't appeal to you much.
Joe Celko puts a lot of effort into showing how you can write high performance and standard SQL without resorting to proprietary hacks. He clearly has a very strong understanding of the underlying theory behind relational databases and uses plenty of examples to explain his points.
I would recommend this book as a very good read to generally improve your overall knowledge of SQL and SQL best practices.
Joe Celko puts a lot of effort into showing how you can write high performance and standard SQL without resorting to proprietary hacks. He clearly has a very strong understanding of the underlying theory behind relational databases and uses plenty of examples to explain his points.
I would recommend this book as a very good read to generally improve your overall knowledge of SQL and SQL best practices.
4 of 4 people found the following review helpful
Format:Paperback
This book is not his basic volume in SQL, but his advanced volume. It helps you along explaining different issues with an excellent explanation of NULLS, their pros and their cons. It gives examples of solving problems in different SQL ways. A great buy.
2 of 2 people found the following review helpful
Format:Paperback|Amazon Verified Purchase
I have always admired Joe Celko for bringing SQL smarts to SQL programming. This book is a very good step forward over the previous books. However within minutes of opening the book I found several errors. And I noticed this in his other books as well. It seems the editorial and technical staff of his publisher needs improving. The most frustrating thing is that there is no website or e-mail address in the book where to get the corrections or send errata.
It can make for a frustrating and confusing read at time. His strict adherence to a SQL standard can be also frustrating. Perhaps just once in a while it would be nice to see things in T-SQL or PL/SQL.
It can make for a frustrating and confusing read at time. His strict adherence to a SQL standard can be also frustrating. Perhaps just once in a while it would be nice to see things in T-SQL or PL/SQL.
Would you like to see more reviews about this item?
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
Superb SQL Book one of the best
I highly recommend this excellent book - I've read over 50 database books and this is in my top 5.
Mr Celko writes in a highly opinionated, slightly arrogant style, I can... Read more
Mr Celko writes in a highly opinionated, slightly arrogant style, I can... Read more
Published 7 months ago by Gary Clarke
Celko: Top man!
OK, so 2nd Ed. is somewhat out of date, but more than adequate for my needs (as an all-round smarty-pants rather than a SQL expert), especially for the asking price. Read more
Published on 10 Dec 2009 by Prometheus
Useful yet opinionated.
Large parts of this book are undoubtedly excellent as the author is intelligent. However, there are many parts where the author expresses opinion without understanding that life in... Read more
Published on 13 Nov 2006 by B. Prajapati
Makes you think...
I bought this book as it was mentioned on a couple of SQL users' websites/mailing lists.
I am relatively new to SQL (2yrs experience) and I found the book quite thought... Read more
Published on 19 Mar 2006 by I. Lewis
Impractical, but interesting tricks.
These are interesting techniques in SQL, that can be fun in the office. The problem is that in the real world manufacturers don't implement standard SQL and if you want Advanced... Read more
Published on 26 Jan 1999
Excellent book
Lots of examples of complicated/advanced SQL. Not for people who need to learn SQL.
Published on 29 April 1997
A lot of ideas, but little instruction
This book gives many tips for how to structure your database
and about the behavior of some SQL commands (much of which
is common sense anyway), but does
nothing... Read more
and about the behavior of some SQL commands (much of which
is common sense anyway), but does
nothing... Read more
Published on 1 Nov 1996
Listmania!
|
|
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
