Neu kaufen

oder
Loggen Sie sich ein, um 1-Click® einzuschalten.
oder
Mit kostenloser Probeteilnahme bei Amazon Prime. Melden Sie sich während des Bestellvorgangs an.
Gebraucht kaufen
Gebraucht - Wie neu Informationen anzeigen
Preis: EUR 8,56

oder
 
   
Jetzt eintauschen
und EUR 0,99 Gutschein erhalten
Eintausch
Alle Angebote
Möchten Sie verkaufen? Hier verkaufen
Der Artikel ist in folgender Variante leider nicht verfügbar
Keine Abbildung vorhanden für
Farbe:
Keine Abbildung vorhanden

 
Den Verlag informieren!
Ich möchte dieses Buch auf dem Kindle lesen.

Sie haben keinen Kindle? Hier kaufen oder eine gratis Kindle Lese-App herunterladen.

Guru's Guide to SQL Server Stored Procedures [Englisch] [Taschenbuch]

Ken Henderson

Statt: EUR 48,19
Jetzt: EUR 48,03 kostenlose Lieferung. Siehe Details.
  Alle Preisangaben inkl. MwSt.
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Nur noch 1 auf Lager (mehr ist unterwegs).
Verkauf und Versand durch Amazon. Geschenkverpackung verfügbar.
Lieferung bis Mittwoch, 23. April: Wählen Sie an der Kasse Morning-Express. Siehe Details.

Weitere Ausgaben

Amazon-Preis Neu ab Gebraucht ab
Taschenbuch EUR 48,03  

Kurzbeschreibung

27. Dezember 2001
SQL Server developers worldwide raved about Ken Henderson's The Guru's Guide to Transact-SQL: its exceptionally clear, conversational explanations, and its powerfully useful projects and code examples. This book helps SQL Server developers take the next step -- building more powerful, robust applications than ever before. Henderson identifies several key areas of SQL Server development that offer the greatest power -- and then covers each of them in exceptional detail. The book includes especially thorough coverage of Transact-SQL stored procedure programming, including features such as extended procedures, database design, and XML that are often disregarded in competitive books. Henderson introduces a method he has developed to add arrays to T-SQL, something previously thought impossible. He offers an ideal balance of theory and code, gradually building on basic techniques to create increasingly sophisticated solutions, and teaching the philosophy of Transact-SQL programming alongside syntax and technique. An accompanying CD-ROM includes extensive source code, including valuable proprietary code that makes T-SQL queries run faster. For every SQL Server developer.

Hinweise und Aktionen

  • 5-EUR-Gutschein für Drogerie- und Beauty-Artikel:
    Kaufen Sie für mind. 25 EUR aus den Bereichen PC-und Videogames, Musik, DVD/Blu-ray und Hörbücher sowie Kalender und Fremdsprachige Bücher ein; der 5-EUR-Gutschein wird in Ihrem Amazon-Konto automatisch nach Versand der Artikel hinterlegt. Die Aktion gilt nicht für Downloads. Zur Aktion| Weitere Informationen (Geschäftsbedingungen)

Wird oft zusammen gekauft

Guru's Guide to SQL Server Stored Procedures + The Guru's Guide to Transact-SQL
Preis für beide: EUR 100,13

Die ausgewählten Artikel zusammen kaufen
  • The Guru's Guide to Transact-SQL EUR 52,10

Kunden, die diesen Artikel gekauft haben, kauften auch


Produktinformation


Mehr über den Autor

Entdecken Sie Bücher, lesen Sie über Autoren und mehr

Produktbeschreibungen

Synopsis

SQL Server developers worldwide raved about Ken Henderson's The Guru's Guide to Transact-SQL: its exceptionally clear, conversational explanations, and its powerfully useful projects and code examples. This book helps SQL Server developers take the next step -- building more powerful, robust applications than ever before. Henderson identifies several key areas of SQL Server development that offer the greatest power -- and then covers each of them in exceptional detail. The book includes especially thorough coverage of Transact-SQL stored procedure programming, including features such as extended procedures, database design, and XML that are often disregarded in competitive books. Henderson introduces a method he has developed to add arrays to T-SQL, something previously thought impossible. He offers an ideal balance of theory and code, gradually building on basic techniques to create increasingly sophisticated solutions, and teaching the philosophy of Transact-SQL programming alongside syntax and technique. An accompanying CD-ROM includes extensive source code, including valuable proprietary code that makes T-SQL queries run faster. For every SQL Server developer.

Buchrückseite

"This is a book that deserves a prominent place by anyone who aspires to be a real professional developer of SQL Server applications."

--from the Foreword by Ron Soukup

The message of this book is that building stored procedures in Transact-SQL is very much like building programs in any other language. It requires the same type of skill, planning, attention to detail, and overall grasp of technology that successful development in other languages requires. To master Transact-SQL, one must first master the fundamental concepts of software development, then build on this foundation by embracing and studying Transact-SQL as a programming language in its own right. This book teaches you how to do that and more.

More than just a catalog of coding tricks and syntax subtleties, The Guru's Guide to SQL Server(TM) Stored Procedures, XML, and HTML explores the philosophy of Transact-SQL programming. It teaches readers how to apply this philosophy in order to develop their own coding techniques and discover their own solutions to real-world programming problems. A follow-up to the widely acclaimed The Guru's Guide to Transact-SQL, this book teaches that stored procedure development does not occur in a vacuum--it involves a wide variety of skills, subjects, and technologies--and helps the reader become a better software engineer, not just a stored procedure expert.

Blending theoretical detail with practical application, this comprehensive reference begins with a foundational overview of SQL Server(TM) stored procedure programming. From there, the focus moves on to best practices and design considerations before progressing to advanced topics and a general philosophy of software craftsmanship. In all, this book provides the most complete coverage of SQL Server stored procedure programming available in one source.

Topics such as user-defined functions, views, triggers, extended procedures, error handling, OLE Automation, database design, and XML are covered in detail. The book spotlights undocumented language features and brings the first application of design patterns to the SQL language. The preview of .NET and a groundbreaking approach to adding arrays to Transact-SQL make for the most thorough and engaging read published to date on SQL Server programming.

The accompanying CD-ROM contains the book's source code. More than 700 SQL scripts, programming utilities, and extended procedures provide a veritable treasure trove of high-quality example code.

Theoretically sound, yet immensely practical, The Guru's Guide to SQL Server(TM) Stored Procedures, XML, and HTML provides developers with the tools they need to become expert stored procedure programmers and better software engineers.



0201700468B11262001

In diesem Buch (Mehr dazu)
Einleitungssatz
Working from the assumption that the human brain learns by associating new data with what it already knows, we'll spend this chapter building a base framework onto which we can assemble the knowledge conveyed by the remainder of the book. Lesen Sie die erste Seite
Mehr entdecken
Wortanzeiger
Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis | Rückseite
Hier reinlesen und suchen:

Eine digitale Version dieses Buchs im Kindle-Shop verkaufen

Wenn Sie ein Verleger oder Autor sind und die digitalen Rechte an einem Buch haben, können Sie die digitale Version des Buchs in unserem Kindle-Shop verkaufen. Weitere Informationen

Kundenrezensionen

Es gibt noch keine Kundenrezensionen auf Amazon.de
5 Sterne
4 Sterne
3 Sterne
2 Sterne
1 Sterne
Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)
Amazon.com: 4.6 von 5 Sternen  84 Rezensionen
119 von 124 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Henderson takes it to a new level 12. Januar 2002
Von Donald Farris - Veröffentlicht auf Amazon.com
Format:Taschenbuch
I never thought I'd say this but this book is even better than the first Gurus Guide book! Henderson cuts loose and just writes. It feels like you've got the guru sitting right next to as you read.
As with his first book, Henderson runs a tight ship with this one. There's no fluff or other filler material. Instead, you just get the goods, and you get them by the boatload.
My fav things about this one are:
* Extended Proc coverage. I've always wondered how to build these. The coverage in this book is absolutely excellent. It could be a book unto itself.
* XML coverage. I've never seen a better cut-to-the-chase introduction to XML and the XML features in SQL Server. It's a wonderful, hands-on tutorial written by a master.
* Emphasis on treating transact-sql as a real language. Henderson stresses this over and over and he's right. This book is every bit as good as the high-end programming books that feature languages like C++ and Java.
* Essays on software engineering. These are some of the best technical writing I've ever read.
I don't think you could spend your money on a better SQL Server book.
DjF
110 von 116 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Another great Ken Henderson SQL book 7. März 2002
Von John Lennox - Veröffentlicht auf Amazon.com
Format:Taschenbuch
I bought the first Guru's Guide -- The Guru's Guide to Transact SQL -- as a way to fine-tune my SQL skills when I began a new job as a SQL Server Admin / Developer. Nearly two years later, I still find myself reaching for that book for almost every unique SQL problem that I encounter, and I am rarely disappointed. When I saw that Henderson had written another SQL book, I expected another winner. I was not disappointed.
The coverage of stored procedures, user-defined functions, and XML was first-rate. And the relatively short chapter on .NET was loaded with reasons why every SQL Server developer should be embracing this new techology.
The Essays on Software Engineering were extremely well-written. The intermingling of personal experiences and reflection with the technical details of the topics was done just right. It added a certain amount of relevance to the section that made it feel less like a theoretical lecture and more like the sharing of information by a well-respected colleague. One who has obviously experienced these things and knows what he is talking about. On the surface, these essays may seem a bit out of place in a book about Stored Procedures and XML but, in fact, they fit very well with the overall theme of the book: SQL and Stored Procedure development is "real" software engineering and needs to be treated as such if you are going to be good at it.
34 von 37 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen For professional developers 28. Mai 2004
Von Ein Kunde - Veröffentlicht auf Amazon.com
Format:Taschenbuch
It's funny that no one thought of this before but the book has a message that is unique and new...writing code for Sql Server has to be approached like writing code for any other platform: as an engineering discipline. I had never heard this preached until I red this book, but am now a firm beleiver in it.
I have Henderson's other book and this one is a nice follow-up. there is naturaly some overlap between this book and the TSql book but not much. this one gets into coding conventions and version control, extended procs, design patterns and of course SqlXml...things the first book doesn't talk about. I look at this book as the big brother to the first one. It's more serious and more for the professional developer as opposed to being more of a dictionary of solutions to difficult TSql problems.
I also really liked the undocumented TSql chapter. This was my favorite chapter in Henderson's last book and this version of it has some new tricks and secrets. Just knowing about these will make you a better DBA because you will have a better understanding of what is happening under the hood.
16 von 17 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen A masterful book written by a master coder 11. Januar 2003
Von Ein Kunde - Veröffentlicht auf Amazon.com
Format:Taschenbuch
Words can't begin to express what this book has meant to me. I am a developer who came to Sql Server late in life after a career writing COBOL, then DBase/Clipper, then FoxPro. I've watched the industry change, but have never really had the handle on all of it that this guy does. The book is ingenious. It takes Transact-Sql and gives it the hardcore language treatment. No one has ever done that before. I have all the other T-Sql books and, with the exception of Henderson's previous book, none come close to this one. You take Henderson's two Sql Server books and you have all you need to master Sql Server's programming language, Transact-Sql. Who talks about version control with Transact-Sql? Henderson does. Who gets into design patterns in stored procedures? Henderson does. Who discusses testing at length in an Sql book? Henderson does. Who shows how to add useful features to the language such as native array handling? Henderson does. Who would dare discuss how .NET relates to T-Sql development? Henderson does. Who talks about how eXtreme Programming applies to T-Sql developers? You know the answer. This is THE book to have if you want to master the T-Sql language.
24 von 28 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen One of the best programming books I have ever read 20. Februar 2002
Von Ein Kunde - Veröffentlicht auf Amazon.com
Format:Taschenbuch
This is the first SQL Server book that I can call a "real" programming book. It's not surprising that it comes from Addison-Wesley, the most prominent publisher of such books. In the spirit of Kernighan and Ritchie, Pike, Thomas and Hunt, Jon Bentley, and Erich Gamma, this is a thinker's Transact-SQL programming book.
It begins with a wonderful overview of all that is worth knowing about stored procedure programming in Transact-SQL. This is the best "in a nutshell" discussion I've seen of stored procedure programming. It is better than most whole books dedicated to the subject.
It moves on to coding conventions and source code management, two oft-neglected topics in the world of SQL Server. For some reason, most of us don't usually treat Transact-SQL as though it were true source code, but Henderson makes the compelling case that it is indeed, and he has convinced me.
Next, is one of the crown jewels of the book: design patterns. For anyone who has read any of the patterns books out there (e.g., Erich Gamma, John V., etc.), this will seem like an epiphany. You'll go, "Of course! Why didn't I think of that?!"
From here, we move on to database design. This is the best hands-on, practical guide to database design that I've ever seen. Henderson distills, in one chapter, all that you need to know to build complex business models, entity-relationship diagrams, and relational data models. What I like most about this is that Henderson doesn't start with physical modeling. He starts with the business processes the app that will use the database must encompass, then shows how to extrapolate business process flow charts, E-R diagrams, logical data models, and, finally physical data models. You start with nothing but an application concept and end up with a fully-functional SQL Server database. If you ever wanted to learn database modeling and design from the ground-up, this is your chance.
Next, is the objects section. Here, individual chapters cover Views (normal, partitioned and indexed), UDFs (lots of great code here including how to create your own system and vector functions -- e.g., MEDIAN()), triggers (normal, instead of, auditing), and error handling. Transact-SQL error handling is an oft-misunderstood area of the language. Henderson shines a light on it and shares what the masters know.
The SQLXML section is the second crown jewel of the book. When I saw that Henderson was covering SQLXML in his new book, I guess I should have guessed he would cut no corners, but, honestly, this section by itself is better than every other SQLXML book I've read. That's right - this one section of the book is better than other whole books dedicated to the subject. The introduction to XML is as good a synopsis of the language as you will find. The chapters covering the individual SQLXML features are also better than I've seen elsewhere. In true Henderson tradition, they are readable, in-depth, and thorougly engaging.
The advanced section is exactly that: advanced. Want to learn about how SQL Server interfaces with COM? Look no further -- the chapter even includes a nice, concise introduction to COM itself for those new to it. Want to learn to build extended procs? Look no further. This chapter alone is worth the whole cost of the book. I guess I shouldn't be surprised by now, but it's as in-depth as they come. I'm not even a C++ coder, but I worked through the examples and successfully built my first extended proc.
And I have to commend Henderson on the performance chapter. It's the best I've seen on the subject. It's far clearer and in-depth than what you find in Inside SQL Server 2000, for example.
The arrays chapter is the third crown jewel of the book. The technique of using extended procs and UDFs to add array support to the T-SQL language is ingenius. I'll bet Henderson could sell this code commercially if he wanted.
And the final crown jewel is the set of essays at the end of the book. What clear, lucid, lively, enjoyable prose. Henderson is one of the great technical writers of our generation. He spreads his wings a bit in these chapters and shows just what a great wordsmith he really is. Regardless of whether you're talking technical or nontechnical books, fiction or nonfiction, you will not find better writing than this. I think he should consider branching out into other kinds of writing because he obviously has the ability.
In sum: this book elevates Transact-SQL to the plateau of "real" languages such as Java, Pascal, and C++. It is the first "thinker's" coding book I've seen for Transact-SQL stored procedure development and among the best programming books I've ever read. It is a worthy successor to "The Guru's Guide to Transact-SQL."
Waren diese Rezensionen hilfreich?   Wir wollen von Ihnen hören.
ARRAY(0xa7c18a38)

Kunden diskutieren

Das Forum zu diesem Produkt
Diskussion Antworten Jüngster Beitrag
Noch keine Diskussionen

Fragen stellen, Meinungen austauschen, Einblicke gewinnen
Neue Diskussion starten
Thema:
Erster Beitrag:
Eingabe des Log-ins
 

Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen
   


Ähnliche Artikel finden


Ihr Kommentar