PDF Ebook Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems), by Joe Celko
So, merely be here, locate the publication Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko now and also review that promptly. Be the very first to read this e-book Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko by downloading in the web link. We have some other publications to review in this internet site. So, you can discover them additionally quickly. Well, now we have actually done to supply you the very best book to review today, this Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko is truly proper for you. Never overlook that you need this book Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko to make better life. Online e-book Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko will really offer very easy of everything to review and take the advantages.
Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems), by Joe Celko
PDF Ebook Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems), by Joe Celko
Exactly how if your day is begun by reviewing a publication Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko Yet, it remains in your gadget? Everybody will certainly still touch as well as us their gizmo when waking up and in early morning tasks. This is why, we mean you to likewise review a publication Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko If you still confused how you can get the book for your device, you could comply with the way here. As here, we provide Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko in this site.
For everybody, if you want to start accompanying others to read a book, this Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko is much suggested. As well as you have to obtain guide Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko here, in the link download that we provide. Why should be here? If you really want various other type of books, you will certainly constantly locate them and Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko Economics, national politics, social, scientific researches, religious beliefs, Fictions, as well as a lot more publications are provided. These readily available books are in the soft data.
Why should soft documents? As this Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko, lots of people also will certainly need to acquire guide sooner. But, often it's up until now way to get guide Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko, even in other nation or city. So, to alleviate you in discovering the books Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko that will assist you, we assist you by offering the lists. It's not only the list. We will give the suggested book Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko link that can be downloaded directly. So, it will not need more times and even days to pose it and also various other publications.
Accumulate the book Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko start from currently. Yet the extra method is by collecting the soft documents of the book Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko Taking the soft data can be saved or saved in computer or in your laptop. So, it can be greater than a book Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko that you have. The easiest means to expose is that you can additionally conserve the soft documents of Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko in your ideal as well as available gadget. This condition will certainly suppose you frequently check out Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko in the downtimes more than chatting or gossiping. It will certainly not make you have bad habit, but it will lead you to have better behavior to review book Joe Celko's SQL Programming Style (The Morgan Kaufmann Series In Data Management Systems), By Joe Celko.
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!
- Sales Rank: #1097391 in Books
- Published on: 2005-05-01
- Original language: English
- Number of items: 1
- Dimensions: 9.25" h x .55" w x 7.50" l, 1.08 pounds
- Binding: Paperback
- 272 pages
Review
“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
From the Back Cover
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. More specifically, this book will give you expert advice from a noted SQL guru and award-winning columnist and will:
+ 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!
Joe Celko is a noted consultant, lecturer, teacher, and one of the most-read SQL authors in the world. He is well known for his ten years of service on the ANSI SQL standards committee, his dependable help on the DBMS CompuServe Forum, his column in Intelligent Enterprise (which won several Reader’s Choice Awards), and the war stories he tells to provide real-world insights into SQL programming. His best-selling books include Joe Celko’s SQL for Smarties: Advanced SQL Programming, Joe Celko’s SQL Puzzles and Answers, and Joe Celko’s Trees and Hierarchies in SQL for Smarties, all published by Morgan Kaufmann.
About the Author
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.
Most helpful customer reviews
8 of 8 people found the following review helpful.
This is the nth try to post this review
By John Bonavia
If this review finally goes in, I shall be pleased but surprised, There is something wrong with Amazon's linking. I have spoken to support and they don't know what it is. Anyway...
This is a mixed bag, but mostly very good. Lots of excellent information about different versions of SQL vs. standards, and fascinating excursions into the underpinnings of coding systems, measurements, scales, ratios, etc. We should all be a lot more aware of the work that has been done and codified in many international standards. Apart from anything else, it would save people from re-inventing so many wheels - and making some of them square!
There is an excellent and much-needed stress on the need to use relational thinking when you are working in the SQL environment, with the focus on natural keys and set-oriented processing. He rightly decries the use of "external locator" keys (which most of us call "surrogate" keys, though he defines that term differently) - anyway, basically the "Identity" type. He is perhaps a little too extreme in pretty much absolutely outlawing them, but I agree with the general principle. They are an expedient pushed by people who don't understand relational design. Natural keys are much better. (But I have to agree with another reviewer that the SSN is problematic. Coming to the US from Canada, I couldn't believe the SSN was not a check-digited number, unlike the Canadian SIN, or any credit card number, or banking ABA's. I guess the age of the system was one issue. But the result, anyway, is that duplicate SSNs exist and that they are frequently invented or stolen.)
As a self-described "old fart" he castigates the design errors that may be committed by those (like me!) who grew up in the age of punched cards and magnetic tape. But surely few current database designers have ever seen a punched card, and rarely encounter a good old sequential fixed-length-record file, let alone a mag tape. The model that leads them astray these days is not the sequential file, but the Excel spreadsheet! Time and again I see HORRIBLE designs, violating all the normal forms from 1 to 3 and beyond, based on the columns of an Excel spreadsheet. Another factor is the lack of relational training - how many people have read Codd or Date? and the harm done by the early PC databases that were just a kind of disorganized dumping-ground for data, draining meaning from the term "database."
Some of his mandates are perhaps a little too absolute "Don't use cursors" - well, 99% of the time, very true. You should be thinking sets, not serial access. But there are a few occasions where a cursor can be a useful weapon in your armory and can even execute faster than a set manipulation. Not many, but a few - beyond the outlying cases he describes. Similarly with triggers - yes, generally DRI is far preferable (if your DBMS supports it). But if you want customized transaction audit capture, triggers are the natural way to go.
A few beefs:
There's a sprinkling of typos, and I did spot one actual error: on p 114, he presents "WHERE a = b + 2" as the alternative to "WHERE a + 2 = b - 4." Oops! Obviously the valid alternative is "WHERE a = b - 6."
The discussion of Camel Case is too limited: there are a lot of variations and his definition is at odds with the widely used Microsoft definition, which would have been worth mentioning. For MS, camel case is like "thisCase" and Celko's camel case, "ThisCase," is called Pascal case.
I found his advice on formatting and display of code sometimes odd. Often when he showed example A and then "see how example B is more readable " - I thought example A was clearer! He refers to studies on visual perception, eye movement, etc., but I am not sure that such studies done in the context of reading normal prose are valid for SQL, or other programming-type text. Comprehension likely occurs in different stages or chunks.
Also, surely Hungarian notation is found in strongly-typed, not weakly-typed, languages. In a weakly-typed language like REXX, a variable can be a string one minute, an integer the next. What prefix can you use? Whereas in VB, for instance, up to version 6, MS recommended prefixes to remind the programmer of the fixed type as defined, so he would not be tempted to write "intAccountID = "New Customer" or suchlike.[...]
Summary? Well, OK, I've listed a few problems, but overall, get this and study it - there's lots of fascinating and rewarding material, from someone who has been working in this field a long time and has gone very deeply into many aspects of it. Many of the SQL examples will really stretch your brain - his other books do that too!
14 of 14 people found the following review helpful.
3.5 stars: Has good stuff but very undercooked
By J Jacob Jingleheimer Schmidt
I'll expand on that when I have time; but for now, real quick:
PROs:
- As usual for Celko's books, you get this feeling of conversing with a knowledgeable and overall very likeable individual with a good sense of humour (he got me laughing on page 2, see his comments on the making of fine furniture).
- Good justifications are given for many rules of thumb that, as of now, you're likely to be adhering to on faith.
- A number of unobvious, sharp, mind-stretching tidbits (an ever-present feature of Celko books).
- Very good bibliography. Celko is not a "narrow specialist": reading pointers he gives are varied and very interesting. Also, links to a lot of net material. Great.
- He writes simply.
-----------------------
CONTRA, the one and only problem: the book appears to be written in a terrible hurry, which is manifested by the following occurrences (not exhaustively):
- Sometimes the author has something to say, but does not say it intelligibly (e.g., section 1.2.7)
- Sometimes he doesn't have anything to say, but gibbers on anyway (e.g., section 3.15)
- Sometimes he belabours the obvious or maybe even spurious: for example, there's too much of this "unlearn OO to understand SQL". One doesn't need to unlearn what one knows to learn something he doesn't; there's no clear-cut distinction: for example, operating on STL collections is very set-like, quite SQL'ish actually: you provide a predicate and it's then applied internally in a set-scoped operation. Matlab is very similar. BLAS is very similar. Fortran is similar. Iow, thinking in sets is an important thing to point to -- once; but after that it's beating a dead horse; move on already. Especially since it isn't really as black-and-white as the author suggests.
(4) The book is very inadequately indexed: index is very small; nothing can be found. What's SQL/PSM? I don't think it's been defined anywhere, but perhaps I missed it; off to index I go... and find nothing there. How nice. I mean, come on -- a five-page index in a technical book?
(5) Dropping French. Is it really necessary? "Sistem� International d'units", OK.
There's more stuff to talk about, both good and bad; but I've no time to write it up right now. So, finally: is it a worthy book?
Well, the book is flawed but not useless by any means. It's not a must read, but if you got a few discretionary bucks and a bit of free time, it's worth reading. I've learned a few interesting things here; ~1/3rd of the reading has been pleasant: in addition to knowing a lot of stuff, DB-related and beyond, Celko's got a real good sense of humour and a gift of gab. Were this book a brochure one-third its current size sold for five bucks, I'd give it five stars. OK, ten bucks.
11 of 11 people found the following review helpful.
Excellent book in excellent style
By dalepres
Too many database books are written by developers whose expertise is OOP and not SQL. While I don't agree with Mr. Celko on every point, keep in mind that he was on the SQL Standards Committee for 10 years. Even if you don't agree with him on every point, his level of expertise is undeniable - unless, perhaps, the questioner can provide evidence of greater knowledge and expertise.
This book is to SQL grammar and style as "The Elements of Style" by Strunk and White are to English grammar and style. Mr. Celko explains, in terms that should be easily understood, why SQL should be written in standard SQL while still allowing that there can be exceptions just as verbal communications, in any language, should follow the standard grammar of the language unless there is good reason to slip into a localized dialect.
Where one reviewer rated the book with 1 star because that reviewer disagrees with Mr. Celko on a single point of database design, his antagonistic remarks have nothing to do with the point or the value of this book.
As the editorial review states, this book is not for beginners. If you have been programming SQL for a year or more and you want to fine tune the quality of your work, this work is something you should surely read.
See all 13 customer reviews...
Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems), by Joe Celko PDF
Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems), by Joe Celko EPub
Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems), by Joe Celko Doc
Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems), by Joe Celko iBooks
Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems), by Joe Celko rtf
Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems), by Joe Celko Mobipocket
Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems), by Joe Celko Kindle
Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems), by Joe Celko PDF
Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems), by Joe Celko PDF
Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems), by Joe Celko PDF
Joe Celko's SQL Programming Style (The Morgan Kaufmann Series in Data Management Systems), by Joe Celko PDF
