- Jubilee offer: spend £10 or more on any product sold by Amazon.co.uk on or before June 6 and you can buy The Diamond Jubilee A Classical Celebration Album for just £2.50 Here's how (terms and conditions apply)
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:
|
Special Offers and Product Promotions
Frequently Bought Together
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.
--This text refers to an out of print or unavailable edition of this title.
Review
"This book is a classic, and this revision will merely solidify its position." --Rudy Limeback
Inside This Book
(Learn More)
First Sentence
The major problem in learning SQL is that programmers are used to thinking in terms of files rather than tables. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index
The major problem in learning SQL is that programmers are used to thinking in terms of files rather than tables. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
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.
|
