Funds raised for literacy & libraries: $ 11,024,751.00

Books reused or recycled: 70,691,172

Great Prices on new and used books

FREE Shipping Worldwide.

Home
Textbooks
Popular Categories
Shop from Work Sale
- Get Productive. Save Now!
Textbooks
- Up to 90% OFF!
Other Merchandise
Connect

From the Blog

WE’RE LOOKING FOR THE TOP CHEF, AMERICA’S NEXT TOP MODEL, SO YOU THINK YOU CAN DANCE WINNER OF LIBRARIES!

That’s right folks, our 2nd Annual LEAP for Libraries Grant Application is NOW OPEN and we’re searching for today’s library program game-changers....

READ MORE
Games
SALE
Donate
Sell Textbooks

Home/
General
/
Database Management
/
Computer Books & Technology
/ Joe Celko's SQL for Smarties

Joe Celko's SQL for Smarties: Advanced SQL Programming

View larger image

Joe Celko's SQL for Smarties (Morgan Kaufmann Series in Data Management Systems)

Advanced SQL Programming (Paperback)♥ Add to Wishlist

by Joe Celko

ShareThis

USED: $38.35

Shipped from other seller

NEW: $68.56

Shipped from other seller

About the Book

All Available Copies

> Find at your local library

Other Sellers

Shipments from other sellers will have different delivery time frames. To see what those are click here.

CONDITION SELLER PRICE SHIPPING PURCHASE

Used Good(3 Copies): Good

BOOKDEALZ
GA, USA

$38.35

FREE

Used Good(1 Copy): Good 0123693799 Used, in good condition. Book only. May have interior marginalia or previous owner's name.

Crashing Rocks Bookstore
FL, USA

$43.50

FREE

New: BRAND NEW PAPERBACK 9.25 by 7.52 inches. This book is printed on demand. (allow 1-2 weeks for printing)(840 pages) sql for smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced sql programmer into an expert. now, 10 years later and in the third edition, this classic still reigns supreme as the book written by an sql master that teaches future sql masters. these are not just tips and techniques, joe also offers the best solutions to old and new challenges and conveys the way you need to think in order to get the most out of sql programming efforts for both correctness and performance. in the third edition, joe features new examples and updates to sql-99, expanded sections of query techniques, and a new section on schema design, with the same war-story teaching style that made the first and second editions of this book classics * expert advice from a noted sql authority and award-winning columnist, who has given ten years of service to the ansi sql standards committee and many more years of dependable help to readers of online forums. * teaches scores of advanced techniques that can be used with any product, in any sql environment, whether it is an sql-92 or sql-99 environment. * offers tips for working around system deficiencies. * continues to use war stories--updated--that give insights into real-world sql programming challenges. part i: data relational model basics keys and uniqueness, normalization practical hints for normalization, practical hints for denormalization, encoding and scales implementations, generator functions part ii: ddl (data declaration language)part iii: dml (data manipulation language) 1. numeric data in sql 2. temporal datatypes in sql 3. character datatypes in sql 4. other expressions 5. table operations 6. insert into statement 7. the update statement 8. comparison or theta operators 9. valued predicates 10. like and similar to predicates 11. between and overlaps predicates 12. the not in predicate 13. not exists() predicate 14. quantified subquery predicate 15. the simple select statement 16. outer joins 17. old versus new join syntax 18. bin packing 19. views 20. temporary tables 21. partitioning data 22. grouping operations 23. aggregate functions 24. other aggregate functions 25. auxiliary tables 26. statistics in sql 27. regions, runs, gaps, sequences and series 28. array structures in sql 29. set operations 30. subsets 31. trees in sql 32. graphs in sql 33. optimizing code this book is a classic, and this revision will merely solidify its position. --rudy limeback biographicalnote: joe celko served 10 years on ansi/iso sql standards committee and contributed to the sql-89 and sql-92 standards. he has written over 900 columns in the computer trade and academic press, mostly dealing with data and databases. joe has authored eight books on sql for morgan kaufmann. audiencedescription: working sql programmers, including those application developers, database analysts, and others who want to pick up some advanced programming tips and techniques, and also those who are developing new features for dbmss who want to know about users' ideas and needs. (Paperback)

StratfordBooks
Warks, GBR

$68.56

FREE

New: New in new dust jacket. US Edition Book In Mint condition. Shipping with Trackable Method.

Super_Textbook
TX, USA

$74.12

FREE

New: "SQL for Smarties" was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL masters. These are not just tips and techniques; Joe also offers the best solutions to old and new challenges and conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. In the third edition, Joe features new examples and updates to SQL-99, expanded sections of Query techniques, and a new section on schema design, with the same war-story teaching style that made the first and second editions of this book classics. * Expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums. * Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL-92 or SQL-99 environment. * Offers tips for working around system deficiencies. * Continues to use war stories— updated! — that give insights into real-world SQL programming challenges. ISBN10: 0123693799.

BOOKS_DOWN_UNDER
NSW, AUS

$127.79

FREE

New: New

More Books
FL, USA

$148.61

FREE

New: New Great customer service. You will be happy!

booklab
NY, USA

$155.96

FREE

New: Format: Paperback. Brand New, Perfect Condition. May Ship From Overseas, Allow Additional Delivery Time.

Papa Media
NY, USA

$214.70

FREE

Used Very Good(1 Copy): Very Good 0123693799 Covers have slight wear, pages are clean, tight and bright! Overall in Great Condition!

M3Books
MA, USA

$253.75

FREE

About the Book

"SQL for Smarties" was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL masters. These are not just tips and techniques; Joe also offers the best solutions to old and new challenges and conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance.
In the third edition, Joe features new examples and updates to SQL-99, expanded sections of Query techniques, and a new section on schema design, with the same war-story teaching style that made the first and second editions of this book classics.
* Expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums.
* Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL-92 or SQL-99 environment.
* Offers tips for working around system deficiencies.
* Continues to use war stories--updated --that give insights into real-world SQL programming challenges.

Product Details

Media: Paperback Book, 840 pages

Language: English

Publisher: Morgan Kaufmann Publishers (Aug. 31st, 2005)

ISBN-10: 0123693799

ISBN-13: 9780123693792

Dimensions: 7.46 x 9.00 x 1.80 inches

Shipping Weight: 3.69 lbs

Categories: General Database Management

USED: $38.35

Shipped from other seller

NEW: $68.56

Shipped from other seller

Be Twice as Productive!

Get 2 books for $5 and each additional book for only $2.50. Shop and Save Now »

Book for Book™

We match every book you purchase with a book donation. Learn more

Great Prices on new and used books

From the Blog

Joe Celko's SQL for Smarties (Morgan Kaufmann Series in Data Management Systems)

About the Book

All Available Copies

About the Book

Product Details

Customer Reviews

Better World Books

Customer Service

Gift Certificates

Shipping & Payment

Our Programs

Literacy Partners

Great Prices on new and used books

From the Blog

Joe Celko's SQL for Smarties (Morgan Kaufmann Series in Data Management Systems)

About the Book

All Available Copies

About the Book

Product Details

Customer Reviews

Better World Books

Customer Service

Gift Certificates

Shipping & Payment

Our Programs

Our Newsletter

Literacy Partners