Joe Celko's SQL for Smarties: Advanced SQL Programming PDF (Adobe DRM) download by Joe Celko

Joe Celko's SQL for Smarties: Advanced SQL Programming

Morgan Kaufmann
Publication date: December 2014
ISBN: 9780128008300
Digital Book format: PDF (Adobe DRM)

Buy PDF

List price:
$64.95
Our price:
$59.99

You save: $4.96 (8%)

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, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. New to the fifth edition, Joe features new examples to reflect the ANSI/ISO Standards so anyone can use it. He also updates data element names to meet new ISO-11179 rules with the same experience-based teaching style that made the previous editions the classics they are today. You will learn new ways to write common queries, such as finding coverings, partitions, runs in data, auctions and inventory, relational divisions and so forth. SQL for Smarties explains some of the principles of SQL programming as well as the code. A new chapter discusses design flaws in DDL, such as attribute splitting, non-normal forum redundancies and tibbling. There is a look at the traditional acid versus base transaction models, now popular in NoSQL products. You'll learn about computed columns and the DEFERRABLE options in constraints. An overview of the bi-temporal model is new to this edition and there is a longer discussion about descriptive statistic aggregate functions. The book finishes with an overview of SQL/PSM that is applicable to proprietary 4GL vendor extensions.



  • New to the 5th Edition:
    • Downloadable data sets, code samples, and vendor-specific implementations!
    • Overview of the bitemporal model
    • Extended coverage of descriptive statistic aggregate functions
    • New chapter covers flaws in DDL
    • Examination of traditional acid versus base transaction models
    • Reorganized to help you navigate related topics with ease
  • Expert advice from a noted SQL authority and award-winning columnist Joe Celko, who served on the ANSI SQL standards committee for over a decade
  • Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is SQL 92 or SQL 2011
  • Offers tips for working around deficiencies and gives insight into real-world challenges
Please sign in to review this product.
Format:
Devices:
Joe Celko's SQL for Smarties: Advanced SQL Programming PDF (Adobe DRM) can be read on any device that can open PDF (Adobe DRM) files.

File Size:
5791 Kb
Language:
ENG
Copy From Text:
Disabled.
Printing:
Disabled.
Joe Celko's SQL for Smarties: Advanced SQL Programming PDF (Adobe DRM) download by Joe Celko
Morgan Kaufmann, December 2014
ISBN: 9780128008300
EAN:  9780128008300
PDF (Adobe DRM)
List Price: $64.95 eBook price: $59.99
Joe Celko's SQL for Smarties: Advanced SQL Programming ePub (Adobe DRM) download by Joe Celko
Morgan Kaufmann, December 2014
ISBN: 9780128008300
EAN:  2370006351566
ePub (Adobe DRM)
List Price: $64.95 eBook price: $59.99
Other books by Joe Celko
Joe Celko's Complete Guide to NoSQL: What Every SQL Professional Needs to Know about Non-Relational Databases ePub (Adobe DRM) download by Joe Celko
Joe Celko's Complete Guide to NoSQL: What Every SQL Professional Needs to Know about Non-Relational Databases
Joe Celko
Morgan Kaufmann, October 2013
ISBN: 9780124071926
Format: ePub, PDF
List Price: $44.95 Our price: $41.99
Joe Celko's Trees and Hierarchies in SQL for Smarties ePub (Adobe DRM) download by Joe Celko
Joe Celko's Trees and Hierarchies in SQL for Smarties
Joe Celko
Morgan Kaufmann, January 2012
ISBN: 9780123877338
Format: ePub, PDF
List Price: $44.95 Our price: $39.99
Joe Celko's SQL for Smarties: Advanced SQL Programming ePub (Adobe DRM) download by Joe Celko
Joe Celko's SQL for Smarties
Joe Celko
Elsevier S&T, October 2010
ISBN: 9780123820228
Format: ePub, PDF
List Price: $64.95 Our price: $56.99
Joe Celko's Data, Measurements and Standards in SQL PDF (Adobe DRM) download by Joe Celko
Joe Celko's Data, Measurements and Standards in SQL
Joe Celko
Elsevier S&T, September 2009
ISBN: 9780123747228
Format: PDF, ePub
List Price: $52.95 Our price: $46.99