skip to content
Joe Celko's SQL Programming Style. Preview this item
ClosePreview this item
Checking...

Joe Celko's SQL Programming Style.

Author: Joe Celko
Publisher: Academic Press [Imprint] San Diego : Elsevier Science & Technology Books Los Angeles : Sony Electronics [distributor] Jan. 2009
Series: Morgan Kaufmann Ser. in Data Management Systems Ser.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
Annotation
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

 

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Additional Physical Format: Print version:
Celko, Joe.
Joe Celko's SQL Programming Style.
Burlington : Elsevier Science, ©2014
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Joe Celko
ISBN: 9780080478838 0080478832
OCLC Number: 935390209
Description: 1 online resource.
Contents: Front cover; Title page; Copyright page; Table of contents; front matter; Introduction; 1.1 Purpose of the Book; 1.2 Acknowledgments; 1.3 Corrections, Comments, and Future Editions; First chapter; 1. Names and Data Elements; 1.1 Names; 1.1.1 Watch the Length of Names; 1.1.2 Avoid All Special Characters in Names; 1.1.3 Avoid Quoted Identifiers; 1.1.4 Enforce Capitalization Rules to Avoid Case- Sensitivity Problems; 1.2 Follow the ISO-11179 Standards Naming Conventions; 1.2.1 ISO-11179 for SQL; 1.2.2 Levels of Abstraction; 1.2.3 Avoid Descriptive Prefixes; 1.2.4 Develop Standardized Postfixes. 1.2.5 Table and View Names Should Be Industry Standards, Collective, Class, or Plural Nouns1.2.6 Correlation Names Follow the Same Rules as Other Names ... Almost; 1.2.7 Relationship Table Names Should Be Common Descriptive Terms; 1.2.8 Metadata Schema Access Objects Can Have Names That Include Structure Information; 1.3 Problems in Naming Data Elements; 1.3.1 Avoid Vague Names; 1.3.2 Avoid Names That Change from Place to Place; 1.3.3 Do Not Use Proprietary Exposed Physical Locators; 2. Fonts, Punctuation, and Spacing; 2.1 Typography and Code. 2.1.1 Use Only Upper- and Lowercase Letters, Digits, and Underscores for Names2.1.2 Lowercase Scalars Such as Column Names, Parameters, and Variables; 2.1.3 Capitalize Schema Object Names; 2.1.4 Uppercase the Reserved Words; 2.1.5 Avoid the Use of CamelCase; 2.2 Word Spacing; 2.3 Follow Normal Punctuation Rules; 2.4 Use Full Reserved Words; 2.5 Avoid Proprietary Reserved Words if a Standard Keyword Is Available in Your SQL Product; 2.6 Avoid Proprietary Statements if a Standard Statement Is Available; 2.7 Rivers and Vertical Spacing; 2.8 Indentation; 2.9 Use Line Spacing to Group Statements. 3. Data Declaration Language3.1 Put the Default in the Right Place; 3.2 The Default Value Should Be the Same Data Type as the Column; 3.3 Do Not Use Proprietary Data Types; 3.4 Place the PRIMARY KEY Declaration at the Start of the CREATE TABLE Statement; 3.5 Order the Columns in a Logical Sequence and Cluster Them in Logical Groups; 3.6 Indent Referential Constraints and Actions under the Data Type; 3.7 Give Constraints Names in the Production Code; 3.8 Put CHECK() Constraint Near what they Check; 3.8.1 Consider Range Constraints for Numeric Values. 3.8.2 Consider LIKE and SIMILAR TO Constraints for Character Values3.8.3 Remember That Temporal Values Have Duration; 3.8.4 REAL and FLOAT Data Types Should Be Avoided; 3.9 Put Multiple Column Constraints as Near to Both Columns as Possible; 3.10 Put Table-Level CHECK() Constraints at the End of the Table Declaration; 3.11 Use CREATE ASSERTION for Multi-table Constraints; 3.12 Keep CHECK() Constraints Single Purposed; 3.13 Every Table Must Have a Key to Be a Table; 3.13.1 Auto-Numbers Are Not Relational Keys; 3.13.2 Files Are Not Tables; 3.13.3 Look for the Properties of a Good Key.
Series Title: Morgan Kaufmann Ser. in Data Management Systems Ser.

Abstract:

Annotation

Are you an SQL programmer that, like many, came to SQL after learning and writing procedural or object-oriented code? Or have switched jobs to where a different brand of SQL is being used, or maybe even been told to learn SQL yourself? If even one answer is yes, then you need this book. A "Manual of Style" for the SQL programmer, this book is a collection of heuristics and rules, tips, and tricks that will help you improve SQL programming style and proficiency, and for formatting and writing portable, readable, maintainable SQL code. Based on many years of experience consulting in SQL shops, and gathering questions and resolving his students' SQL style issues, Joe Celko can help you become an even better SQL programmer.

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.

Similar Items

Related Subjects:(1)

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/935390209> # Joe Celko's SQL Programming Style.
    a schema:CreativeWork, schema:Book, schema:MediaObject ;
   library:oclcnum "935390209" ;
   library:placeOfPublication <http://id.loc.gov/vocabulary/countries/mou> ;
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/20132144#Place/san_diego> ; # San Diego
   library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/20132144#Place/los_angeles> ; # Los Angeles
   schema:about <http://dewey.info/class/005.133/e22/> ;
   schema:about <http://experiment.worldcat.org/entity/work/data/20132144#Topic/sql_computer_program_language> ; # Sql (Computer Program Language)
   schema:author <http://experiment.worldcat.org/entity/work/data/20132144#Person/celko_joe> ; # Joe Celko
   schema:bookFormat schema:EBook ;
   schema:datePublished "Jan. 2009" ;
   schema:description "Annotation"@en ;
   schema:description "Front cover; Title page; Copyright page; Table of contents; front matter; Introduction; 1.1 Purpose of the Book; 1.2 Acknowledgments; 1.3 Corrections, Comments, and Future Editions; First chapter; 1. Names and Data Elements; 1.1 Names; 1.1.1 Watch the Length of Names; 1.1.2 Avoid All Special Characters in Names; 1.1.3 Avoid Quoted Identifiers; 1.1.4 Enforce Capitalization Rules to Avoid Case- Sensitivity Problems; 1.2 Follow the ISO-11179 Standards Naming Conventions; 1.2.1 ISO-11179 for SQL; 1.2.2 Levels of Abstraction; 1.2.3 Avoid Descriptive Prefixes; 1.2.4 Develop Standardized Postfixes."@en ;
   schema:exampleOfWork <http://worldcat.org/entity/work/id/20132144> ;
   schema:genre "Electronic books"@en ;
   schema:inLanguage "en" ;
   schema:isPartOf <http://experiment.worldcat.org/entity/work/data/20132144#Series/morgan_kaufmann_ser_in_data_management_systems_ser> ; # Morgan Kaufmann Ser. in Data Management Systems Ser.
   schema:isPartOf <http://experiment.worldcat.org/entity/work/data/20132144#Series/the_morgan_kaufmann_ser_in_data_management_systems_ser> ; # The Morgan Kaufmann Ser. in Data Management Systems Ser.
   schema:isSimilarTo <http://worldcat.org/entity/work/data/20132144#CreativeWork/joe_celko_s_sql_programming_style> ;
   schema:name "Joe Celko's SQL Programming Style."@en ;
   schema:productID "935390209" ;
   schema:publication <http://www.worldcat.org/title/-/oclc/935390209#PublicationEvent/academic_press_imprintjan_2009san_diego_elsevier_science_&_technology_bookslos_angeles_sony_electronics_distributor> ;
   schema:publisher <http://experiment.worldcat.org/entity/work/data/20132144#Agent/sony_electronics_distributor> ; # Sony Electronics [distributor
   schema:publisher <http://experiment.worldcat.org/entity/work/data/20132144#Agent/elsevier_science_&_technology_books> ; # Elsevier Science & Technology Books
   schema:publisher <http://experiment.worldcat.org/entity/work/data/20132144#Agent/academic_press_imprint> ; # Academic Press [Imprint
   schema:url <http://public.eblib.com/choice/publicfullrecord.aspx?p=234986> ;
   schema:url <http://ebookcentral.proquest.com/lib/columbia/detail.action?docID=234986> ;
   schema:url <http://ebookcentral.proquest.com/lib/ucm/detail.action?docID=234986> ;
   schema:url <http://proquest.safaribooksonline.com/9780120887972> ;
   schema:workExample <http://worldcat.org/isbn/9780080478838> ;
   wdrs:describedby <http://www.worldcat.org/title/-/oclc/935390209> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/20132144#Agent/academic_press_imprint> # Academic Press [Imprint
    a bgn:Agent ;
   schema:name "Academic Press [Imprint" ;
    .

<http://experiment.worldcat.org/entity/work/data/20132144#Agent/elsevier_science_&_technology_books> # Elsevier Science & Technology Books
    a bgn:Agent ;
   schema:name "Elsevier Science & Technology Books" ;
    .

<http://experiment.worldcat.org/entity/work/data/20132144#Agent/sony_electronics_distributor> # Sony Electronics [distributor
    a bgn:Agent ;
   schema:name "Sony Electronics [distributor" ;
    .

<http://experiment.worldcat.org/entity/work/data/20132144#Series/morgan_kaufmann_ser_in_data_management_systems_ser> # Morgan Kaufmann Ser. in Data Management Systems Ser.
    a bgn:PublicationSeries ;
   schema:hasPart <http://www.worldcat.org/oclc/935390209> ; # Joe Celko's SQL Programming Style.
   schema:name "Morgan Kaufmann Ser. in Data Management Systems Ser." ;
    .

<http://experiment.worldcat.org/entity/work/data/20132144#Series/the_morgan_kaufmann_ser_in_data_management_systems_ser> # The Morgan Kaufmann Ser. in Data Management Systems Ser.
    a bgn:PublicationSeries ;
   schema:hasPart <http://www.worldcat.org/oclc/935390209> ; # Joe Celko's SQL Programming Style.
   schema:name "The Morgan Kaufmann Ser. in Data Management Systems Ser." ;
    .

<http://experiment.worldcat.org/entity/work/data/20132144#Topic/sql_computer_program_language> # Sql (Computer Program Language)
    a schema:Intangible ;
   schema:name "Sql (Computer Program Language)"@en ;
    .

<http://worldcat.org/entity/work/data/20132144#CreativeWork/joe_celko_s_sql_programming_style>
    a schema:CreativeWork ;
   rdfs:label "Joe Celko's SQL Programming Style." ;
   schema:description "Print version:" ;
   schema:isSimilarTo <http://www.worldcat.org/oclc/935390209> ; # Joe Celko's SQL Programming Style.
    .

<http://worldcat.org/isbn/9780080478838>
    a schema:ProductModel ;
   schema:isbn "0080478832" ;
   schema:isbn "9780080478838" ;
    .

<http://www.worldcat.org/title/-/oclc/935390209#PublicationEvent/academic_press_imprintjan_2009san_diego_elsevier_science_&_technology_bookslos_angeles_sony_electronics_distributor>
    a schema:PublicationEvent ;
   schema:location <http://experiment.worldcat.org/entity/work/data/20132144#Place/los_angeles> ; # Los Angeles
   schema:location <http://experiment.worldcat.org/entity/work/data/20132144#Place/san_diego> ; # San Diego
   schema:organizer <http://experiment.worldcat.org/entity/work/data/20132144#Agent/sony_electronics_distributor> ; # Sony Electronics [distributor
   schema:organizer <http://experiment.worldcat.org/entity/work/data/20132144#Agent/elsevier_science_&_technology_books> ; # Elsevier Science & Technology Books
   schema:organizer <http://experiment.worldcat.org/entity/work/data/20132144#Agent/academic_press_imprint> ; # Academic Press [Imprint
   schema:startDate "Jan. 2009" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.