Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
Beginning T-SQL with Microsoft SQL Server 2005 and 2008
 
 

Beginning T-SQL with Microsoft SQL Server 2005 and 2008 [Kindle Edition]

Paul Turley , Dan Wood
4.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: £23.59
Kindle Price: £17.09 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £6.50 (28%)
* Unlike print books, digital books are subject to VAT.

Formats

Amazon Price New from Used from
Kindle Edition £17.09  
Paperback £23.38  
Kindle Daily Deal
Kindle Daily Deal: At least 60% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Customers Who Bought This Item Also Bought


Product Description

Product Description

If you've not programmed with Transact-SQL, this book is for you.It begins with an overview of SQL Server query operations and tools used with T-SQL, and covers both the 2005 and 2008 releases of SQL Server query tools and the query editor. The book then moves to show you how to design and build applications of increasing complexity. Other important tasks covered include full text indexing, optimizing query performance, and application design and security considerations. The companion website also provides all of the code examples from the book.

Product details

  • Format: Kindle Edition
  • File Size: 10739 KB
  • Print Length: 674 pages
  • Page Numbers Source ISBN: 0470257032
  • Publisher: Wrox; 1 edition (6 Jan 2011)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B004IPPIJG
  • Text-to-Speech: Enabled
  • X-Ray:
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #343,624 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

5 star
0
3 star
0
2 star
0
1 star
0
4.0 out of 5 stars
4.0 out of 5 stars
Most Helpful Customer Reviews
4.0 out of 5 stars Good introductory book on T-SQL 31 Aug 2011
By Nycoy
Format:Paperback|Verified Purchase
I have a bit of knowledge of SQL (from a lot of years ago with Oracle), so bought this to help me get some specific help with T-SQL. It has helped me out with a few problems I had already, so worth the money easily.

Worth a buy for people in similar situation to me, but probably not if you are well versed with SQL programming already.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.5 out of 5 stars  11 reviews
2 of 2 people found the following review helpful
4.0 out of 5 stars Kiss your beginner status goodbye... 29 Nov 2009
By ewomack - Published on Amazon.com
Format:Paperback
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.
3 of 4 people found the following review helpful
4.0 out of 5 stars Good TSQL coverage, with some not so good advice 3 Feb 2010
By K. Ambrose - Published on Amazon.com
Format:Paperback
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.
5.0 out of 5 stars Five Stars 14 July 2014
By Darrell G. Stark - Published on Amazon.com
Format:Paperback|Verified Purchase
This is very thorough with clear language and full explanations.
5.0 out of 5 stars Great book! 22 Jan 2014
By Susan Grafton - Published on Amazon.com
Format:Kindle Edition|Verified Purchase
I've read different parts of this book, mostly in places which applied to specific issues with my query writing. Not to Technical for beginners, very informative and helpful especially those of use who are used to older versions of SQL.
5.0 out of 5 stars Thank you! I it helped me jump from my MySQL to T-SQL in just the right areas 23 May 2013
By Etienne Bley - Published on Amazon.com
Format:Paperback|Verified Purchase
What I needed from the book was, of course, in the last few chapters since I have been using MySQL for years. I told myserlf to go through all the chapters since I have not read a book on this stuff since 1998 as I use it all the time. "Who knows", I thought " I might need a refresher", BUT I forced myself through the first 12 chapters and I discovered many insightful nuggets about how the MS tool works, how it is optimized and therefore the ways I could steer things. They go through optimzation tests and how to these ourselves. The book is very well laid out, and if you do skip, they cover the important things quickly, but they do so with purpose so you won't miss important concepts. VERY well done with great explainations. Keep writing boys!
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Popular Highlights

 (What's this?)
&quote;
A complete unit of information is known as an entity. &quote;
Highlighted by 4 Kindle users
&quote;
This concept of an item or multiple items being related to a different item or multiple items is known as cardinality or multiplicity. &quote;
Highlighted by 3 Kindle users
&quote;
SQL Server uses locks to ensure that multiple users can access data at the same time with the assurance that the data will not be altered while they are reading it. &quote;
Highlighted by 3 Kindle users

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category