- Taschenbuch: 592 Seiten
- Verlag: Addison Wesley Pub Co Inc; Auflage: Pap/Cdr (23. Februar 2000)
- Sprache: Englisch
- ISBN-10: 0201615762
- ISBN-13: 978-0201615760
- Größe und/oder Gewicht: 18,3 x 3 x 23,1 cm
- Durchschnittliche Kundenbewertung: 32 Kundenrezensionen
- Amazon Bestseller-Rang: Nr. 290.392 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
- Komplettes Inhaltsverzeichnis ansehen
Andere Verkäufer auf Amazon
+ GRATIS Lieferung innerhalb Deutschlands
The Guru's Guide to Transact-SQL (Englisch) Taschenbuch – Gekürzte Ausgabe, 23. Februar 2000
|Neu ab||Gebraucht ab|
Kunden, die diesen Artikel gekauft haben, kauften auch
Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.
Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.
Wenn Sie dieses Produkt verkaufen, möchten Sie über Seller Support Updates vorschlagen?
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.
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.
0201615762B04062001 Alle Produktbeschreibungen
Derzeit tritt ein Problem beim Filtern der Rezensionen auf. Bitte versuchen Sie es später noch einmal.
This book is a future classic. It goes on my shelf between Soukup's Inside SQL Server and Joe Celko's SQL for Smarties.
As for technical merits, you will have to look very hard for a better T-SQL book. I have most of the T-SQL books out there and the Guru's Guide beats them hands down. Henderson includes everything but the kitchen sink without being overwrought. I especially like the chapters on cursors and transactions. I never really understood the fine details of transactions until I read this book. Also very handy was the chapter on full text searches via T-SQL. I'd always wanted to know how to use this powerful facility in my own code, but had never really delved into how to go about it. The Guru's Guide makes it easy.
Lastly, I really liked the free T-SQL programming environment the author included. It's apparently one he wrote himself (!) It beats the pants off Query Analyzer, runs faster, and has features we could only dream of in QA (block indention, comment spell check, scripting, keyboard macros, etc., etc.). My team and I have switched to it as our main T-SQL development environment and have realized some real productivity gains in doing so. The author could easily sell this package and make real money from it. If you want a great book and a tremendous CD value, get the Guru's Guide.
The best chapters, are, IMHO, these:
- DML Insights
- DDL Insights
- The Mighty SELECT
- Statistical Functions
- 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.
* The SELECT chapter -- everything you ever wanted to know about the SELECT statement, including many things that you'd never guess it could do
* The statistics chapter -- a cornocopia of techniques for extracting stastical info from large data banks
* The transactions chapter -- at long last, someone has finally spelled out how transactions work, with complete examples for each isolation level and complete explanation for the ramifications of each
* The tuning chapter -- the A-Z of tuning T-SQL queries -- everything from query hints to bcp hints to perfmon and everything in between
* The undocumented chapter -- finally someone has created a one-stop-shopping repository for that hidden info many of us in the business had used, but never had a reference for
I highly recommend this one. If you buy just one SQL Server book, get The Guru's Guide.
* Quotes: each chapter begins with a thoughtful quote. These quotes have a lot to say about the industry as well as learning T-SQL. I think they add a special 'spice' to the book.
* P&T chapter: the chapter on performance and tuning is worthy of its own book. It's a catalog of all the things you can do to speed up your code.
* Undocumented chapter: the secrets revealed by this chapter are true gems. I'm already using many of them.
* Cursors chapter: I liked the story from the trenches about the conversion. I can empathize with the author. It can be frustrating to work with poor developers.
Overall, I'd say this is the best investment you can make with your SQL Server dollar. I like this book even better than Inside SQL Server, which is saying something.
Möchten Sie weitere Rezensionen zu diesem Artikel anzeigen?
Die neuesten Kundenrezensionen