Joe Celko's SQL Puzzles and Answers, Second Edition (The Morgan Kaufmann Series in Data Management Systems)

4.17 avg rating
( 30 ratings by Goodreads )
 
9780123735966: Joe Celko's SQL Puzzles and Answers, Second Edition (The Morgan Kaufmann Series in Data Management Systems)

Joe Celko's SQL Puzzles and Answers, Second Edition, challenges you with his trickiest puzzles and then helps solve them with a variety of solutions and explanations.

Author Joe Celko demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but also help develop the mindset needed to solve the many difficult SQL puzzles you face every day. This updated edition features many new puzzles; dozens of new solutions to puzzles; and new chapters on temporal query puzzles and common misconceptions about SQL and RDBMS that leads to problems.

This book is recommended for database programmers with a good knowledge of SQL.

  • A great collection of tricky SQL puzzles with a variety of solutions and explanations
  • Uses the proven format of puzzles and solutions to provide a user-friendly, practical look into SQL programming problems - many of which will help users solve their own problems
  • New edition features: Many new puzzles added!, Dozens of new solutions to puzzles, and using features in SQL-99, Code is edited to conform to SQL STYLE rules, New chapter on temporal query puzzles, New chapter on common misconceptions about SQL and RDBMS that leads to problems

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

Book Description:

Joe Celko, the SQL programmer's guru, expands and updates his classic SQL puzzles book!

From the Back Cover:

Joe Celko has been writing columns for the computer trade press and championing database programming techniques and ANSI/ISO standards via his newsgroup activity for 20 years.

In this complete revision and expansion of his first SQL Puzzles book, he challenges you with his trickiest puzzles―and then helps solve them with a variety of solutions and explanations. Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but help develop the mindset needed to solve the many difficult SQL puzzles you face every day. Of course, part of the fun is to see whether or not you can write better solutions than Joe’s.

In addition to updating the solutions for SQL Style and SQL-99 (and beyond) standards, Joe has added many new puzzles, dozens of additional solutions, and new chapters.

·A great collection of tricky SQL puzzles with a variety of solutions and explanations.
·Joe uses the proven format of puzzles and solutions to provide a user-friendly, practical look into SQL programming problems--many of which will help users solve their own problems.
· New edition features:
o Many new puzzles added!
o Dozens of new solutions to puzzles, and using features in SQL-99
o Code is edited to conform to SQL STYLE rules
o New chapter on temporal query puzzles
o New chapter on common misconceptions about SQL and RDBMS that leads to problems.

Joe Celko is a noted consultant, lecturer, teacher, and one of the most-read SQL authors in the world. He is well known for his ten years of service on the ANSI SQL standards committee, his dependable help on assorted SQL newsgroups, his column in Intelligent Enterprise (which won several Reader’s Choice Awards), and the war stories he tells to provide real-world insights into SQL programming. His best-selling books include Joe Celko’s SQL for Smarties: Advanced SQL Programming, Joe Celko’s SQL Puzzles and Answers, Joe Celko’s Trees and Hierarchies in SQL for Smarties, and Joe Celko’s SQL Style, all published by Morgan Kaufmann.

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

Top Search Results from the AbeBooks Marketplace

1.

Joe Celko
Published by ELSEVIER SCIENCE TECHNOLOGY, United States (2006)
ISBN 10: 0123735963 ISBN 13: 9780123735966
New Paperback Quantity Available: 10
Seller
Book Depository hard to find
(London, United Kingdom)
Rating
[?]

Book Description ELSEVIER SCIENCE TECHNOLOGY, United States, 2006. Paperback. Book Condition: New. 2nd Revised edition. Language: English . This book usually ship within 10-15 business days and we will endeavor to dispatch orders quicker than this where possible. Brand New Book. Joe Celko s SQL Puzzles and Answers, Second Edition, challenges you with his trickiest puzzles and then helps solve them with a variety of solutions and explanations. Author Joe Celko demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but also help develop the mindset needed to solve the many difficult SQL puzzles you face every day. This updated edition features many new puzzles; dozens of new solutions to puzzles; and new chapters on temporal query puzzles and common misconceptions about SQL and RDBMS that leads to problems. This book is recommended for database programmers with a good knowledge of SQL. Bookseller Inventory # EOD9780123735966

More Information About This Seller | Ask Bookseller a Question

Buy New
38.98
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

2.

Joe Celko
Published by Elsevier Science 2006-10-09, Amsterdam |London (2006)
ISBN 10: 0123735963 ISBN 13: 9780123735966
New paperback Quantity Available: 10
Seller
Blackwell's
(Oxford, OX, United Kingdom)
Rating
[?]

Book Description Elsevier Science 2006-10-09, Amsterdam |London, 2006. paperback. Book Condition: New. Bookseller Inventory # 9780123735966

More Information About This Seller | Ask Bookseller a Question

Buy New
38.99
Convert Currency

Add to Basket

Shipping: 3
From United Kingdom to U.S.A.
Destination, Rates & Speeds

3.

Joe Celko
ISBN 10: 0123735963 ISBN 13: 9780123735966
New Quantity Available: 1
Seller
Speedy Hen LLC
(Sunrise, FL, U.S.A.)
Rating
[?]

Book Description Book Condition: New. Bookseller Inventory # ST0123735963. Bookseller Inventory # ST0123735963

More Information About This Seller | Ask Bookseller a Question

Buy New
46.19
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

4.

Joe Celko
Published by ELSEVIER SCIENCE TECHNOLOGY, United States (2006)
ISBN 10: 0123735963 ISBN 13: 9780123735966
New Paperback Quantity Available: 10
Print on Demand
Seller
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description ELSEVIER SCIENCE TECHNOLOGY, United States, 2006. Paperback. Book Condition: New. 2nd Revised edition. Language: English . Brand New Book ***** Print on Demand *****.Joe Celko s SQL Puzzles and Answers, Second Edition, challenges you with his trickiest puzzles and then helps solve them with a variety of solutions and explanations. Author Joe Celko demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but also help develop the mindset needed to solve the many difficult SQL puzzles you face every day. This updated edition features many new puzzles; dozens of new solutions to puzzles; and new chapters on temporal query puzzles and common misconceptions about SQL and RDBMS that leads to problems. This book is recommended for database programmers with a good knowledge of SQL. Bookseller Inventory # AAV9780123735966

More Information About This Seller | Ask Bookseller a Question

Buy New
46.61
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

5.

Joe Celko
Published by Elsevier Science & Technology
ISBN 10: 0123735963 ISBN 13: 9780123735966
New Paperback Quantity Available: 1
Seller
THE SAINT BOOKSTORE
(Southport, United Kingdom)
Rating
[?]

Book Description Elsevier Science & Technology. Paperback. Book Condition: new. BRAND NEW, Joe Celko's SQL Puzzles and Answers (2nd Revised edition), Joe Celko, In this complete revision and expansion of his first "SQL Puzzles book", Joe Celko challenges you with his trickiest puzzles - and then helps solve them with a variety of solutions and explanations. Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but help develop the mindset needed to solve the many difficult SQL puzzles you face every day. Of course, part of the fun is to see whether or not you can write better solutions than Joe's. This book presents a great collection of tricky SQL puzzles with a variety of solutions and explanations. It uses the proven format of puzzles and solutions to provide a user-friendly, practical look into SQL programming problems - many of which will help users solve their own problems. New edition features: Many new puzzles added; Dozens of new solutions to puzzles, and using features in SQL-99; Code is edited to conform to SQL STYLE rules; New chapter on temporal query puzzles; and, New chapter on common misconceptions about SQL and RDBMS that leads to problems. Bookseller Inventory # B9780123735966

More Information About This Seller | Ask Bookseller a Question

Buy New
40.62
Convert Currency

Add to Basket

Shipping: 6.94
From United Kingdom to U.S.A.
Destination, Rates & Speeds

6.

Joe Celko
Published by ELSEVIER SCIENCE TECHNOLOGY, United States (2006)
ISBN 10: 0123735963 ISBN 13: 9780123735966
New Paperback Quantity Available: 10
Print on Demand
Seller
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description ELSEVIER SCIENCE TECHNOLOGY, United States, 2006. Paperback. Book Condition: New. 2nd edition. Language: English . Brand New Book ***** Print on Demand *****. Joe Celko s SQL Puzzles and Answers, Second Edition, challenges you with his trickiest puzzles and then helps solve them with a variety of solutions and explanations. Author Joe Celko demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but also help develop the mindset needed to solve the many difficult SQL puzzles you face every day. This updated edition features many new puzzles; dozens of new solutions to puzzles; and new chapters on temporal query puzzles and common misconceptions about SQL and RDBMS that leads to problems. This book is recommended for database programmers with a good knowledge of SQL. Bookseller Inventory # AAV9780123735966

More Information About This Seller | Ask Bookseller a Question

Buy New
48
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

7.

Celko
Published by Morgan Kaufmann Publishers Inc. (2016)
ISBN 10: 0123735963 ISBN 13: 9780123735966
New Paperback Quantity Available: 1
Print on Demand
Seller
Ria Christie Collections
(Uxbridge, United Kingdom)
Rating
[?]

Book Description Morgan Kaufmann Publishers Inc., 2016. Paperback. Book Condition: New. PRINT ON DEMAND Book; New; Publication Year 2016; Not Signed; Fast Shipping from the UK. No. book. Bookseller Inventory # ria9780123735966_lsuk

More Information About This Seller | Ask Bookseller a Question

Buy New
45.16
Convert Currency

Add to Basket

Shipping: 3.87
From United Kingdom to U.S.A.
Destination, Rates & Speeds

8.

Joe Celko
ISBN 10: 0123735963 ISBN 13: 9780123735966
New Paperback Quantity Available: 1
Seller
Ria Christie Collections
(Uxbridge, United Kingdom)
Rating
[?]

Book Description Paperback. Book Condition: New. Not Signed; Joe Celko's SQL Puzzles and Answers, Second Edition, challenges you with his trickiest puzzles and then helps solve them with a variety of solutions and explanations. Author Joe Celko demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced. book. Bookseller Inventory # ria9780123735966_rkm

More Information About This Seller | Ask Bookseller a Question

Buy New
46.28
Convert Currency

Add to Basket

Shipping: 3.87
From United Kingdom to U.S.A.
Destination, Rates & Speeds

9.

Celko, Joe
Published by Elsevier Science & Technology (2006)
ISBN 10: 0123735963 ISBN 13: 9780123735966
New Softcover Quantity Available: 1
Rating
[?]

Book Description Elsevier Science & Technology, 2006. Book Condition: New. 2006. 2nd Edition. Paperback. . . . . . . Bookseller Inventory # V9780123735966

More Information About This Seller | Ask Bookseller a Question

Buy New
50.49
Convert Currency

Add to Basket

Shipping: FREE
From Ireland to U.S.A.
Destination, Rates & Speeds

10.

Celko, Joe
Published by Elsevier Science and Technology (2006)
ISBN 10: 0123735963 ISBN 13: 9780123735966
New Quantity Available: > 20
Print on Demand
Seller
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description Elsevier Science and Technology, 2006. PAP. Book Condition: New. New Book. Delivered from our UK warehouse in 3 to 5 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Bookseller Inventory # LQ-9780123735966

More Information About This Seller | Ask Bookseller a Question

Buy New
41.83
Convert Currency

Add to Basket

Shipping: 9.01
From United Kingdom to U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book