Joe Celko's SQL Programming Style

By: Joe Celko

Write A Review

Paperback | 17 April 2005

At a Glance

Paperback
240 Pages

Dimensions(cm)
22.23 x 18.42 x 1.27

Paperback

RRP $71.95

$70.75

or 4 interest-free payments of $17.69 with

Ships in 5 to 7 business days

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.

Help you write Standard SQL without an accent or a dialect that is used in another programming language or a specific flavor of SQL, code that can be maintained and used by other people.
Enable you to give your group a coding standard for internal use, to enable programmers to use a consistent style.
Give you the mental tools to approach a new problem with SQL as your tool, rather than another programming language - one that someone else might not know!

Industry Reviews

"Joe Celko, maybe one of the most prominent representatives of the database community these days, has written some of the best books about SQL programming in general. This book, however, is different. "SQL Programming Style" doesn't teach you how to become a better SQL developer with SQL puzzles and brainteasers. Rather, it shows you "how to work in logical and declarative terms"." - SQL-Server-Performance.com, August 17, 2006

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Databases Computer Programming & Software Development Database Programming Programming & Scripting Languages Software Engineering

Introduction	p. xv
Names and Data Elements	p. 1
Names	p. 2
Watch the Length of Names	p. 2
Avoid All Special Characters in Names	p. 3
Avoid Quoted Identifiers	p. 4
Enforce Capitalization Rules to Avoid Case-Sensitivity Problems	p. 6
Follow the ISO-11179 Standards Naming Conventions	p. 7
ISO-11179 for SQL	p. 8
Levels of Abstraction	p. 9
Avoid Descriptive Prefixes	p. 10
Develop Standardized Postfixes	p. 12
Table and View Names Should Be Industry Standards, Collective, Class, or Plural Nouns	p. 14
Correlation Names Follow the Same Rules as Other Names... Almost	p. 15
Relationship Table Names Should Be Common Descriptive Terms	p. 17
Metadata Schema Access Objects Can Have Names That Include Structure Information	p. 18
Problems in Naming Data Elements	p. 18
Avoid Vague Names	p. 18
Avoid Names That Change from Place to Place	p. 19
Do Not Use Proprietary Exposed Physical Locators	p. 21
Fonts, Punctuation, and Spacing	p. 23
Typography and Code	p. 23
Use Only Upper- and Lowercase Letters, Digits, and Underscores for Names	p. 25
Lowercase Scalars Such as Column Names, Parameters, and Variables	p. 25
Capitalize Schema Object Names	p. 26
Uppercase the Reserved Words	p. 26
Avoid the Use of CamelCase	p. 29
Word Spacing	p. 30
Follow Normal Punctuation Rules	p. 31
Use Full Reserved Words	p. 33
Avoid Proprietary Reserved Words if a Standard Keyword Is Available in Your SQL Product	p. 33
Avoid Proprietary Statements if a Standard Statement Is Available	p. 34
Rivers and Vertical Spacing	p. 37
Indentation	p. 38
Use Line Spacing to Group Statements	p. 39
Data Declaration Language	p. 41
Put the Default in the Right Place	p. 41
The Default Value Should Be the Same Data Type as the Column	p. 42
Do Not Use Proprietary Data Types	p. 42
Place the PRIMARY KEY Declaration at the Start of the CREATE TABLE Statement	p. 44
Order the Columns in a Logical Sequence and Cluster Them in Logical Groups	p. 44
Indent Referential Constraints and Actions under the Data Type	p. 45
Give Constraints Names in the Production Code	p. 46
Put CHECK() Constraint Near what they Check	p. 46
Consider Range Constraints for Numeric Values	p. 47
Consider LIKE and SIMILAR TO Constraints for Character Values	p. 47
Remember That Temporal Values Have Duration	p. 48
REAL and FLOAT Data Types Should Be Avoided	p. 48
Put Multiple Column Constraints as Near to Both Columns as Possible	p. 48
Put Table-Level CHECK() Constraints at the End of the Table Declaration	p. 49
Use CREATE ASSERTION for Multi-table Constraints	p. 49
Keep CHECK() Constraints Single Purposed	p. 50
Every Table Must Have a Key to Be a Table	p. 51
Auto-Numbers Are Not Relational Keys	p. 52
Files Are Not Tables	p. 53
Look for the Properties of a Good Key	p. 54
Do Not Split Attributes	p. 62
Split into Tables	p. 63
Split into Columns	p. 63
Split into Rows	p. 65
Do Not Use Object-Oriented Design for an RDBMS	p. 66
A Table Is Not an Object Instance	p. 66
Do Not Use EAV Design for an RDBMS	p. 68
Scales and Measurements	p. 69
Measurement Theory	p. 69
Range and Granularity	p. 71
Range	p. 72
Granularity, Accuracy, and Precision	p. 72
Types of Scales	p. 73
Nominal Scales	p. 73
Categorical Scales	p. 73
Absolute Scales	p. 74
Ordinal Scales	p. 74
Rank Scales	p. 75
Interval Scales	p. 76
Ratio Scales	p. 77
Using Scales	p. 77
Scale Conversion	p. 77
Derived Units	p. 79
Punctuation and Standard Units	p. 80
General Guidelines for Using Scales in a Database	p. 81
Data Encoding Schemes	p. 83
Bad Encoding Schemes	p. 84
Encoding Scheme Types	p. 86
Enumeration Encoding	p. 86
Measurement Encoding	p. 87
Abbreviation Encoding	p. 87
Algorithmic Encoding	p. 88
Hierarchical Encoding Schemes	p. 89
Vector Encoding	p. 90
Concatenation Encoding	p. 91
General Guidelines for Designing Encoding Schemes	p. 92
Existing Encoding Standards	p. 92
Allow for Expansion	p. 92
Use Explicit Missing Values to Avoid NULLs	p. 92
Translate Codes for the End User	p. 93
Keep the Codes in the Database	p. 96
Multiple Character Sets	p. 97
Coding Choices	p. 99
Pick Standard Constructions over Proprietary Constructions	p. 100
Use Standard OUTER JOIN Syntax	p. 101
Infixed INNER JOIN and CROSS JOIN Syntax Is Optional, but Nice	p. 105
Use ISO Temporal Syntax	p. 107
Use Standard and Portable Functions	p. 108
Pick Compact Constructions over Longer Equivalents	p. 109
Avoid Extra Parentheses	p. 109
Use CASE Family Expressions	p. 110
Avoid Redundant Expressions	p. 113
Seek a Compact Form	p. 114
Use Comments	p. 118
Stored Procedures	p. 119
Control Statement Comments	p. 119
Comments on Clause	p. 119
Avoid Optimizer Hints	p. 120
Avoid Triggers in Favor of DRI Actions	p. 120
Use SQL Stored Procedures	p. 122
Avoid User-Defined Functions and Extensions inside the Database	p. 123
Multiple Language Problems	p. 124
Portability Problems	p. 124
Optimization Problems	p. 124
Avoid Excessive Secondary Indexes	p. 124
Avoid Correlated Subqueries	p. 125
Avoid UNIONs	p. 127
Testing SQL	p. 130
Test All Possible Combinations of NULLs	p. 130
Inspect and Test All CHECK() Constraints	p. 130
Beware of Character Columns	p. 131
Test for Size	p. 131
How to Use VIEWS	p. 133
VIEW Naming Conventions Are the Same as Tables	p. 135
Always Specify Column Names	p. 136
VIEWs Provide Row- and Column-Level Security	p. 136
VIEWs Ensure Efficient Access Paths	p. 138
VIEWs Mask Complexity from the User	p. 138
VIEWs Ensure Proper Data Derivation	p. 139
VIEWs Rename Tables and/or Columns	p. 140
VIEWs Enforce Complicated Integrity Constraints	p. 140
Updatable VIEWs	p. 143
WITH CHECK OPTION clause	p. 143
INSTEAD OF Triggers	p. 144
Have a Reason for Each VIEW	p. 144
Avoid VIEW Proliferation	p. 145
Synchronize VIEWs with Base Tables	p. 145
Improper Use of VIEWs	p. 146
VIEWs for Domain Support	p. 146
Single-Solution VIEWs	p. 147
Do Not Create One VIEW Per Base Table	p. 148
Learn about Materialized VIEWs	p. 149
How to Write Stored Procedures	p. 151
Most SQL 4GLs Are Not for Applications	p. 152
Basic Software Engineering	p. 153
Cohesion	p. 153
Coupling	p. 155
Use Classic Structured Programming	p. 156
Cyclomatic Complexity	p. 157
Avoid Portability Problems	p. 158
Avoid Creating Temporary Tables	p. 158
Avoid Using Cursors	p. 159
Prefer Set-Oriented Constructs to Procedural Code	p. 161
Scalar versus Structured Parameters	p. 167
Avoid Dynamic SQL	p. 168
Performance	p. 169
SQL Injection	p. 169
Heuristics	p. 171
Put the Specification into a Clear Statement	p. 172
Add the Words "Set of All..." in Front of Nouns	p. 173
Remove Active Verbs from the Problem Statement	p. 174
You Can Still Use Stubs	p. 174
Do Not Worry about Displaying the Data	p. 176
Your First Attempts Need Special Handling	p. 177
Do Not Be Afraid to Throw Away Your First Attempts at DDL	p. 177
Save Your First Attempts at DML	p. 178
Do Not Think with Boxes and Arrows	p. 179
Draw Circles and Set Diagrams	p. 179
Learn Your Dialect	p. 180
Imagine That Your WHERE Clause Is "Super Ameba"	p. 180
Use the Newsgroups and Internet	p. 181
Thinking in SQL	p. 183
Bad Programming in SQL and Procedural Languages	p. 184
Thinking of Columns as Fields	p. 189
Thinking in Processes, Not Declarations	p. 191
Thinking the Schema Should Look Like the Input Forms	p. 194
Resources	p. 197
Military Standards	p. 197
Metadata Standards	p. 197
ANSI and ISO Standards	p. 198
U.S. Government Codes	p. 199
Retail Industry	p. 199
Code Formatting and Naming Conventions	p. 200
Bibliography	p. 203
Reading Psychology	p. 203
Programming Considerations	p. 204
Index	p. 207
About the Author	p. 217
Table of Contents provided by Ingram. All Rights Reserved.

Joe Celko's SQL Programming Style

At a Glance

Paperback

Industry Reviews

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Software Engineering

Application of Computational Techniques in Power Systems for Power Quality Improvement

Knowledge-based Engineering for Innovation

The Essence of Software Engineering

Semantics With Applications

Advanced Topics in Computer Science

Code

2nd Edition - The Hidden Language of Computer Hardware and Software

The Pragmatic Programmer 2nd edition

your journey to mastery, 20th Anniversary Edition

Fundamentals of Software Architecture

A Modern Engineering Approach

Hacking For Dummies

For Dummies (Computer/Tech)

Making Embedded Systems

2nd Edition - Design Patterns for Great Software

Design Patterns

Elements of Reusable Object-Oriented Software

Designing Data-Intensive Applications

Big Ideas Behind Reliable, Scalable, and Maintainable Systems

Head First Design Patterns

Building Extensible and Maintainable Object-Oriented Software 2nd Edition

User Story Mapping

Discover the Whote Story, Build the Right Product

Object-Oriented and Classical Software Engineering - Global Edition

8th Edition

Git : Pocket Guide

A Working Introduction

Clean Architecture

A Craftsman's Guide to Software Structure and Design

Architecture Patterns with Python

Enabling Test-Driven Development, Domain-Driven Design, and Event-Driven Microservices

The Software Architect Elevator

Redefining the Architect's Role in the Digital Enterprise

The Staff Engineer's Path

A Guide For Individual Contributors Navigating Growth and Change

Swim Training Patterns

1st Edition - Plan your Training Sessions with the Power of Mathematics

Developing Graphics Frameworks with Java and OpenGL

The Engineering Leader

Strategies for Scaling Teams and Yourself

Clean Code

A Handbook of Agile Software Craftsmanship

Learning Modern C++ for Finance

Foundations for Quantitative Programming

Learning Agile

Understanding Scrum, XP, Lean, and Kanban

This product is categorised by