|
Beginning T-SQL with Microsoft SQL Server 2005 and 2008 (Wrox Programmer to Programmer) |  | Authors: Paul Turley, Dan Wood
Publisher: Wrox
Category: Book
List Price: $39.99
Buy New: $22.95
as of 7/30/2010 03:42 CDT details
You Save: $17.04 (43%)
New (27) Used (9) from $22.95
Seller: psimplicity
Rating:  4 reviews
Sales Rank: 183535
Media: Paperback
Edition: Pap/Dig
Pages: 672
Number Of Items: 1
Shipping Weight (lbs): 2.1
Dimensions (in): 8.9 x 7.4 x 1.5
ISBN: 0470257032
Dewey Decimal Number: 005
EAN: 9780470257036
ASIN: 0470257032
Publication Date: December 10, 2008
Availability: Usually ships in 1-2 business days
| |
| Features:
| • | ISBN13: 9780470257036 | | • | Condition: New | | • | Notes: BUY WITH CONFIDENCE, Over one million books sold! 98% Positive feedback. Compare our books, prices and service to the competition. 100% Satisfaction Guaranteed |
|
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
If you have never programmed with T-SQL but have some background programming knowledge and experience, Beginning T-SQL with Microsoft SQL Server 2005 and 2006 will provide you with an overview of SQL Server query operations and tools used with T-SQL, Microsoft's implementation of the SQL database query language. Review basic query language commands and syntax, learn how to design and build applications, and understand how to optimize query performance. Improve your skills with the most up-to-date T-SQL guide, which provides hands-on examples and instructions to guide you through the process.
|
| Customer Reviews:
Good TSQL coverage, with some not so good advice February 3, 2010
K. Ambrose (San Francisco, CA United States)
1 out of 1 found this review helpful
As a db professional for many years, I bought this to bring me up to speed on the 2005 and 2008 new features and tsql, and I feel it is serving that purpose well for me (I have not yet completed the book). The subject areas are well organized and well covered, and I find the writing style to be lucid and very readable.
I did notice what I consider to be some poor advice (hence only 4 star rating) related to data typings- specifically the advice to use numeric data type for data that would never make sense to apply mathematical operations. The author's rationale' for this is that numeric data is preferred for sorting and comparison over character data.
The flaw in that approach is thinking that a fast answer is better than a correct answer. And also that a fast answer is preferable over user's confusion on the meaning and use of a data item over the course of it's useful life.
Anyone who has been supporting data processing for years will know that half the battle is in keeping the semantics (meaning) of the data that is stored in the DB clear to all stakeholders in an enterprise.
Applying numeric data type to data where mathematical operations on it will produce nonsense practically guarantees that such nonsense will be at least attempted, and perhaps even distributed at some point in an organization. What is the meaning of adding two phone numbers together? Or two social security numbers? It's nonsense. In addition, it is not at all impossible over the course of time that a business concept that uses numerals but is not mathematical may need to include non-numeric characters at a later time- after all it is not mathematical data. When that happens you will be in for a big hassle if you have to change the type for a lot of data.
There are few more fundamental and important needs in database design than getting data types "right". It's too bad this book offers a bit of poor advice in that area.
Kiss your beginner status goodbye... November 29, 2009
ewomack (MN USA)
1 out of 1 found this review helpful
Microsoft's now ubiquitous SQL Server database engine is far more complicated than it first appears. Apart from the voluminous administrative tasks it can accomplish and support, it provides a vast set of commands for data retrieval and manipulation known as "Transact-SQL" or "T-SQL." In the spirit of Wrox books, this book is big, red, and dedicated to a single topic: this very T-SQL toolset.
Fifteen chapters comprising over 600 pages covers everything a T-SQL beginner needs. Introductory chapters provide background information on Relational Databases, the versions of SQL Server, database normalization, and tools available in SQL Server (many of which are beyond this book's scope).
A detailed discussion of T-SQL syntax finally appears in Chapter 4, but the real meat begins in Chapter 5 with the universal command SELECT. Subsequqnt chapters provide explanations and copious code examples (for both SQL Server 2005 and 2008) for SQL Functions (e.g., AVG(), DATEADD(), CONVERT(), etc.), grouping, joins, subqueries, cursors, transactions (with error handling via TRY and CATCH), the handy but unintuitive PIVOT, a discussion of objects (in database speak this means things such as tables, views, procedures and functions), query optimization (with graphical execution plans) and a concluding chapter that rolls T-SQL into an application development and reporting context. Appendices follow with quick references to the tools discussed.
This is a beginner's book. Although it does delve into what some feel are more advanced topics such as transactions and stored procedures, these receive beginner to intermediate level coverage. In any case, even beginners should have some familiarity with these T-SQL features.
Those new to T-SQL or seeking a refresh will find ample discussions of the basics here. This gargantuan book won't get anyone up to speed quickly, but it provides enough detail so that beginners will exit this book as knowledgeable T-SQL users.
Good basic book September 6, 2009
Scott D. Smith (Milford, OH)
0 out of 1 found this review helpful
I've bought the whole series as you do need a paper based reference with examples to work thru more intricate projects. I would say that I've run into a gap in the series in that there isn't much discussion on what we (*data analyst/programmers) do a lot and that's integrate SQL with MS Office especially Excel. Thin there.
Introduction to SQL Query April 15, 2009
Floyd (VA, USA)
I purchased this book as an introduction to writing query scripts for SQL. We've a large database with many fields and I needed to know how to appropriately join and relate information in a well constructed manner. This book provides starter SQL queries in addition to explaining the foundation of databases (creating, adjusting, queries etc) The query information provided a more descriptive environment than what I had found on the web. A good beginner guide!
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2009, SQL Server 2008 Books. All Rights Reserved.
In association with Amazon.com | |
