Microsoft SQL Server 2012 T-SQL Fundamentals and over one million other books are available for Amazon Kindle. Learn more
Qty:1
  • List Price: $49.99
  • Save: $14.83 (30%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Microsoft SQL Server 2012... has been added to your Cart
Condition: Used: Very Good
Comment: Text unmarked.
Access codes and supplements are not guaranteed with used items.
Sell yours for a Gift Card
We'll buy it for $12.81
Learn More
Trade in now
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference) Paperback – July 25, 2012

ISBN-13: 978-0735658141 ISBN-10: 0735658145 Edition: 1st

Buy New
Price: $35.16
33 New from $28.90 16 Used from $26.49
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$35.16
$28.90 $26.49
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Get Up to 80% Back When You Sell Us Your Books
$35.16 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) + Training Kit (Exam 70-462) Administering Microsoft SQL Server 2012 Databases (MCSA) (Microsoft Press Training Kit)
Price for all three: $123.22

Buy the selected items together
NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

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.8 inches
  • Shipping Weight: 1.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (61 customer reviews)
  • Amazon Best Sellers Rank: #7,598 in Books (See Top 100 in Books)

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.

Customer Reviews

A very well written book that is easy to read.
Michael S.
For the start, I feel his explanation for the "Logical Query Process" was great and a MUST NEED knowledge to have if you want to write better queries.
W.
This book is a must for any beginner or intermediate user to have in their SQL collection.
Jay Michael

Most Helpful Customer Reviews

48 of 51 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
33 of 39 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 ›
6 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

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.
Want to discover more products? Check out these pages to see more: date sql, last orders placed

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