PRINT
PDF
WORD
CSV
EXCEL
Moocable is learner-supported. When you buy through links on our site, we may earn an affiliate commission.
Description
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.
Books
Addison-Wesley Professional
Exclusively Paid 
14h 36m 
No Certificate 
592 pages The Guru's Guide to Transact-SQL
Affiliate notice
-
Type
-
Provider
-
PricingExclusively Paid
-
Duration14h 36m
-
CertificateNo Certificate
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.
Loading...
Saving...
Loading...