Shop now Shop Clothing clo_fly_aw15_NA_shoes Shop All Shop All Amazon Fashion Cloud Drive Photos Shop Amazon Fire TV Shop now Shop Fire HD 6 Shop Kindle Paperwhite Shop now Shop Now Shop now
Start reading Microsoft SQL Server 2012 T-SQL Fundamentals on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

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

Sorry, this item is not available in
Image not available for
Image not available

Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference) [Kindle Edition]

Itzik Ben-Gan
4.3 out of 5 stars  See all reviews (9 customer reviews)

Kindle Price: £23.27 includes VAT* & free wireless delivery via Amazon Whispernet
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.


Amazon Price New from Used from
Kindle Edition £23.27  
Paperback £21.07  
Celebrate 5 Years of Kindle
Celebrate 5 Years of Kindle: Bestsellers for 99p
For five days starting 2nd September, 2015 we'll reveal a selection of bestsellers from the last 5 years, on sale for 99p for one day only -- come back each day to see the next selection of favourites for 99p. >Shop now

Book Description

Gain a solid understanding of T-SQL—and write better queries

Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft SQL Server 2012. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you’ll quickly learn how to write effective code—whether you’re a programmer or database administrator.

Discover how to:

  • Work with programming practices unique to T-SQL
  • Create database tables and define data integrity
  • Query multiple tables using joins and subqueries
  • Simplify code and improve maintainability with table expressions
  • Implement insert, update, delete, and merge data modification strategies
  • Tackle advanced techniques such as window functions, pivoting and grouping sets
  • Control data consistency using isolation levels, and mitigate deadlocks and blocking
  • Take T-SQL to the next level with programmable objects

Product Description

About the Author

Itzik Ben-Gan is a principal mentor and a founder of SolidQ. A Microsoft MVP for SQL Server since 1999, Itzik teaches and consults internationally on T-SQL querying, programming, and query tuning. He has written numerous articles for SQL Server Magazine and MSDN, and speaks at industry events such as Microsoft TechEd, DevWeek, PASS, and SQL Server Connections.

Product details

  • Format: Kindle Edition
  • File Size: 2117 KB
  • Print Length: 448 pages
  • Simultaneous Device Usage: Up to 5 simultaneous devices, per publisher limits
  • Publisher: Microsoft Press; 1 edition (15 July 2012)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Enhanced Typesetting: Not Enabled
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Bestsellers Rank: #123,251 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Author

Discover books, learn about writers, and more.

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

4.3 out of 5 stars
4.3 out of 5 stars
Most Helpful Customer Reviews
11 of 11 people found the following review helpful
Format:Kindle Edition
Is it a brave move to produce a book on MS SQL in these times? The thought-leaders are all about big data on the network and sqlLite on the device. Or is now the time of the noSql backlash?

Ben-Gan kicks off with a roundup of set theory, the way sql is non-procedural, and even the famous early days of hyprid industry / academics Codd and Date and `third normal form'. Interesting, evocative, and possibly quite useful as background to the way the sql programmer must think.

Then straight into the commands, their application, variance between sql versions, and various gotchas. Whether you find this more or less useful than the online SQL books at, probably depends on your preferred learning mode. There are even excercises after each chapter, like in a school book. But I cannot imagine many people would go to the trouble of learning SQL fundamentals without real-world use cases of their own.

His descriptions are absolutely accurate, to my knowledge. The only single challenge I would make, based on my many years of experience with Microsoft SQL server, is to his assertion that online transactional processing and datawarehousing are best kept separate. In fact the superb query optimisation and parallel access handling of MS SQL server has made that untrue long ago.

The debugging tips puzzled me at first: how can a set-based data manipulation language have bugs? Then I remembered my first few long-ago struggles with some of the more complex ways of joining data sets. The issues would almost always revolve around the use of `null' and its non-intuitive behaviour in logical expressions. If Ben-Gan's advice saves you even a few hours of surfing to resolve such questions, you will have paid for the book.
Read more ›
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
Format:Paperback|Verified Purchase
I had been an Access programmer for several years (where you do QBE - Query By Example). Although you can do some very powerful and sophisticated SQL in MS Access, it is non-standard (in a bad way) and because of the empahsis on the grid you never really learn how to type SQL, which I think is essential to understanding it properly.
I later got an MCSD with a module in SQL Server but I still felt that my SQL was not really that secure.
I've read many books on SQL and on SQL server over the years. Most are absolutely awful. They are either too complex, or too tricksy or too niche. John J. Patrick wrote a very good book on Access/Oracle SQL and I learned a fair bit from that.
Then I bought this book.
It is a technical masterpiece. Everything is introduced in the right sequence, to the right depth and with crystal clarity.
It's also a tutorial, which I love. You download the sample Database from Itzik's website, install it on your SQL server and then every single thing he discusses is something you can try out.
Every chapter ends with a set of excercises, which I really urge you to do and not cheat on. If you were really paying attention you can solve nearly all of them.
Although this book, is not full of recipes and highly complex solutions, it does contain rock-solid fundamentals that put you in the driving seat for when you want to really push the boat out.
I think it's one of the best technical books I've ever read, it is a joy to read and it opens up the heart and soul of SQL from a real master.
After reading this book (about 4 times).
I type out all my SQL, and I'm really able to get solid answers to my queries.
Finally. I got a job recently where I had to use Oracle.
Read more ›
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
5.0 out of 5 stars Nice book. 10 Feb. 2013
Format:Paperback|Verified Purchase
It's really is fundamental!
Every tricky aspect in T-SQL is well covered in this book
I greatly recommend this book.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars This book is excellent. I have been a 22 Dec. 2014
Format:Paperback|Verified Purchase
This book is excellent. I have been a .net developer for 7 years and never bothered to get a book on sqlserver. I found later on my knowledge was sparse. I bought this book and read it in week. I then went on and reread it doing each exercise at the end. I found myself grown in ability over a week. Not only does it teach you the fundamentals but there is evenue a chapter well written in debugging dead locks surpassing knowledge from 7 years experience considering I have an MSC Computer Science degree. Talks about pivoting and unpivoting conchisel delivering value for money. This is an invaluable book for every developer's book stall
Was this review helpful to you?
Format:Paperback|Verified Purchase
I actually ordered this book as I have started a new job as a web developer and with a view to get my certifications.
So far I have found it to be a very comprehensive guide to fundamentals atleast. It might not be best suited to someone who is a complete beginner as it assumes some knowledge of the concepts explained.
I was hoping it would have more information on stored procedures etc but there is minimal stuff in the book. Enough to get you started anyways. All in all , a good guide.
I will update when I have had a thorough read through it.
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know

Customer Discussions

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

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

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category