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
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
|
Sagen Sie Ihre Meinung zu diesem Artikel:
|
||||||||||||||||||||||
|
Die hilfreichsten Kundenrezensionen
1 von 1 Kunden fanden die folgende Rezension hilfreich:
5.0 von 5 Sternen
If you want to become a T-SQL guru yourself, get this book,
Von Chris J. Parsons (Nevada) - Alle meine Rezensionen ansehen
Rezension bezieht sich auf: The Guru's Guide to Transact-SQL (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. Helfen Sie anderen Kunden bei der Suche nach den hilfreichsten Rezensionen
1 von 1 Kunden fanden die folgende Rezension hilfreich:
5.0 von 5 Sternen
The best practical guide on Transact-SQL around,
Von Shawn B. (Santa Cruz, CA) - Alle meine Rezensionen ansehen
Rezension bezieht sich auf: The Guru's Guide to Transact-SQL (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.
Helfen Sie anderen Kunden bei der Suche nach den hilfreichsten Rezensionen
1 von 1 Kunden fanden die folgende Rezension hilfreich:
5.0 von 5 Sternen
Comprehensive, brilliant, witty, insightful...,
Von Bill T. Evans (Pasadena, CA) - Alle meine Rezensionen ansehen
Rezension bezieht sich auf: The Guru's Guide to Transact-SQL (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.
Helfen Sie anderen Kunden bei der Suche nach den hilfreichsten Rezensionen
Sagen Sie Ihre Meinung zu diesem Artikel: Eigene Rezension erstellen
|
Die neuesten Kundenrezensionen |
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?
|
