Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

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

4.5 out of 5 stars 88 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.
Trade in your item
Get a $10.17
Gift Card.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$24.98 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$37.99 On clicking this link, a new layer will be open
More Buying Choices
47 New from $26.58 35 Used from $24.98
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Best Books of the Year So Far
Looking for something great to read? Browse our editors' picks for the Best Books of the Year So Far in fiction, nonfiction, mysteries, children's books, and much more.
$37.99 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

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)
Total price: $91.79
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

The latest book club pick from Oprah
"The Underground Railroad" by Colson Whitehead is a magnificent novel chronicling a young slave's adventures as she makes a desperate bid for freedom in the antebellum South. See more

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.5 out of 5 stars  See all reviews (88 customer reviews)
  • Amazon Best Sellers Rank: #36,657 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

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 53 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 44 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 13 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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 7 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
I like that Itzk Ben-Gan does not shy away from detail, nor from theory. He does not bog us down in endless "proofs", or mathematician style approaches, but he will not simply throw all that stuff out, losing the VALUE that comes from such material. He has a knack for including what really ought to be included, and paring the material he DOES include down to a streamlined, but effective whole. One ought to go over and over this stuff and run the queries with a real working copy of Sql Server. Material in here guides us as to where we can get free copy MSFT Sql Server, and sample databases.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

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