Joe Celko's SQL puzzles & answers

In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzlesand 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...

Πλήρης περιγραφή

Κύριος συγγραφέας: Celko, Joe.
Μορφή: Ηλεκτρονική πηγή
Γλώσσα: English
Στοιχεία έκδοσης: San Francisco, Calif. : Morgan Kaufmann Publishers, c2007.
Έκδοση: 2nd ed.
Σειρά: Morgan Kaufmann series in data management systems.
Θέματα:
Διαθέσιμο Online: http://www.sciencedirect.com/science/book/9780123735966
Ετικέτες: Προσθήκη ετικέτας
Δεν υπάρχουν, Καταχωρήστε ετικέτα πρώτοι!
Περίληψη: In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzlesand 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 Joes. * 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.
Περιγραφή τεκμηρίου: Includes index.
Φυσική περιγραφή: 1 online resource (xvii, 325 p.) : ill.
ISBN: 9780123735966
0123735963
9780080491684 (electronic bk.)
0080491685 (electronic bk.)
Πρόσβαση: License restrictions may limit access.