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 email address or mobile phone number.

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

4.4 out of 5 stars 79 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 $16.17
Learn More
Trade in now
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$26.63 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$36.57 On clicking this link, a new layer will be open
More Buying Choices
50 New from $28.02 23 Used from $26.63
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Save Up to 90% on Textbooks Textbooks
$36.57 FREE Shipping. 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)
Total price: $81.05
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



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 (79 customer reviews)
  • Amazon Best Sellers Rank: #23,327 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

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 52 of 55 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 39 of 46 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 12 of 12 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 of 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 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 6 of 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

Most Recent Customer Reviews

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: $36.57
Ships from and sold by Amazon.com

Want to discover more products? Check out these pages to see more: don alias, sql server integration services tuning, last orders placed