Microsoft SQL Server 2012 T-SQL Fundamentals and over one million other books are available for Amazon Kindle. Learn more

Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference) 1st Edition

68 customer reviews
ISBN-13: 978-0735658141
ISBN-10: 0735658145
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $11.50
Learn More
Trade in now
Have one to sell? Sell on Amazon
Rent
$20.40
Buy used
$27.73
Buy new
$32.04
Rent from Amazon Price New from Used from
Kindle
"Please retry"
Paperback, July 25, 2012
"Please retry"
$20.40
$32.04
$28.03 $23.75
More Buying Choices
50 New from $28.03 19 Used from $23.75
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


InterDesign Brand Store Awareness Textbooks
$32.04 FREE Shipping on orders over $35. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference) + Training Kit (Exam 70-461) Querying Microsoft SQL Server 2012 (MCSA) (Microsoft Press Training Kit) + Training Kit (Exam 70-462) Administering Microsoft SQL Server 2012 Databases (MCSA) (Microsoft Press Training Kit)
Price for all three: $120.55

Buy the selected items together

Editorial Reviews

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.

NO_CONTENT_IN_FEATURE


Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

Product Details

  • Series: Developer Reference
  • Paperback: 448 pages
  • Publisher: Microsoft Press; 1 edition (July 25, 2012)
  • Language: English
  • ISBN-10: 0735658145
  • ISBN-13: 978-0735658141
  • Product Dimensions: 7.3 x 1 x 8.9 inches
  • Shipping Weight: 1.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (68 customer reviews)
  • Amazon Best Sellers Rank: #42,221 in Books (See Top 100 in Books)

More About the Author

Itzik Ben-Gan is a Mentor and Co-Founder of SolidQ. A SQL Server Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL Querying, Query Tuning and Programming. Itzik is the author of several books including Microsoft SQL Server 2012 T-SQL Fundamentals and Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions. He has written many articles for SQL Server Pro as well as articles and whitepapers for MSDN. Itzik's speaking activities include TechEd, DevWeek, SQLPASS, SQL Server Magazine Connections, various user groups around the world, and SolidQ's events to name a few. Itzik is the author of SolidQ's Advanced T-SQL Querying, Programming and Tuning and T-SQL Fundamentals courses along with being a primary resource within the company for their T-SQL related activities.
For more details please visit http://tsql.solidq.com.

Customer Reviews

Most Helpful Customer Reviews

51 of 54 people found the following review helpful By Jose on September 2, 2012
Format: Paperback
This book is a masterpiece. It teaches you the fundamentals of T-SQL, while showing you the logic and set theory behind. A good approach, in my opinion, because T-SQL is based on set theory; ignoring that, makes developers to write T-SQL code in a programatic way, causing horrible performance issues and long running queries that take an eternity to finish. As a DBA, I've seen this over and over again, usually from developers that do not know how to think in sets.

The book relies on a dummy database that you should create on SQL 2012 and each chapter uses that code to elaborate all the concepts.

Each chapter ends with few exercises so if you already created the dummy database, you can (and should) start writing T-SQL code right away and validate what you read while learning how to think in sets during the process.

One of the things I like most of this book is that while this is a T-SQL book, Itzik keeps it vendor neutral (or tries to) so when the code deviates of the SQL standard, he warns you about it. That's good, because in case you need to start writing code for MySQL, Oracle or any other vendor, you are already aware of those differences or you wrote code that does not deviate too much of the regular SQL ANSI standard.

Do I recommend this book? Yes, I do, no doubt about it, but only if you do not own the SQL 2008 version. Otherwise, I see no point on getting this one. To be honest, It is basically the same book with the SQL 2012 title on it; the only difference I've seen so far is references to Window Functions, which are briefly covered on Chapter #7. Besides that, it is basically a reprint of the same nice book, but with different title.
5 Comments 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
12 of 12 people found the following review helpful By forrest on January 18, 2013
Format: Paperback
I think it did everything that it did very well.
It explained differences between T-SQL and ANSI SQL in situations that called for it in a non-biased way. He uses both.
The author comes across as an expert that really knows the SQL trade, he should he has been doing it for a long time and is valued peer in the SQL community.

If you know nothing about sql get it.
If you know a some sql get it.

If you know a lot about sql programming get it and give it to someone that bugs you too much about SQL.
If you want to learn a good writing style for technical learning subjects get it.

This book is one of my all time favorites on programming etc.
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
35 of 42 people found the following review helpful By Raymond L Everest on September 12, 2013
Format: Paperback Verified Purchase
The author, an expert in the field, publishes his first introductory book on TSQL, and although the title 'T-SQL Fundamentals' is representative of the content, the use of the book for a college textbook leaves room for improvement. I used this book for a 3-hr IT credit course this semester at a local community college...the book does have good information. The problems are in that 1) the order of introduction is not optimal, 2) the explanations via pictorials or diagrams for a pure beginner are lacking, and 3) the example code could be better.

First off, to address the order, he introduces right away in chapter 1 and chapter two concepts that I would not introduce until much later for a beginning TSQL class. Foreign Key relationships and Windowing functions are not beginning concepts, for instance, and thus should be introduced much later in the book in my opinion. Cross Joins are the first join type introduced in Chapter 2; this is a 'special' type of join used to create data or build lists, and is not used that often in the business world. A much better replacement might be the SELECT INTO, which is introduced way in the back of the book in a later chapter. There are other examples-my point is that for the beginner, the order here needs to be looked at more closely. It doesn't make sense a lot of the time.

Second, explanations and the use of drawings, pictures, or diagrams are lacking or non-existent. As an example, when I teach joins, I draw pictures on a whiteboard with minimal data to introduce concepts in a clear and concise manner; he has none of these. Many of the examples don't allow a student the opportunity to let the concepts 'hit home' because other ideas are introduced at the same time.
Read more ›
7 Comments 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
7 of 7 people found the following review helpful By John Grove VINE VOICE on August 6, 2013
Format: Paperback
This introductory book does what no other does. It explains set theory, predicate logic, relations, propositions, normalization, SQL Server architecture, windows functions, pivoting data and laying the foundation strongly before explaining T-SQL. And when it gets to that, as the mafiosos say forget about it.

The best book on fundamentals period, whether you are a beginner or advanced. There is something for all developers.
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
3 of 3 people found the following review helpful By Ashwin on June 27, 2013
Format: Paperback Verified Purchase
Good book for SQL fundamentals. Recommended for any professional who's work needs good knowledge of SQL. Book worth the money.
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
4 of 5 people found the following review helpful By JOHN SHAHAN on March 25, 2014
Format: Paperback Verified Purchase
I am a self taught SQL programmer with an interest in "plugging some holes" in my skill set. Mr. Ben-Gan's text came highly recommended yet still exceeded my expectations. He doesn't just know the material, he is a gifted writer/teacher on the subject.

There is a lot of misinformation in the various online blogs/forums but THIS TEXT provides you with a TECHNICAL GOSPEL for SQL programmers. I would say an interested beginner could absorb this material alone and qualify for entry level position. Experienced programmers will likely be provided insight and confirmation regarding their current skills and actually add more new techniques and understanding.

One other thing: I bought the hard copy and quickly realized that the ebook was going to work much better for me so I purchased that as well. I have the Kindle PC reader at home and at work. The reader presents the text in a very easy to read manner and if I make notes in the text, they follow me from work to home. Perfect for study! I don't think I will ever buy another hard copy of a technical manual if I can read and annotate the ebook version everywhere in a Kindle reader.
1 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

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference)
This item: Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference)
Price: $32.04
Ships from and sold by Amazon.com

Want to discover more products? Check out this page to see more: programming