Joe Celko's SQL for Smarties: Advanced SQL Programming Second Edition

by Joe Celko

Book Overview

SQL for Smarties

was hailed as the first book devoted explicitly to the advanced techniques you need to transform yourself into an expert SQL programmer. Now, in this fully updated second edition, SQL mastermind Joe Celko keeps you moving forward, using his entertaining, conversational style to teach you the best solutions to old and new challenges and to convey the way you need to think if you really want to get the most out...

• Format: Paperback
• Language: English
• ISBN: 1558605762
• ISBN13: 9781558605763
• Release Date: October 1999
• Publisher: Morgan Kaufmann Publishers
• Length: 550 Pages
• Weight: 2.05 lbs.
• Dimensions: 1.4" x 7.0" x 9.0"

Customer Reviews

Great book

Joe Celko knows SQL. He may make some typos as a writer but make no mistake... this guy knows what he's talking about. He knows the language and the mechanics of the major database engines. But more importantly, he understands the logic of it all. Some of his SQL moves are simply brilliant.I develop enterprise applications and am called upon now and then to create some very challenging SQL. Celko has bailed me out several times. I have the book as a reference source right next to my database reference manuals. He is full of ideas and often times I am looking for an idea, not a recipe.This is a book for people who have a good knowledge of SQL. It will stimulate your thinking and programming. It isn't a book for beginners. In the right hands, SQL for Smarties will really add some sizzle to your SQL coding.Brianne Elizabeth Corbett - IBM Global Services

Exceptional quality in a computer manual

I cannot work without this book. Stuck with a poor database structure and huge volumes of data, I have had to explore every trick of the trade. Few computer books in general provide information that is accurate, helpful, and not repetitive of manuals and online material that is already available to you. This book is of exceptional value. Someone swiped mine and believe me, I must have another copy. How many of the computer books you have purchased get that kind of respect?Warning: Beginners may need another book and it is not a replacement for your SQL vendor specific reference.

excellent advanced SQL book

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.

new edition of a classic <g>

This is a new edition which expands the programming tips from the first edition and removes the theoretical content (theory is now covered in DATA & DATABASES).

Advanced SQL Programming!!!!

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.