Stock Image

Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann series in data management systems)

Joe Celko

157 ratings by Goodreads
ISBN 10: 1558603239 / ISBN 13: 9781558603233
Published by Morgan Kaufmann Pub, 1995
Used Condition: Good
From Better World Books: West (Reno, NV, U.S.A.)

AbeBooks Seller Since March 14, 2016

Quantity Available: 1

About this Item

Ships from Reno, NV. Shows some signs of wear, and may have some markings on the inside. Bookseller Inventory # GRP87371611

Ask Seller a Question

Bibliographic Details

Title: Joe Celko's SQL for Smarties: Advanced SQL ...

Publisher: Morgan Kaufmann Pub

Publication Date: 1995

Book Condition:Good

About this title

Synopsis:

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.

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 nevertheless alludes to theory often 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 issues.

The book uses ANSI SQL-89 as its baseline standard, with some mention of SQL-92 features. It does not, however, focus on any commercial product; this guide zeroes in on the SQL language. Celko covers all aspects of database design, optimization, and manipulation, with easy-to-understand explanations of key issues such as why not to use too many nulls, how to use practical normalization, and how to optimize 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 normalization, SQL data types, querying, grouping, set operations, optimization, data scaling, and encoding.

"About this title" may belong to another edition of this title.

Store Description

Visit Seller's Storefront

Terms of Sale:

Better World Books is proud to deliver not only great books, but also quality
customer service. If you are not satisfied with your order, please do not
hesitate to contact us. Abebooks will provide you with our contact information
after you place your order. We will get back to you as soon as possible to
resolve any order issues to your satisfaction.

Every purchase you make from BWB benefits one of our world literacy partners. To
date, Better World Books has pledged over $1,000,000 to literacy p...

More Information
Shipping Terms:

All orders ship out within 1-2 business days. Over 2 million satisfied customers and growing!

List this Seller's Books

Payment Methods
accepted by seller

Visa Mastercard American Express