Pro T-SQL 2012 Programmer's Guide and over 2 million other books are available for Amazon Kindle . Learn more
£39.50
FREE Delivery in the UK.
In stock.
Dispatched from and sold by Amazon.
Gift-wrap available.
Quantity:1
Pro T-SQL 2012 Programmer... has been added to your Basket
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Pro T-SQL 2012 Programmer's Guide (Expert's Voice in SQL Server) Paperback – 21 Sep 2012


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
£39.50
£30.61 £37.57
£39.50 FREE Delivery in the UK. In stock. Dispatched from and sold by Amazon. Gift-wrap available.

Frequently Bought Together

Pro T-SQL 2012 Programmer's Guide (Expert's Voice in SQL Server) + Microsoft SQL Server 2012 High Performance T-SQL Using Window Functions (Developer Reference)
Price For Both: £62.49

Buy the selected items together


Product details

  • Paperback: 696 pages
  • Publisher: Springer Verlag GmbH; New edition (21 Sept. 2012)
  • Language: English
  • ISBN-10: 1430245964
  • ISBN-13: 978-1430245964
  • Product Dimensions: 19 x 4 x 23.5 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: 769,476 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

About the Author

Michael Coles has more than a decade's experience designing and administering SQL Server databases. A prolific writer of articles on all aspects of SQL Server, particularly on the expert use of T-SQL, he holds MCDBA and MCP certifications. He graduated magna cum laude with a bachelor of science degree in information technology from American Intercontinental University in Georgia. A member of the United States Army Reserve, he was activated for two years following 9/11.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Customer Reviews

4.0 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

1 of 1 people found the following review helpful By Ian Stirk on 19 Oct. 2013
Format: Paperback
I have written a chapter-by-chapter review of this book on "www i-programmer info" the first part of this review follows:

This book aims to provide SQL developers with knowledge to get the most out of SQL Server 2012. How does it fare?

From the book's title I expected an in-depth discussion of the various aspects of the T-SQL programming language from a SQL Server 2012 perspective. Even the blurb on the publisher's website says "Pro T-SQL 2012 Programmer's Guide is every developer's key to making full use of SQL Server 2012's powerful, built-in Transact-SQL language." However, this book is NOT a discussion about T-SQL specifically, rather it is a guide to SQL Server 2012's functionality from a developer's viewpoint. The book's title is misleading.

The book is aimed at SQL developers wanting to get up to speed on functionality in the later releases of SQL Server, and also those developers coming to SQL Server from other platforms. So it is not an introductory book. Read on for a chapter-by-chapter exploration of the topics covered.

Chapter 1 Foundations of T-SQL
The chapter provides an overview of how SQL has developed, its basic structure, and the importance of coding style. A brief summary of the development of Codd's relational model is given. The difference between declarative (e.g. SQL) and imperative (e.g. C) languages is highlighted - i.e. WHAT to do as opposed to HOW to do it. The basic constituents of SQL are outlined in discussing schemas, tables, indexes, stored procedures, user-defined functions, 3-value logic, etc. This is followed by a review of the importance of coding style and formatting. This is a good overview of where SQL came from and its major components.

Chapter 2 Tools of the Trade...
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback Verified Purchase
The coverage and depth in this book do not go beyond the material found in Microsoft’s official product documentation, e.g., ‘Books Online’ (BOL) on MSDN. What this book adds to the material found in BOL is a good structure, and that makes it a well-written, comprehensive, intermediate level textbook with very similar content as the official product documentation.

It is suitable for developers who need a first overview of a subject area, but in many cases the book will only be a starting point to make a decision whether a technology may be useful in solving a problem or not, because it does not offer an in-depth discussion of subjects.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback Verified Purchase
The content within the book is very good. However, the print quality could have been improved. The font size and the pictures although legible, are not great as it puts additional pressure on eyes while reading the book, especially for a spectacled person like me. I have deducted 2 stars because of print quality only. From an advanced knowledge perspective, this book is excellent.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 4 reviews
4 of 4 people found the following review helpful
Great piece for the serious programmer looking to expand his/her knowledge base 15 Nov. 2012
By Charles Settle - Published on Amazon.com
Format: Paperback Verified Purchase
The book is great! Great references throughout so you can research further on every subject; the authors basically hold your hand through learning sql and provide plenty of code examples for explicit learning, also abstract concepts of programming in T-SQL are discussed. This book can take a programmer to the "next level" if they read thoroughly. Great work, should be taught in colleges and universities to give potential programmers real-world examples, basic principles, and concrete, syntax knowledge of a widely used language, T-SQL. the subject matter of the book gets very deep and complex, all good attributes if you are trying to be a programmer who can write deep and complex code/work on real-world projects.
2 of 2 people found the following review helpful
SQL Server 2012's functionality from a developer's viewpoint 19 Oct. 2013
By Ian Stirk - Published on Amazon.com
Format: Paperback
Hi,

I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.

This book aims to provide SQL developers with knowledge to get the most out of SQL Server 2012. How does it fare?

From the book's title I expected an in-depth discussion of the various aspects of the T-SQL programming language from a SQL Server 2012 perspective. Even the blurb on the publisher's website says "Pro T-SQL 2012 Programmer's Guide is every developer's key to making full use of SQL Server 2012's powerful, built-in Transact-SQL language." However, this book is NOT a discussion about T-SQL specifically, rather it is a guide to SQL Server 2012's functionality from a developer's viewpoint. The book's title is misleading.

The book is aimed at SQL developers wanting to get up to speed on functionality in the later releases of SQL Server, and also those developers coming to SQL Server from other platforms. So it is not an introductory book. Read on for a chapter-by-chapter exploration of the topics covered.

Chapter 1 Foundations of T-SQL
The chapter provides an overview of how SQL has developed, its basic structure, and the importance of coding style. A brief summary of the development of Codd's relational model is given. The difference between declarative (e.g. SQL) and imperative (e.g. C) languages is highlighted - i.e. WHAT to do as opposed to HOW to do it. The basic constituents of SQL are outlined in discussing schemas, tables, indexes, stored procedures, user-defined functions, 3-value logic, etc. This is followed by a review of the importance of coding style and formatting. This is a good overview of where SQL came from and its major components.

Chapter 2 Tools of the Trade...

Conclusion
From a developer's perspective, I found this book an enjoyable read, with lots of useful example code, having wide-ranging and in-depth coverage of the major SQL Server features. It will certainly get developers from previously versions of SQL Server or from other platforms up-to-speed, but be aware it is not a book for beginners. Although the book relates to SQL Server 2012, it covers features introduced from 2005 onwards, for example the use of the CLR hasn't really changed since 2005.

The summaries and exercises at the end of each chapter are good for revision and understanding. Most of the references for further information tend to refer to Apress's own titles, this is perhaps understandable from the publisher's perspective, but wider references would have been useful.

As a book solely about T-SQL 2012, I would award a rating of 2.5, as a book about SQL Server 2012 from a SQL developer's perspective, I would rate it 4.5. Recommended.
2 of 2 people found the following review helpful
Excellent Resource 1 Feb. 2013
By Kaldran - Published on Amazon.com
Format: Paperback Verified Purchase
An advanced book. You will need to be fairly familiar with T-SQL to get the most out of this book.
I was pleased to be able to find answers quickly and found ... 19 Dec. 2014
By James Snyder - Published on Amazon.com
Format: Paperback Verified Purchase
I bought this book because I got a job where I was suddenly required to use T-SQL, something I haven't used this century. I was pleased to be able to find answers quickly and found explanations easy to understand.
Were these reviews helpful? Let us know


Feedback