Pro T-SQL 2012 Programmer's Guide and over 2 million other books are available for Amazon Kindle . Learn more


or
Sign in to turn on 1-Click ordering.
Trade in Yours
For a £12.75 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Start reading Pro T-SQL 2012 Programmer's Guide on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Pro T-SQL 2012 Programmer's Guide (Expert's Voice in SQL Server) [Paperback]

Michael Coles , Scott Shaw , Jay Natarajan
5.0 out of 5 stars  See all reviews (1 customer review)
Price: £39.50 & FREE Delivery in the UK. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 24 Sep.? Choose Express delivery at checkout. Details

Formats

Amazon Price New from Used from
Kindle Edition £24.82  
Paperback £39.50  
Trade In this Item for up to £12.75
Trade in Pro T-SQL 2012 Programmer's Guide (Expert's Voice in SQL Server) for an Amazon Gift Card of up to £12.75, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

26 Sep 2012 1430245964 978-1430245964 New
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. Discussing new and existing features, the book takes you on an expert guided tour of Transact SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and engaging treatment of Transact SQL into your own hands. Step by step explanations ensure clarity, and an advocacy of best practices will steer you down the road to success.Transact SQL is the language developers and DBAs use to interact with SQL Server. It's used for everything from querying data, to writing stored procedures, to managing the database. New features in T-SQL 2012 include full support for window functions, stored sequences, the ability to throw errors, data paging, and more. All these important new features are covered in this book. Developers and DBAs alike can benefit from the expressive power of Transact-SQL, and Pro T-SQL 2012 Programmer's Guide provides the gateway to success in applying this increasingly important database language to everyday business and technical tasks. What you'll learn Take full advantage of window functions and other new features in T-SQL 2012 Move business logic into the database via procedures and functions Develop using advanced features such as encryption and full-text search Store and retrieve XML data using XQuery and XPath Debug and Optimize T-SQL Execution Build ADO.NET Client Applications Who this book is for Pro T SQL 2012 Programmer's Guide is written for SQL Server and Transact SQL developers who want to implement best practices and take full advantage of all that SQL Server has to offer. NET programmers will find the book helpful in showing how to run .NET code within SQL Server. Database administrators who need to write triggers and the occasional stored procedure will also benefit from the book. Table of Contents Foundati

Frequently Bought Together

Pro T-SQL 2012 Programmer's Guide (Expert's Voice in SQL Server) + SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach (Expert's Voice in SQL Server)
Price For Both: £87.49

Buy the selected items together


Product details

  • Paperback: 696 pages
  • Publisher: Springer Verlag GmbH; New edition (26 Sep 2012)
  • Language: English
  • ISBN-10: 1430245964
  • ISBN-13: 978-1430245964
  • Product Dimensions: 23.4 x 19 x 4.1 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 566,525 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:

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
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?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 5.0 out of 5 stars  3 reviews
4 of 4 people found the following review helpful
5.0 out of 5 stars 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
5.0 out of 5 stars SQL Server 2012's functionality from a developer's viewpoint 19 Oct 2013
By Ian Stirk - Published on Amazon.com
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...

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
5.0 out of 5 stars 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.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

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


Feedback