|
||||||||||||||||||||
|
||||||||||||||||||||
|
||||||||||||||||||||
Joe Celko's SQL for Smarties
und über 1 Million weitere Bücher verfügbar für Amazon Kindle .
Erfahren Sie mehr
| ||||||||||||||||||||||||
|
|
|
Dieses Buch gibt es in einer neuen Auflage:
|
Wird oft zusammen gekauft
Produktinformation
Möchten Sie die Produktinformationen aktualisieren oder Feedback zu den Produktabbildungen geben?
Ist der Verkauf dieses Produkts für Sie nicht akzeptabel? |
Mehr über den Autor
Entdecken Sie Bücher, lesen Sie über Autoren und mehr
› Besuchen Sie die Seite von Joe Celko auf Amazon
› Besuchen Sie die Seite von Joe Celko auf Amazon
Produktbeschreibungen
Amazon.co.uk
In the SQL database community, Joe Celko is a well-known columnist and purveyor of valuable insights. In Joe Celko's SQL for Smarties: Advanced SQL Programming, he picks up where basic SQL training and experience leaves many database professionals and offers tips, techniques and explanations that help readers extend their capabilities to top-tier SQL programming.
Although Celko denies that the book is about database theory, he often alludes to theory to buttress his practical points. This title is not for novices, as the author points out. Instead its intended audience is SQL programmers with at least a year's experience. The book maintains a fine balance between technical discussion and practical explanation--picking hot topics and offering advice on a wide range of subjects.
The book uses ANSI SQL-89 as its baseline standard, with some mention of SQL-92 features. However, it does not focus on any commercial product but rather zeroes in on the SQL language. Celko covers all aspects of database design, optimisation and manipulation, with easy-to-understand explanations of key issues such as why not to use too many nulls, how to use practical normalisation and how to optimise queries.
This insightful text is manna for all the day-to-day SQL coders banging their heads over the language's subtle challenges. --Stephen W.Plain
Topics covered:
Database design and normalisation, SQL data types, querying, grouping, set operations, optimisation, data scaling and encoding.
-- Dieser Text bezieht sich auf eine andere Ausgabe:
Taschenbuch
.
Amazon.com
In the SQL database community, Joe Celko is a well-known columnist and purveyor of valuable insights. In Joe Celko's SQL for Smarties: Advanced SQL Programming, he picks up where basic SQL training and experience leaves many database professionals and offers tips, techniques, and explanations that help readers extend their capabilities to top-tier SQL programming.
Although Celko denies that the book is about database theory, he nevertheless alludes to theory often to buttress his practical points. This title is not for novices, as the author points out. Instead, its intended audience is SQL programmers with at least a year's experience. The book maintains a fine balance between technical discussion and practical explanation--picking hot topics and offering advice on a wide range of issues.
The book uses ANSI SQL-89 as its baseline standard, with some mention of SQL-92 features. It does not, however, focus on any commercial product; this guide zeroes in on the SQL language. Celko covers all aspects of database design, optimization, and manipulation, with easy-to-understand explanations of key issues such as why not to use too many nulls, how to use practical normalization, and how to optimize queries.
This insightful text is manna for all the day-to-day SQL coders banging their heads over the language's subtle challenges. --Stephen W. Plain
Topics covered: Database design and normalization, SQL data types, querying, grouping, set operations, optimization, data scaling, and encoding. -- Dieser Text bezieht sich auf eine andere Ausgabe: Taschenbuch .
Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?
In diesem Buch
(Mehr dazu)
Einleitungssatz
The major problem in learning SQL is that programmers are used to thinking in terms of files rather than tables. Lesen Sie die erste Seite
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis
The major problem in learning SQL is that programmers are used to thinking in terms of files rather than tables. Lesen Sie die erste Seite
Mehr entdecken
Wortanzeiger
Ausgewählte Seiten ansehenWortanzeiger
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis
Vorgeschlagene Tags zu ähnlichen Produkten(Was ist das?)Setzen Sie den ersten relevanten Tag hinzu (ein Schlüsselwort, das mit diesem Produkt in engem Zusammenhang steht).
|
Kundenrezensionen
Die hilfreichsten Kundenrezensionen
3 von 3 Kunden fanden die folgende Rezension hilfreich
Format:Taschenbuch
I would have preffered a book speciffic to 'SMARTIES' as the title suggests, unfortunately those of us who've been writting SQL for a number of years will find this book of little use. A great book if you are new to SQL or have used SQL sparingly.
I was looking for a book that would help me write better, more efficient SQL code and performance tune my code, maybe insights into the compilers ...instead, the book in my opinion, is a good introduction to SQL or a refresher on SQL....
I found several errors in the book that annoyed me, not typos, but errors in the SQL itself. Maybe I'm too critical, but considering the price we pay for these books, I beleive I deserve more.
Mr. Celko is definately the 'guru' when it comes to SQL....but maybe I was expecting too much!
1 von 1 Kunden fanden die folgende Rezension hilfreich
Format:Taschenbuch
Celko's book is the only one I know, which touched more advanced levels of sql-programming; a serious drawback is, that it doesn't describe analytical functions, but uses sql89 even for queries, which are optimal candidates for analytical functions;
1 von 1 Kunden fanden die folgende Rezension hilfreich
Format:Taschenbuch
I have been programming database applications since 1984. I started using SQL in 1989. Since that time, I thought I had mastered SQL. Well ... I was wrong. Joe's book helps pin point the finer things concerning SQL ... how it really works. Anyone who is an ADVANCED user of SQL will find this book full of the little things that all most all developers will overlook. For example, how does a SQL statement really execute (pg 174 to 181) explains this in great detail. Many advanced developers are not just satisfied with knowing how to do something; but, want to know every little detail about how something really works. I found the chapters on normalization and Armstrong's Axioms to be the most useful concept in the entire book. Database design concepts are critical in performing a good, solid, and efficient query and this chapter brings it out very well. I have found this book to be my only source for advanced SQL concepts (besides Joe's puzzle book...). Good job ... and thanks.
Möchten Sie weitere Rezensionen zu diesem Artikel anzeigen?
Waren diese Rezensionen hilfreich?
Wir wollen von Ihnen hören.
Die neuesten Kundenrezensionen
Exceptional quality in a computer manual
I cannot work without this book. Stuck with a poor database structure and huge volumes of data, I have had to explore every trick of the trade. Lesen Sie weiter...
Veröffentlicht am 15. Juli 2000 von Fred L. Stephens
Valuable but flawed
This book is indispensable for a thorough knowledge of SQL, but it is decidedly not for the beginner. Lesen Sie weiter...
Veröffentlicht am 8. März 2000 von Stuart Bloom
An absolute MUST for any serious SQL programmer
First of all, I couldn't recommend this book for beginners. It is, however, PERFECT for the SQL programmer with some experience who is looking to take his/her SQL abilities to the... Lesen Sie weiter...
Veröffentlicht am 14. Februar 2000 von Brian Barthelt
Anthony Mays
It's too bad I cannot rate this book as a ten. A word to the wise: Celko's books cover the ANSI STANDARD SQL 92 (mainly). Lesen Sie weiter...
Veröffentlicht am 3. Februar 2000 von Anthony Mays
Excellent book, very easy to understand
I'm currently taking an undergraduate course in database and this book teaches you powerful and efficient SQL techniques that are not even cover in undergraduate books. Lesen Sie weiter...
Am 30. November 1999 veröffentlicht
Most readable technical book
Celko has an amazing ability of making technical stuff seem readable and easy. A very enjoyable read.
Veröffentlicht am 19. November 1999 von LT
A must have...
Joe Celko is a very interesting author. His approach to teaching by using puzzles gets the mind thinking. He does not keep you guessing too long. Lesen Sie weiter...
Am 8. August 1999 veröffentlicht
Joe provides the most readable book on the subject
This book is packed full of useful information and solutions but is written in an easy to read style. Lesen Sie weiter...
Am 21. Mai 1999 veröffentlicht
excellent advanced SQL book
If you are conversant with SQL, this is a great book to buy. This book has all kinds of advice for finessing SQL for power users. Lesen Sie weiter...
Am 12. Mai 1999 veröffentlicht
new edition of a classic <g>
This is a new edition which expands the programming tips from the first edition and removes the theoretical content (theory is now covered in DATA & DATABASES).
Veröffentlicht am 22. April 1999 von 71062.1056@compuserve.com
Kunden diskutieren
|
Das Forum zu diesem Produkt
Fragen stellen, Meinungen austauschen, Einblicke gewinnen Aktive Diskussionen in ähnlichen Foren
Kundendiskussionen durchsuchen
|
Ähnliche Foren
|
||||||||||||||||||||||||||||||||||
Lieblingslisten
|
|
Ähnliche Artikel finden
Anhand des Sachgebietes nach ähnlichen Produkten suchen:
Ihr Kommentar
Möchten Sie die Produktinformationen aktualisieren oder Feedback zu den Produktabbildungen geben?
|
