Microsoft SQL Server 2012 T-SQL Fundamentals (Developer Reference) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
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.
To get the free app, enter your mobile phone number.
Frequently bought together
Customers who viewed this item also viewed
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.
There was a problem filtering reviews right now. Please try again later.
A excellent next step book for anyone working with TSQL giving you a deeper understanding into how your code actually works ( logical / physical processing ) which helps you create and debug code. I actually got by for a while using a MySQL Ben Forta primer book and a Head First SQL book to get the basics down quickly but now I’m finding some holes when approaching more complex queries for reporting ( getting multiple aggregates from multiple joins and subqueries without ruining calcs ).
Of course, TSQL syntax is covered here and examples are well thought out with detailed and insightful descriptions. I also appreciate the database, exercises and solutions being available online in .sql file ready to use. Many of the solutions made me ask further questions and try new things. The phrasing the author uses is easily accessible and unforced - no extra fluff to add extra pages like in other tech books. Also I should note this is definitely not too deep for those new to TSQL - it covers all the bases well and has lots of extra little knowledge nuggets but won’t leave you behind.
Top international reviews
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. I had worried that this might prove to be a difficult cross-over, however in practice, once your SQL is solid, you can program any database. I'm not talking here about PL/SQL vs T-SQL, only the standard SELECTs and UPDATE/INSERT which are covered brilliantly in this book and apply to all major RDBMS.
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.
Every tricky aspect in T-SQL is well covered in this book
I greatly recommend this book.