Joe Celko's SQL for Smarties: Advanced SQL Programming / Edition 4

Joe Celko's SQL for Smarties: Advanced SQL Programming / Edition 4

by Joe Celko
     
 

ISBN-10: 0123820227

ISBN-13: 9780123820228

Pub. Date: 10/29/2010

Publisher: Elsevier Science

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, 15 years later and in its fourth 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!

…  See more details below

Overview

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, 15 years later and in its fourth 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 fourth 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.

Product Details

ISBN-13:
9780123820228
Publisher:
Elsevier Science
Publication date:
10/29/2010
Series:
Morgan Kaufmann Series in Data Management Systems Series
Pages:
816
Sales rank:
1,139,960
Product dimensions:
7.50(w) x 9.20(h) x 1.50(d)

Table of Contents

Joe Celko's SQL for Smarties: Advanced SQL Programming
by Joe Celko
    Preface: README:JOE
    1. Introduction
      1.1 The Nature of the SQL Language
      1.2 Programming Tips

    2 Database Design
      2.1 Schema and Table Creation
        2.1.1 Schemas
        2.1.2 Manipulating Tables
          DROP TABLE
          ALTER TABLE
          CREATE TABLE
        2.1.3 Column Definitions
          The DEFAULTClause
          Column Constraints
          NOT NULL Constraint
          CHECK() Constraint
          UNIQUE and PRIMARY KEY Constraints
          REFERENCES Clause
      2.2 Normalization
        2.2.1 Functional and Multivalued Dependencies
        2.2.2 First Normal Form (INF)
          Note on Repeated Groups
        2.2.3 Second Normal Form (2NF)
        2.2.4 Third Normal Form (3NF)
          Boyce-Codd Normal Form
        2.2.5 CASE Tools for Normalization
        2.2.6 Boyce-Codd Normal Form (BCNF)
        2.2.7 Fourth Normal Form (4NF)
        2.2.8 Fifth Normal Form (5NF)
        2.2.9 Domain-Key Normal Form (DKNF)
        2.2.10 Practical Hints for Normalization
        2.2.11 Practical Hints for Denormalization

    3 Numeric Data in SQL
      3.1 Numeric Types
      3.2 Numeric type Conversion
        3.2.1 Rounding and Truncating
        3.2.2 CAST() Function
      3.3 Four-Function Math
      3.4 Arithmetic and NULLs
      3.5 Converting Values to and from NULL
        3.5.1 NULLIF() Function
        3.5.2 COALESCE()Function
      3.6 Vendor Math Functions

    4 Temporal Datatypes in SQL
      4.1 Tips for Handling Dates, Timestamps, and Times
        4.1.1 Handling Dates
        4.1.2 Handling Timestamps
        4.1.3 Handling Times
      4.2 Queries with Dates
        4.2.1 Calendars
        4.2.2 Gaps in a time Series
        4.2.3 Locating Dates
      4.3 Julian Dates
      4.4 DATE and TIME Functions

    5 Character Data in SQL
      5.1 Problems of String Equality
      5.2 Problems of String Ordering
      5.3 Common Vendor Extensions
      5.4 Phonetic Matching
        5.4.1 Soundex Functions
        5.4.2 The Original Soundex
        5.4.3 An Improved Soundex
        5.4.4 Metaphone
      5.5 Cutter Tables
      5.6 Standard String Functions
      5.7 Other Pattern-Matching Predicates
      5.8 Other String Functions

    6 NULLs-Missing Data in SQL
      6.1 Empty and Missing Tables
      6.2 Missing Values in Columns
      6.3 Context and Missing Values
      6.4 NULLs and Logic
      6.5 Comparing NULLs
      6.6 Math and NULLs
      6.7 Functions and NULLs
      6.8 NULLs and Host Languages
      6.9 Design Advice

    7 Other Schema Objects
      7.1 Schema Creation
        7.1.1 Schema Tables
      7.2 Temporary Tables
      7.3 CREATE ASSERTION
      7.4 CREATE DOMAIN
      7.5 TRIGGERs
      7.6 CREATE PROCEDURE

    8 Table Operations
      8.1 DELETE FROM Statement
        8.1.1 The DELETE FROM Clause
        8.1.2 The WHERE Clause
        8.1.3 Deleting Based on Data in a Second Table
        8.1.4 Deleting Within the Same Table
        8.1.5 Deleting in Multiple Tables Without Referential Integrity
      8.2 INSERT INTO Statement
        8.2.1 INSERT INTO Clause
        8.2.2 The Nature of Inserts
        8.2.3 Bulk Load and Unload Utilities
      8.3 The UPDATE Statement
        8.3.1 The UPDATE Clause
        8.3.2 The WHERE Clause
        8.3.3 The SET Clause
        8.3.4 Updating with a Second Table
        8.3.5 Updating Within the Same Table
        8.3.6 Updating a Primary Key

    9 Comparison or Theta Operators
      9.1 Converting Datatypes
      9.2 Row Comparisons in SQL-92

    10 Valued Predicates
      10.1 IS NULL Predicate
        10.1.1 Sources of NULLS
      10.2 IS [NOT] {TRUE}

      Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >