|
Beginning Transact-SQL With SQL Server 2000 and 2005 |  | Author: Paul Turley
Creator: Dan Wood
Publisher: Wrox
List Price: $39.99
Buy New: $5.62
as of 11/22/2009 14:56 CST details
You Save: $34.37 (86%)
New (34) Used (16) from $5.03
Seller: Bookbrothers1
Rating:  4 reviews
Sales Rank: 325367
Media: Paperback
Pages: 600
Number Of Items: 1
Shipping Weight (lbs): 2
Dimensions (in): 9 x 7.4 x 1.4
ISBN: 076457955X
Dewey Decimal Number: 005.74
EAN: 9780764579554
ASIN: 076457955X
Publication Date: October 31, 2005
Availability: Usually ships in 1-2 business days
| |
| Features:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
Beginning Transact-SQL with SQL Server 2000 and 2005 Transact-SQL is a powerful implementation of the ANSI standard SQL database query language. In order to build effective database applications, you must gain a thorough understanding of these features. This book provides you with a comprehensive introduction to the T-SQL language and shows you how it can be used to work with both the SQL Server 2000 and 2005 releases. Beginning with an overview of the SQL Server query operations and tools that are used with T-SQL, the author goes on to explain how to design and build applications of increasing complexity. By gaining an understanding of the power of the T-SQL language, you'll be prepared to meet the ever-increasing demands of programming. What you will learn from this book - How T-SQL provides you with the means to create tools for managing hundreds of databases
- Various programming techniques that use views and stored procedures
- Ways to optimize query performance
- How to create databases that will be an essential foundation to applications you develop later
Who this book is for This book is for database developers and administrators who have not yet programmed with Transact-SQL. Some familiarity with relational databases and basic SQL is helpful, and some programming experience is helpful. Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.
|
| Customer Reviews:
 Does not cover the important new features May 19, 2006
Zeev Atlas
9 out of 14 found this review helpful
I bought the book, based on previous positive critics here (Amazon). The implication was that this book covers the new features of SQL Server 2005. Well, the first one that I was looking for, the PIVOT (crosstab) is not even mentioned, let alone covered even briefly. I did not search all the new features, but if you want a book that cover both old and new features, this one is certainly NOT the one that you should look for.
The publisher rep tried to tell me that no one book could cover all subjects. This is true, but for a book that specialize in T-SQL and T-SQL only, the features should have been covered, or, at least mentioned briefly.
I've found books that cover the new features only, or the old features only. The quest is not over for me, yet.
ZA
 Practical and Usable February 28, 2006
James Counihan
13 out of 13 found this review helpful
The authors have experience both as T-SQL developers and trainers, and it shows. Essential concepts and techniques are explained clearly without talking down to the reader. There's thorough coverage of the most commonly used T-SQL elements, in an easy-to-read style. It's well organized and includes appendices and a good index, making it easy to use as a reference. I work with both SQL Server 2000 and 2005, so it's ideal that the book covers both environments.
There are tons of code samples; most of them use the AdventureWorks database so reproducing them is easy. The exercises at the end of each chapter are good practice - not too difficult, but still good at reinforcing the content (answers are in the back of the book). Parts of my work involve reporting, so I found the chapter on doing Reporting Services development helpful as well. The biggest drawback I've found to this book is that my copy keeps getting borrowed..
Good for non-techie beginners! February 22, 2006
Mareth A. Lee (Seattle, WA)
11 out of 11 found this review helpful
I don't consider myself a techie but recently became interested in learning more about SQL and how it can help me do my job more efficiently. I found the structure, content and style of this book to be very useful in my quest to teach myself the program. It was easy to understand and helped me to learn the basics with a hands-on approach. My lack of experience caught up to me in some of the later chapters but overall I found the book extremely informative and I've benefited greatly from reading it.
Paul Turley takes my TSQL blues away! Great Book!! February 17, 2006
Michael Clara (Seattle, WA USA)
12 out of 13 found this review helpful
Paul's book was incredibly helpful with completing my T-SQL project. I was struggling with reading some stored procedures and DTS packages and couldn't get my brain around what the heck was going on inside management studio. So... I picked up Beginning Transact-SQL and had those sprocs pegged in no time! Paul made following the code a cinch and I'm now able to write and document ETL in no time. Paul's book really was a life (and job..?) saver!
|
|
|
|
Return to Math.com | |
