Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Tell the Publisher!
Id like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Joe Celko's SQL for Smarties: Advanced SQL Programming [Paperback]

Joe Celko
3.5 out of 5 stars  See all reviews (4 customer reviews)

Available from these sellers.


Formats

Amazon Price New from Used from
Paperback --  
There is a newer edition of this item:
Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems) Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems) 4.2 out of 5 stars (5)
30.74
In stock.

Book Description

July 1995 1558603239 978-1558603233
Get the most from your database applications through clever SQL programming Joe Celko shares his most useful tips and tricks for advanced SQL programming to help the working programmer gain performance and work around system deficiencies. Addressing real problems that people building real applications face, Joe provides new and creative solutions. A noted consultant, lecturer, and columnist for DBMS and Database Programming & Design magazines, Joe uses entertaining anecdotes and "war stories" to provide real-world insight into SQL programming and warn about potential problems. Become an expert programmer This is the first advanced SQL book available that provides a comprehensive presentation of the techniques necessary to help you progress from a casual user of SQL to an expert programmer. Joe uses an informal, conversational writing style to explain why a particular trick works, so the working programmer can apply it directly to his or her own programming needs. Relying primarily on the SQL-89 features that are now supported by commercial RDBMSs, he also includes an extensive discussion of SQL-92, with information on how it's being implemented in current and future database products. The tips and techniques presented here are not product specific, so they allow programmers to maximize any system's performance.

Product details

  • 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.5 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Bestsellers Rank: 1,494,072 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

Amazon 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.


Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

Most Helpful Customer Reviews
4 of 4 people found the following review helpful
By A Customer
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.
Comment | 
Was this review helpful to you?
5 of 6 people found the following review helpful
4.0 out of 5 stars Excellent book 29 April 1997
By A Customer
Format:Paperback
Lots of examples of complicated/advanced SQL. Not for people who need to learn SQL.
Comment | 
Was this review helpful to you?
2 of 9 people found the following review helpful
3.0 out of 5 stars Impractical, but interesting tricks. 26 Jan 1999
By A Customer
Format:Paperback
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 SQL then it needs to be specialised. His SQL tricks book is more fun.
Comment | 
Was this review helpful to you?
2 of 14 people found the following review helpful
2.0 out of 5 stars A lot of ideas, but little instruction 1 Nov 1996
By A Customer
Format:Paperback
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 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.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 3.9 out of 5 stars  14 reviews
31 of 32 people found the following review helpful
5.0 out of 5 stars Advanced SQL Programming!!!! 19 Feb 1999
By A Customer - Published on Amazon.com
Format:Paperback
I have been programming database applications since 1984. I started using SQL in 1989. Since that time, I thought I had mastered SQL. Well ... I was wrong. Joe's book helps pin point the finer things concerning SQL ... how it really works. Anyone who is an ADVANCED user of SQL will find this book full of the little things that all most all developers will overlook. For example, how does a SQL statement really execute (pg 174 to 181) explains this in great detail. Many advanced developers are not just satisfied with knowing how to do something; but, want to know every little detail about how something really works. I found the chapters on normalization and Armstrong's Axioms to be the most useful concept in the entire book. Database design concepts are critical in performing a good, solid, and efficient query and this chapter brings it out very well. I have found this book to be my only source for advanced SQL concepts (besides Joe's puzzle book...). Good job ... and thanks.
6 of 6 people found the following review helpful
5.0 out of 5 stars excellent advanced SQL book 12 May 1999
By A Customer - Published on Amazon.com
Format:Paperback
If you are conversant with SQL, this is a great book to buy. This book has all kinds of advice for finessing SQL for power users. It is the only advanced SQL book of which I am aware.
5 of 5 people found the following review helpful
5.0 out of 5 stars A great SQL reference guide the experienced sql user 29 Nov 1997
By A Customer - Published on Amazon.com
Format:Paperback
Being a professional Database Administrator using Ingres, I wanted a good SQL reference book and I found it. This book does not teach you SQL it is designed for those who are already familiar with basic conventions; what it does do is to highlight areas where you could improve the efficiency of the code you write. This resides on my desk permanently and should be treated as a reference bible rather than a tutorial. The gems it contains cannot be absorded at first reading...you will refer to it again and again. A fine book and a great buy.
14 of 18 people found the following review helpful
2.0 out of 5 stars typos typos typos & sloppy explanations 11 Sep 2003
By Ken Braithwaite - Published on Amazon.com
Format:Paperback|Verified Purchase
There is a lot here, some of it quite advanced and quite good. But well over half the examples I looked at had errors -- typos often, or repeated chunks of text. This made the examples pretty much worthless.
His prose explanations are often very unclear indeed.
5 of 6 people found the following review helpful
5.0 out of 5 stars A must have... 8 Aug 1999
By A Customer - Published on Amazon.com
Format:Paperback
Joe Celko is a very interesting author. His approach to teaching by using puzzles gets the mind thinking. He does not keep you guessing too long. I like his sense of humor as well.
I consider this book a must-have for all Database Administrators and developers...
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback