- Paperback: 467 pages
- Publisher: Morgan Kaufmann Publishers In (July 1995)
- Language: English
- ISBN-10: 1558603239
- ISBN-13: 978-1558603233
- Product Dimensions: 2.5 x 18.4 x 23.5 cm
- Average Customer Review: 3.7 out of 5 stars See all reviews (11 customer reviews)
- Amazon Bestsellers Rank: 1,666,760 in Books (See Top 100 in Books)
- See Complete Table of Contents
Joe Celko's SQL for Smarties: Advanced SQL Programming Paperback – 1 Jul 1995
There is a newer edition of this item:
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
If you are a seller for this product, would you like to suggest updates through seller support?
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
Database design and normalisation, SQL data types, querying, grouping, set operations, optimisation, data scaling and encoding.
Top Customer Reviews
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.
I am relatively new to SQL (2yrs experience) and I found the book quite thought provoking and very positive because some of the techniques outlined by Joe Celko are new to me. However it was very positive to see that some things I had already tried were in the book.
Well presented, logical in approach and quite an entertaining read considering SQL is such a dry subject.
and about the behavior of some SQL commands (much of which
is common sense anyway), but does
nothing to help the reader actually learn the language.
Examples are scarce and many of them are C code rather than SQL.
I was very disappointed with this book and must continue my
search for an SQL textbook.
Most Recent Customer Reviews
I had to swipe backwards and forwards between pages to get to see complete SQL code that spanned pages. A couple of times sentences were repeated. Read morePublished 12 months ago by Phil Meadway
Excellent contents, but marred slightly by sloppy editing. Quite a surprise that such errors would be so prevalent in the fifth edition of a book, but the exhaustive information... Read morePublished 13 months ago by Chris Wareham
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 morePublished on 13 Nov. 2006 by B. Prajapati