Joe Celko's SQL for Smarties: Advanced SQL Programming

200 ratings by Goodreads

Language: English

Published by Morgan Kaufmann, 2014

0128007613 / 9780128007617

Series: Book 51 of 52 - The Morgan Kaufmann Series in Data Management Systems

  • Softcover
  • Used
See all details

Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.World of Books (was SecondSale)

5-star seller

AbeBooks seller since December 20, 2007

Softcover

Condition: Used - Good

£ 22.90

 Free Shipping 
Ships within U.S.A.

Quantity: 1 available

Add to basket
Free 30-day returns

Item description from seller

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.…

Title
Joe Celko's SQL for Smarties: Advanced SQL Programming
Author
Joe Celko
Publisher
Morgan Kaufmann
Publication year
2014
Condition
Good
Binding
Paperback
Language
English
ISBN 10
0128007613
ISBN 13
9780128007617
Edition
5th or later Edition
Series
Book 51 of 52: The Morgan Kaufmann Series in Data Management Systems

World of Books (was SecondSale)

Montgomery, IL, U.S.A.

5-star seller

AbeBooks seller since December 20, 2007

Shipping rates within U.S.A.

Item4 to 12 business days3 to 6 business days
First item£ 0.00£ 8.29
Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.

Payment methods

  • Visa
  • Mastercard
  • American Express
  • Apple Pay
  • Google Pay

Store description

Founded in 2002, World of Books is a leading online destination for buying and selling both preloved and new books, committed to making sustainable reading accessible to all. With a mission to help people read more and waste less, World of Books offers a huge range of affordable, high-quality books — giving both new and preloved titles a second life. The company also operates World of Books – Sell Your Books, an easy-to-use platform that allows customers to trade in unwanted books for cash, helping to keep books in circulation while promoting sustainability. As a Certified B Corp, World of Books is driven by a vision to become the world’s largest and most sustainable dedicated online bookstore. The company measures its success through the positive environmental impact it creates, the value it provides to customers, and its ability to operate profitably while supporting its sustainable mission …

Seller's business information

SBYB, Inc.

900 Knell Rd
Montgomery, IL U.S.A. 60538