|
||||||||||||||||||||
|
||||||||||||||||||||
|
||||||||||||||||||||
The Guru's Guide to Transact-SQL
und über 1 Million weitere Bücher verfügbar für Amazon Kindle .
Erfahren Sie mehr
| |||||||||||||||
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 Ken Henderson auf Amazon
› Besuchen Sie die Seite von Ken Henderson auf Amazon
Produktbeschreibungen
Kurzbeschreibung
Since its introduction over a decade ago, the Microsoft SQL Server query language, Transact-SQL, has become increasingly popular and more powerful. The current version sports such advanced features as OLE Automation support, cross-platform querying facilities, and full-text search management. This book is the consummate guide to Microsoft Transact-SQL. From data type nuances to complex statistical computations to the bevy of undocumented features in the language, The Guru's Guide to Transact-SQL imparts the knowledge you need to become a virtuoso of the language as quickly as possible. In this book, you will find the information, explanations, and advice you need to master Transact-SQL and develop the best possible Transact-SQL code. Some 600 code examples not only illustrate important concepts and best practices, but also provide working Transact-SQL code that can be incorporated into your own real-world DBMS applications. Your journey begins with an introduction explaining language fundamentals such as database and table creation, inserting and updating data, queries, joins, data presentation, and managing transactions. Moving on to more advanced topics, the journey continues with in-depth coverage of: * Transact-SQL performance tuning using tools such as Query Analyzer and Performance Monitor * Nuances of the various T-SQL data types * Complex statistical calculations such as medians, modes, and sliding aggregates * Run, sequence, and series identification and interrogation * Advanced Data Definition Language (DDL) and Data Management Language (DML) techniques * Stored procedure and trigger best practices and coding methods * Transaction management * Optimal cursor use and caveats to look out for * Full-text search * Hierarchies and arrays * Administrative Transact-SQL * OLE Automation * More than 100 undocumented commands and language features, including numerous unpublished DBCC command verbs, trace flags, stored procedures, and functions Comprehensive, written in understandable terms, and full of practical information and examples, The Guru's Guide to Transact-SQL is an indispensable reference for anyone working with this database development language. The accompanying CD-ROM includes the complete set of code examples found in the book as well as a SQL programming environment that will speed the development of your own top-notch Transact-SQL code.
Synopsis
In The Guru's Guide to Transact-SQL, one of the world's leading Microsoft SQL Server 7 developers has written the ideal combination of tutorial and reference, bringing together all the information and skills developers need to create outstanding database applications. Beginners and intermediate developers will appreciate the comprehensive tutorial that walks step-by-step through building a real client/server database, from concept to deployment and beyond -- and points out key pitfalls to avoid throughout the process. Experienced users will appreciate the book's comprehensive coverage of the Transact-SQL language, from basic to advanced level; detailed ODBC database access information; expert coverage of concurrency control, and more. The book includes thorough, up-to-the-minute guidance on building multi-tier applications; SQL Server performance tuning; and other crucial issues for advanced developers. For all database developers, system administrators, and Web application developers who interact with databases in Microsoft-centric environments.
Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?
In diesem Buch
(Mehr dazu)
Einleitungssatz
SQL is the lingua franca of the database world. Lesen Sie die erste Seite Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis | Rückseite
SQL is the lingua franca of the database world. Lesen Sie die erste Seite Ausgewählte Seiten ansehen
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis | Rückseite
Tags(Was ist das?)Bei einem Tag handelt es sich um ein Schlagwort, das zum Produkt passt.
Tags erleichtern allen Kunden die Suche und die Sortierung ihrer Lieblingsprodukte. |
Kundenrezensionen
Die hilfreichsten Kundenrezensionen
1 von 1 Kunden fanden die folgende Rezension hilfreich
Format:Taschenbuch
Ah, where to begin. This book is a masterpiece. It is over the top. It distills, in one volume, all that's worth knowing about advanced Transact-SQL. If you've read the Books Online, this book is a natural next step in your T-SQL education. It took me from a rank amateur to an advanced coder within days. It gave me insights into new ways of coding that I'd never have thought of on my own. It showed me how to work in harmony with T-SQL and SQL Server, rather than try to get them to do things they weren't designed to do.
The best chapters, are, IMHO, these:
- DML Insights
- DDL Insights
- The Mighty SELECT
- Statistical Functions
- Transactions
- Cursors
- Sets
- Arrays
- Stored Procedures and Triggers
- T-SQL Performance Tuning
- Administrative T-SQL
- OLE Automation
- Undocumented T-SQL
There's so much good info in this book, it's hard to pick a list of the "best chapters." To be sure, there's not a weak chapter in the book, and you should read every last one of them.
Another reviewer called this book the ultimate magnum opus for T-SQL. He was right. This book is a must-read for anyone serious about coding in Transact-SQL.
1 von 1 Kunden fanden die folgende Rezension hilfreich
Format:Taschenbuch
I love this book because it's so practical. It doesn't have the obligatory fluff that most computer books have. It cuts to the chase and gets right down to business immediately. I like that. And I like the fact that it focuses on things not in the Books Online. Want to learn how to do full-text searching from Transact-SQL? See Chapter 18. Want to learn how cursors really work and when you should and shouldn't use them? See Chapter 14. Want to learn advanced techniques and pitfalls to watch out for? See Chapter 15. This book has it all. If you want to become an expert SS practitioner, get this book.
1 von 1 Kunden fanden die folgende Rezension hilfreich
Format:Taschenbuch
This is a wonderfully insightful book. I learned more in the first chapter than I've learned in the entirety of other SQL books. For example, I learned that row positioning problems (e.g., computing a median) don't require a cursor. This one insight alone opened a whole new way of coding SQL for me. I learned how transactions *really* work - something no other book gave me. I carry this book to and from the office with me - that should tell you how much I value it.
Möchten Sie weitere Rezensionen zu diesem Artikel anzeigen?
Waren diese Rezensionen hilfreich?
Wir wollen von Ihnen hören.
Die neuesten Kundenrezensionen
Took me from a novice to a virtuoso almost overnight
What I like about this book is how concentrated it is. There's not a wasted word in it. Everything you need to know to master Transact-SQL can be found herein. Lesen Sie weiter...
Veröffentlicht am 18. September 2000 von Harry Fuller
One of the top technology books I've ever read
This book is dynamite! I was blown away by all the code. It's a treasure trove of good SQL that you can put to use immediately. Lesen Sie weiter...
Veröffentlicht am 20. Juli 2000 von James Faust
The ultimate T-SQL book
I have all the T-SQL books out there, and this one is by far the best of the lot. In fact, it's one of the best tech books I've ever purchased. Lesen Sie weiter...
Veröffentlicht am 19. Juli 2000 von Jake Stills
Worth TEN TIMES the price!
What a goldmine! I started learning the first day I opened this book and haven't stopped yet. This is one dense book. I appreciate the author's avoidance of filler material. Lesen Sie weiter...
Veröffentlicht am 19. Juli 2000 von Sven Bergen
A wonderful book, the best of its kind
This book is chalk-full of useful example code. There are over 600 sample scripts - far more than any other SQL book. Lesen Sie weiter...
Veröffentlicht am 19. Juli 2000 von James Taven
Didn't appeal to me - I wish I hadn't bought it!
I can't understand why this book has been so highly rated. I bought it on the basis of the other reviews. I have found it lacking in all the areas I have needed to look up. Lesen Sie weiter...
Veröffentlicht am 17. Juli 2000 von W. J. Vovil
The first T-SQL book I turn to
I'm a consultant working with SQL Server for several years now and I'm using T-SQL more and more each day. Lesen Sie weiter...
Am 5. Juli 2000 veröffentlicht
Absolutely Brilliant!
I found The Guru's Guide to be one of the best computer books I've ever had the privilege to read. It is not just another computer book. Lesen Sie weiter...
Veröffentlicht am 16. Juni 2000 von Steve Mulluck
A wonderful book
I like this book because it's honest. The author is obviously more than just a DBA -- he's obviously a software craftsman in his own right. Lesen Sie weiter...
Veröffentlicht am 30. Mai 2000 von Jean Purdue
Celko's right -- it's the best T-SQL book out there
Joe Celko's foreword to this book is exactly right: it's the best book out on Transact-SQL, bar none. More than that, this is a great book in general. Lesen Sie weiter...
Veröffentlicht am 26. Mai 2000 von David Simms
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?
|
