Joe Celko's SQL for Smarties: Advanced SQL Programming (Google eBook)

Front Cover
Morgan Kaufmann, Jul 26, 2010 - Computers - 840 pages
4 Reviews
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.
  

What people are saying - Write a review

Review: Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition (The Morgan Kaufmann Series in Data Management Systems)

User Review  - Steven - Goodreads

You will learn a lot by reading this book if you have a basic grounding in SQL and are looking to stretch yourself to solving the most difficult SQL problems in a set-oriented way. Read full review

Review: Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems)

User Review  - Kevin - Goodreads

Good, but a bit over-rated. Some of the code in here is a bit obscure and most would probably have trouble finding use for it on everyday projects. Still neat, though. Read full review

Related books

Contents

body
1
2 Normalization
61
3 Numeric Data in SQL
101
4 Temporal Data Types in SQL
119
5 Character Data Types in SQL
169
Missing Data in SQL
185
7 Multiple Column Data Elements
201
8 Table Operations
211
20 Grouping Operations
425
21 Aggregate Functions
439
22 Auxiliary Tables
477
23 Statistics in SQL
509
24 Regions Runs Gaps Sequences and Series
549
25 Arrays in SQL
575
26 Set Operations
591
27 Subsets
605

9 Comparison or Theta Operators
235
10 Valued Predicates
241
11 CASE Expressions
247
12 LIKE Predicate
261
13 BETWEEN and OVERLAPS Predicates
273
14 The NOT IN Predicate
287
15 EXISTS Predicate
299
16 Quantified Subquery Predicates
309
17 The SELECT Statement
317
18 VIEWs Derived Tables Materialized Tables and Temporary Tables
369
19 Partitioning Data in Queries
401
28 Trees and Hierarchies in SQL
623
29 Temporal Queries
641
30 Graphs in SQL
681
31 OLAP in SQL
709
32 Transactions and Concurrency Control
719
33 Optimizing SQL
731
back matter
761
index
777
About the Author
810
Copyright

Common terms and phrases

Popular passages

Page i - Relational Databases: From Conceptual Analysis to Logical Design Terry Halpin Component Database Systems Edited by Klaus R. Dittrich and Andreas Geppert Managing Reference Data in Enterprise Databases: Binding Corporate Data to the Wider World Malcolm Chisholm Data Mining: Concepts and Techniques Jiawei Han and Micheline Kamber Understanding SQL and Java Together: A Guide to SQL], JDBC, and Related Technologies Jim Melton and Andrew Eisenberg Database: Principles, Programming, and Performance, Second...
Page ii - Edited by Francois Bancilhon, Claude Delobel, and Paris Kanellakis Database Transaction Models for Advanced Applications • Edited by Ahmed K. Elmagarmid A Guide to Developing Client/Server SQL Applications • Setrag Khoshafian, Arvola Chan, Anna Wong, and Harry KT Wong The Benchmark Handbook for Database and Transaction Processing Systems, Second Edition • Edited by Jim Gray Camelot and Avalon: A Distributed Transaction Facility • Edited by Jeffrey L. Eppinger, Lily B. Mummert, and Alfred...
Page ii - Technology Cynthia Maro Saracco Readings in Database Systems, Third Edition Edited by Michael Stonebraker and Joseph M. Hellerstein Understanding SQL's Stored Procedures: A Complete Guide to SQL/PSM Jim Melton Principles of Multimedia Database Systems VS Subrahmanian Principles of Database Query Processing for Advanced Applications Clement T. Yu and Weiyi Meng Advanced Database Systems Carlo Zaniolo, Stefano Ceri, Christos Faloutsos, Richard T. Snodgrass, VS Subrahmanian, and Roberto Zicari Principles...
Page ii - Management of Heterogeneous and Autonomous Database Systems, Edited by Ahmed Elmagarmid, Marek Rusinkiewicz, and Amit Sheth Object-Relational DBMSs: Tracking the Next Great Wave, Second Edition, Michael Stonebraker and Paul Brown, with Dorothy Moore A Complete Guide to DB2 Universal Database, Don Chamberlin Universal Database Management: A Guide to Object/Relational Technology, Cynthia Maro Saracco Readings in Database Systems, Third Edition, Edited by Michael Stonebraker and Joseph M.
Page i - Philippe Rigaux, Michel Scholl, and Agnes Voisard Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design Terry Halpin Component Database Systems Edited by Klaus R. Dittrich and Andreas Geppert Managing Reference Data in Enterprise Databases: Binding Corporate...

References to this book

All Book Search results »

References from web pages

avaxhome -> ebooks -> Joe Celko, «Joe Celko's SQL for Smarties ...
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 ...
avaxsphere.com/ ebooks/ 0123693799.html

Books24x7 Book Details - Joe Celko's SQL for Smarties: Advanced ...
Joe Celko's SQL for Smarties: Advanced SQL Programming, Third Edition. Publisher and Imprint: Morgan Kaufmann Publishers. Offering tips and techniques, ...
pd.acm.org/ b24x7_book_detail.cfm?isbn=9780123693792

Intelligent Enterprise Contributing Editor - Joe Celko
... and Answers (2006), Joe Celko's SQL for Smarties: Advanced SQL Programming (2005), and Joe Celko's Trees and Hierarchies in SQL for Smarties (2004). ...
www.intelligententerprise.com/ experts/ celko/

Joe Celko, Joe Celko's SQL for Smarties: Advanced SQL Programming ...
Download Free ebook:Joe Celko, Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition - Free chm, pdf ebooks rapidshare download, ...
www.ebookee.com/ Joe-Celko-Joe-Celko-s-SQL-for-Smarties-Advanced-SQL-Programming-Third-Edition_99791.html

book.store.bg - Joe Celko's SQL for Smarties: Advanced SQL ...
Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition (The Morgan Kaufmann Series in Data Management Systems) - Joe Celko ...
import.book.store.bg/ product/ id-0123693799/ joe-celko-39-s-sql-for-smarties-advanced-sql-programming-third-edition-40...

SQL
Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems). -1%. -0.21 £. since 7. Before 19.47 £ ...
www.mycompbookbee.co.uk/ cat801214.html

comcol.nl: sql algemeen, computerboeken, blad 2 van 4
Joe Celko's SQL for Smarties: Advanced SQL Programming, Third edition · Morgan Kaufmann Publishers, Inc. | 2005 | 808 blz. | Joe Celko ...
www.comcol.nl/ detail/ bxgds002.htm

Bookpool: Joe Celko's SQL for Smarties: Advanced SQL Programming ...
SUBJECTS NEW RELEASES BEST SELLERS PUBLISHERS PROMOTIONS BASKET ACCOUNT HELP LOG IN. Joe Celko's SQL for Smarties: Advanced SQL Programming, 3rd Edition ...
www.bookpool.com/ sm/ 0123693799

Book Detail: Joe Celko's SQL for Smarties: Advanced SQL ...
Joe Celko's SQL for Smarties: Advanced SQL Programming (3rd Edition). Customers who bought this, also bought:. Apache Security · IT Architecture Toolkit ...
www.bookware.com.au/ cgi-bin/ bookware/ 0123693799

Barnes & Noble.com - Books: Joe Celko's SQL for Smarties, by Joe ...
Joe Celko's SQL for Smarties: Advanced SQL Programming, Celko, Joe Celko, Paperback, The Morgan Kaufmann Series in Data Management Systems, REV, 3, Book, ...
search.barnesandnoble.com/ Joe-Celkos-SQL-for-Smarties/ Joe-Celko/ e/ 9780123693792

About the author (2010)

Industry Consultant

Bibliographic information