Joe Celko's SQL Programming Style

Collection of heuristics and rules, tips, and tricks that help improve SQL programming style and proficiency, and for formatting and writing portable, readable, maintainable SQL code. This book is based on the author's experience consulting in SQL shops, and gathering questions and resolving his students SQL style issues.

Autorentext
Joe Celko served 10 years on ANSI/ISO SQL Standards Committee and contributed to the SQL-89 and SQL-92 Standards. Mr. Celko is author a series of books on SQL and RDBMS for Elsevier/MKP. He is an independent consultant based in Austin, Texas. He has written over 1200 columns in the computer trade and academic press, mostly dealing with data and databases.

Klappentext
This book assumes the reader is somewhat knowledgeable about SQL programming and allows them to create their own set of programming standards comforming to their particular work requirements. It is easier to buy the book than to write a company-only formal set of coding standards, which may or may not be used consistently even with the same enterprise. There are a ton of introductory SQL books on the market, which teach the language in the way that a grammar book teaches a foreign language. Most SQL programmers come to the language from a totally different family of programming languages. The result is that they speak SQL with an accent and in a local dialect. The goal of this book is that of a phrase book and audiocassette book, where you learn to really speak the language.

Zusammenfassung
Provides heuristics, rules, tips, and tricks that intend to help readers improve their SQL programming style and proficiency, and format and write portable, readable, maintainable SQL code. This book enables readers to give their group a coding standard for internal use, to enable programmers to use a consistent style.

Inhalt
Chapter 1. Names and Data Elements; Chapter 2. Fonts, Punctuation and Spacing; Chapter 3 Data Declaration Language; Chapter 4 Scales and Measurements; Chapter 5 Data Encoding Schemes; Chapter 6 Coding Choices; Chapter 7 How to Use Views; Chapter 8 How to Write Stored Procedures; Heuristics.