The item you selected has ended, but we found something similar.

Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition [The Morgan - Picture 1 of 1

The Morgan Kaufmann Series in Data Management Systems Ser.: Joe Celko's SQL for Smarties : Advanced SQL Programming by Joe Celko (2005, Trade Paperback, Revised edition)

Be the first towrite a review.

Shakespeare Book House (5302)
98.3% positive feedback

Price:

$55.59

ApproximatelyAU $85.05

Free shipping

Estimated delivery Wed, May 8 - Fri, May 10

Returns:

30 days returns. Buyer pays for return shipping.

Condition:

Brand New

The item is Brand New!

About this product

Product Information

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 Identifiers

Publisher
Elsevier Science & Technology
ISBN-10
0123693799
ISBN-13
9780123693792
eBay Product ID (ePID)
46883567

Product Key Features

Author
Joe Celko
Publication Name
Joe Celko's Sql for Smarties : Advanced Sql Programming
Format
Trade Paperback
Language
English
Features
Revised
Series
The Morgan Kaufmann Series in Data Management Systems Ser.
Publication Year
2005
Type
Textbook
Number of Pages
840 Pages

Dimensions

Item Length
9.2in
Item Width
7.5in

Additional Product Features

Lc Classification Number
Qa76.73.S67
Edition Description
Revised Edition
Edition Number
3
Reviews
"This book is a classic, and this revision will merely solidify its position." --Rudy Limeback SQL for Smarties is a well-known and highly regarded text in the industry and a new edition of the book will be sought by database practitioners regardless of the DBMS they use. --Craig Mullins, BMC Software
Table of Content
Chapter 1: Database Design Chapter 2: Normalization Chapter 3: Numeric Data in SQL Chapter 4: Temporal Data Types in SQL Chapter 5: Character Data Types in SQL Chapter 6: NULLs Chapter 7: Multiple Column Data Elements Chapter 8: Table Operations Chapter 9: Comparison or Theta Operators Chapter 10: Valued Predicates Chapter 11: CASE Expressions Chapter 12: LIKE Predicate Chapter 13: Between and Overlaps Predicates Chapter 14: The [NOT] IN() predicate Chapter 15: EXISTS() predicate Chapter 16: Quantified Subquery Predicates Chapter 17: The SELECT Statement Chapter 18: VIEWs, Derived Tables, Materialized Tables, and Temporary Tables Chapter 19: Partitioning Data in Queries Chapter 20: Grouping Operations Chapter 21: Aggregate Functions Chapter 22: Auxiliary Tables Chapter 23: Statistics in SQL Chapter 24: Regions, Runs, Gaps, Sequences, and Series Chapter 25: Arrays in SQL Chapter 26: Set Operations Chapter 27: Subsets Chapter 28: Trees and Hierarchies in SQL Chapter 29: Temporal Queries Chapter 30: Graphs in SQL Chapter 31: OLAP in SQL Chapter 32: Transactions and Concurrency Control Chapter 33: Optimizing SQL References General References Logic Mathematical Techniques Random Numbers Scales and Measurements Missing Values Regular Expressions Graph Theory Introductory SQL Books Optimizing Queries Temporal Data and the Year 2000 Problem SQL Programming Techniques Classics Forum Updatable VIEWs Theory, Normalization, and Advanced Database Topics Books on SQL-92 and SQL-99 Standards and Related Groups Web Sites Related to SQL Statistics Temporal Databases Index About the Author
Copyright Date
2005
Target Audience
Scholarly & Professional
Topic
Programming / General, User Interfaces, Programming Languages / Sql, Databases / General
Lccn
2005-279919
Dewey Decimal
005.13/3
Dewey Edition
22
Illustrated
Yes
Genre
Computers

All listings for this product

item 1 Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition (The - GOOD
$6.55
Free shipping
item 2 Joe Celko's SQL for Smarties : Advanced SQL Programming Paperback
$6.69
Free shipping
item 3 Joe Celko's SQL for Smarties : Advanced SQL Programming Paperback
$6.69
Free shipping
item 4 Joe Celko's SQL for Smarties : Advanced SQL Programming Paperback
$6.69
Free shipping
item 5 Joe Celko's SQL for Smarties: Advanced SQL Programming by Celko, Joe
$6.78
Free shipping
item 6 Joe Celko's SQL for Smarties: Advanced SQL Programming by Celko, Joe
$7.25
Free shipping
item 7 Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition (The Mo...
$7.57
Free shipping

See all 14

Best Selling in Textbooks

See all

Current slide {CURRENT_SLIDE} of {TOTAL_SLIDES}- Best Selling in Textbooks

Desk Reference to the Diagnostic Criteria from DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)
5.0 out of 5 stars based on 7 product ratings
$7.50 New
---- Used
Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)
4.6 out of 5 stars based on 15 product ratings
$35.70 New
$34.00 Used
Self Heal by Design : The Role of Micro-organisms for Health by Barbara O'Neill (2018, Trade Paperback)
5.0 out of 5 stars based on 14 product ratings
$29.99 New
---- Used
Leadership : Theory and Practice by Peter G. Northouse (2021, Trade Paperback, Revised edition)
5.0 out of 5 stars based on 1 product rating
$19.98 New
$10.00 Used
Research Design : Qualitative, Quantitative, and Mixed Methods Approaches by J. David Creswell and John W. Creswell (2022, Trade Paperback)
4.2 out of 5 stars based on 5 product ratings
$21.00 New
$18.00 Used
PMBOK® Guide Ser.: Guide to the Project Management Body of Knowledge (PMBOK Guide) and the Standard for Project Management by Project Management Institute (2021, Trade Paperback)
4.9 out of 5 stars based on 7 product ratings
$18.69 New
$13.00 Used
Diagnostic and Statistical Manual of Mental Disorders : DSM-5-TR by American Psychiatric Association (2022, Hardcover)
4.9 out of 5 stars based on 8 product ratings
$41.45 New
$38.99 Used

Save on Textbooks

Current slide {CURRENT_SLIDE} of {TOTAL_SLIDES}- Save on Textbooks

Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR Free Shipping
$37.99
Trending at $42.75
PMBOK A Guide to the Project Management Body of Knowledge 7th edition (Pb) 📋
$17.99
Trending at $21.99
National Electrical Code Handbook, 2023 Edition
$62.99
Trending at $67.45
Designing Data-Intensive Applications : The Big Ideas Behind Reliable, Scalable,
$12.49
Trending at $18.95
New 2022 NFPA 72 National Fire Alarm and Signaling Code USA STOCK Free Shipping
$52.24
Trending at $56.50
The Pocket Guide to the DSM-5-TR Diagnostic Exam by Abraham M..........
$12.95
Trending at $13.10

Shop by category

The Morgan Kaufmann Series in Data Management Systems Ser.: Joe Celko's SQL for Smarties : Advanced SQL Programming by Joe Celko (2005, Trade Paperback, Revised edition)

About this product

Product Information

Product Identifiers

Product Key Features

Dimensions

Additional Product Features

All listings for this product

item 1 Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition (The - GOOD

item 2 Joe Celko's SQL for Smarties : Advanced SQL Programming Paperback

item 3 Joe Celko's SQL for Smarties : Advanced SQL Programming Paperback

item 4 Joe Celko's SQL for Smarties : Advanced SQL Programming Paperback

item 5 Joe Celko's SQL for Smarties: Advanced SQL Programming by Celko, Joe

item 6 Joe Celko's SQL for Smarties: Advanced SQL Programming by Celko, Joe

item 7 Joe Celko's SQL for Smarties: Advanced SQL Programming Third Edition (The Mo...

Best Selling in Textbooks

Desk Reference to the Diagnostic Criteria from DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)

Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR by American Psychiatric Association (2022, Trade Paperback)

Self Heal by Design : The Role of Micro-organisms for Health by Barbara O'Neill (2018, Trade Paperback)

Leadership : Theory and Practice by Peter G. Northouse (2021, Trade Paperback, Revised edition)

Research Design : Qualitative, Quantitative, and Mixed Methods Approaches by J. David Creswell and John W. Creswell (2022, Trade Paperback)

PMBOK® Guide Ser.: Guide to the Project Management Body of Knowledge (PMBOK Guide) and the Standard for Project Management by Project Management Institute (2021, Trade Paperback)

Diagnostic and Statistical Manual of Mental Disorders : DSM-5-TR by American Psychiatric Association (2022, Hardcover)

Save on Textbooks

Diagnostic and Statistical Manual of Mental Disorders DSM-5-TR Free Shipping

PMBOK A Guide to the Project Management Body of Knowledge 7th edition (Pb) 📋

National Electrical Code Handbook, 2023 Edition

Designing Data-Intensive Applications : The Big Ideas Behind Reliable, Scalable,

New 2022 NFPA 72 National Fire Alarm and Signaling Code USA STOCK Free Shipping

The Pocket Guide to the DSM-5-TR Diagnostic Exam by Abraham M..........

You may also like

Paperback Dictionaries Revised Edition

Atlas Paperbacks Revised Edition

Revised Edition Paperback Textbooks

Revision/Practice Study Paperbacks Prep Revised Edition

IT Study Paperbacks Prep Revised Edition

Paperback Language Course Revised Edition