Shop top categories that ship internationally
Buy New
-14% EUR36.71
EUR 8.81 delivery Wednesday, May 6
Ships from: Amazon.com
Sold by: Amazon.com
EUR 36.71 with 14 percent savings
List Price: EUR 42.70
No Import Charges & EUR 8.81 Shipping to Netherlands Details

Shipping & Fee Details

Price EUR 36.71
AmazonGlobal Shipping EUR 8.81
Estimated Import Charges EUR 0.00
Total EUR 45.53

EUR 8.81 delivery Wednesday, May 6
In Stock
EUR EUR 36.71 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
EUR EUR 36.71
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Shipper / Seller
Amazon.com
Amazon.com
Shipper / Seller
Amazon.com
Returns
FREE 30-day refund/replacement
FREE 30-day refund/replacement
Quick refund
Usually issued within 24 hours. See exceptions
FREE return
At least one free return option available.
Convenient dropoff
At any of our 50,000 US locations.
See return policy
Gift options
Available at checkout
Available at checkout This item is a gift. Change
At checkout, you can add a custom message, a gift receipt for easy returns and have the item gift-wrapped
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
EUR 14.96
FREE International Returns
SATISFACTION OR YOUR MONEY BACK! Book is in good and clean condition, potentially ex-library. Pages are intact. It may have miscellaneous marks, highlighting, and wear and tear of a used book. Supplementary cds and codes may not be present or functional. Fast shipping! SATISFACTION OR YOUR MONEY BACK! Book is in good and clean condition, potentially ex-library. Pages are intact. It may have miscellaneous marks, highlighting, and wear and tear of a used book. Supplementary cds and codes may not be present or functional. Fast shipping! See less
EUR 8.81 delivery Thursday, May 7. Order within 12 hrs 57 mins
Or fastest delivery Wednesday, May 6
Only 1 left in stock - order soon.
EUR EUR 36.71 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
EUR EUR 36.71
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Access codes and supplements are not guaranteed with used items.
Added to

Sorry, there was a problem.

There was an error retrieving your Wish Lists. Please try again.

Sorry, there was a problem.

List unavailable.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

  • T-SQL Fundamentals (Developer Reference)

Follow the author

Get new release updates & improved recommendations
Itzik Ben-Gan
Follow
Something went wrong. Please try your request again later.

T-SQL Fundamentals (Developer Reference) 3rd Edition

by Itzik Ben-Gan (Author)
4.7 out of 5 stars (407)
{"desktop_buybox_group_1":[{"displayPrice":"EUR 36.71","priceAmount":36.71,"currencySymbol":"EUR","integerValue":"36","decimalSeparator":".","fractionalValue":"71","symbolPosition":"left","hasSpace":true,"showFractionalPartIfEmpty":true,"offerListingId":"qq3lWHaQreWqQnIfB3GZ%2BHn%2B0o9xzFVaD0ZCUnUSVA6tgLe00Oen1SmUEr9%2FbslH%2BRq%2FyOXyHW7Pi6U1gA4iN69FfKCVEjSbwJeKI5z7p%2BFWP3Uqo4y%2Byn56sU2o%2BVpjUU9PWUDTJlTPcCe908eQlw%3D%3D","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"EUR 14.96","priceAmount":14.96,"currencySymbol":"EUR","integerValue":"14","decimalSeparator":".","fractionalValue":"96","symbolPosition":"left","hasSpace":true,"showFractionalPartIfEmpty":true,"offerListingId":"qq3lWHaQreWqQnIfB3GZ%2BHn%2B0o9xzFVaZ3C057WfiFQKImvMKpq4V2ahrYDMx5M3i5rnHUjENTyf%2F2uUVj4t7riYvqhN%2FsyVvs6oFBPAMTgaf1kEOmgBWNATDzHPjOxqxfFGbzZ2H%2BdMf95zjqgjOOKj9WJZTTFyvobXdvEx5BWInTKcwCBi%2FfTzTs58WZeg","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

Effectively query and modify data using Transact-SQL
Master T-SQL fundamentals and write robust code for Microsoft SQL Server and Azure SQL Database. Itzik Ben-Gan explains key T-SQL concepts and helps you apply your knowledge with hands-on exercises. The book first introduces T-SQL’s roots and underlying logic. Next, it walks you through core topics such as single-table queries, joins, subqueries, table expressions, and set operators. Then the book covers more-advanced data-query topics such as window functions, pivoting, and grouping sets. The book also explains how to modify data, work with temporal tables, and handle transactions, and provides an overview of programmable objects.


Microsoft Data Platform MVP Itzik Ben-Gan shows you how to:

  • Review core SQL concepts and its mathematical roots
  • Create tables and enforce data integrity
  • Perform effective single-table queries by using the SELECT statement
  • Query multiple tables by using joins, subqueries, table expressions, and set operators
  • Use advanced query techniques such as window functions, pivoting, and grouping sets
  • Insert, update, delete, and merge data
  • Use transactions in a concurrent environment
  • Get started with programmable objects–from variables and batches to user-defined functions, stored procedures, triggers, and dynamic SQL
Read more
Previous slide of product details
  1. ISBN-10
    9781509302000
  2. ISBN-13
    978-1509302000
  3. Edition
    3rd
  4. Publisher
    Microsoft Press
  5. Publication date
    August 3, 2016
  6. Part of series
    Developer Reference
  7. Language
    English
  8. Dimensions
    7.38 x 1.03 x 9 inches
  9. Print length
    464 pages
Next slide of product details

There is a newer edition of this item:

T-SQL Fundamentals (Developer Reference)
T-SQL Fundamentals (Developer Reference)
EUR 42.70
(84)
In Stock

Frequently bought together

This item: T-SQL Fundamentals (Developer Reference)
EUR36.71
In Stock
Ships from and sold by Amazon.com.
+
T-SQL Querying (Developer Reference)
EUR26.91
Only 19 left in stock (more on the way).
Ships from and sold by Amazon.com.
+
T-SQL Window Functions: For data analysis and beyond (Developer Reference)
EUR34.16
Only 2 left in stock (more on the way).
Ships from and sold by Amazon.com.
Total price: $00
To see our price, add these items to your cart.
Details
Added to Cart
Some of these items ship sooner than the others.
Show details Hide details
Choose items to buy together.

Customers also bought or read

Page 1 of 1Start over
Previous page
  2. Book cover Relational Database Design and Implementation: Clearly Explained
    Relational Database Design and Implementation: Clearly Explained
    Paperback
    EUR40.99
    EUR 9.82 delivery May 7 - 19
  4. Book cover Learning SQL: Generate, Manipulate, and Retrieve Data
    Learning SQL: Generate, Manipulate, and Retrieve Data
    Paperback
    EUR31.17
    EUR 8.59 delivery Wed, May 6
  6. Book cover Head First SQL: Your Brain on SQL -- A Learner's Guide
    Head First SQL: Your Brain on SQL -- A Learner's Guide
    Paperback
    EUR16.89
    EUR 9.17 delivery May 5 - 13
  10. Book cover Fundamentals of Data Engineering: Plan and Build Robust Data Systems
    Fundamentals of Data Engineering: Plan and Build Robust Data Systems
    Paperback
    EUR35.01
    EUR 8.81 delivery Thu, May 7
  13. Book cover C Programming Language, 2nd Edition
    C Programming Language, 2nd Edition#1 Best SellerC Programming Language
    Paperback
    EUR51.51
    EUR 8.39 delivery Wed, May 6
  14. Book cover Core Java: Advanced Features, Volume 2 (Oracle Press Java)
    Core Java: Advanced Features, Volume 2 (Oracle Press Java)
    Paperback
    EUR38.34
    EUR 9.82 delivery Thu, May 7
  16. Book cover Murach's SQL Server 2019 for Developers
    Murach's SQL Server 2019 for Developers
    Paperback
    EUR32.62
    EUR 9.82 delivery Thu, May 7
  20. Book cover SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights
    SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights
    Paperback
    EUR31.17
    EUR 8.59 delivery Thu, May 7
  21. Book cover Microsoft Excel 365 Bible
    Microsoft Excel 365 Bible
    Paperback
    EUR22.72
    EUR 9.82 delivery Wed, May 6
  22. Book cover Python Data Science Handbook: Essential Tools for Working with Data
    Python Data Science Handbook: Essential Tools for Working with Data
    Paperback
    EUR37.74
    EUR 9.09 delivery Wed, May 6
Next page
Loading...

Editorial Reviews

About the Author

TZIK BEN-GAN is a mentor with and co-founder of SolidQ. A Microsoft Data Platform MVP since 1999, Itzik has taught numerous training events around the world focused on T-SQL querying, query tuning, and programming. Itzik is the author of several books about T-SQL. He has written many articles for SQL Server Pro as well as articles and white papers for MSDN and The SolidQ Journal. Itzik’s speaking engagements include Tech-Ed, SQL PASS, SQL Server Connections, presentations to various SQL Server user groups, and SolidQ events.

Itzik is a subject-matter expert within SolidQ for its T-SQL related activities. He authored SolidQ’s Advanced T-SQL and T-SQL Fundamentals courses and delivers them regularly worldwide. You can learn more about Itzik at http://tsql.solidq.com/.

Product details

  • ASIN ‏ : ‎ 150930200X
  • Publisher ‏ : ‎ Microsoft Press
  • Publication date ‏ : ‎ August 3, 2016
  • Edition ‏ : ‎ 3rd
  • Language ‏ : ‎ English
  • Print length ‏ : ‎ 464 pages
  • ISBN-10 ‏ : ‎ 9781509302000
  • ISBN-13 ‏ : ‎ 978-1509302000
  • Item Weight ‏ : ‎ 1.65 pounds
  • Dimensions ‏ : ‎ 7.38 x 1.03 x 9 inches
  • Part of series ‏ : ‎ Developer Reference
  • Best Sellers Rank: #1,288,883 in Books (See Top 100 in Books)
  • Customer Reviews:
    4.7 out of 5 stars (407)

About the author

Follow authors to get new release updates, plus improved recommendations.
Itzik Ben-Gan

Itzik Ben-Gan

Brief content visible, double tap to read full content.
Full content visible, double tap to read brief content.

Itzik Ben-Gan is a T-SQL author. His books include T-SQL Fundamentals, T-SQL Querying, T-SQL Window Functions and others.

Related books

Page 1 of 1Start Over
Sponsored
Previous page
  1. Shop the Store on Amazon ›
    Python Programming for Beginners: The Complete Guide to Mastering Python in 7 Days with Hands-On Exercises – Top Secret Coding Tips to Get an Unfair Advantage and Land Your Dream Job!
    Python Programming for Beginners: The Complete Guide to Mastering Python in 7 Days with Hands-On Exercises – Top Secret Coding Tips to Get an Unfair Advantage and Land Your Dream Job!
    4.44.4 out of 5 stars1,065
    EUR21.35
  2. Shop the Store on Amazon ›
    HTML and CSS QuickStart Guide: The Simplified Beginners Guide to Developing a Strong Coding Foundation, Building Responsive Websites, and Mastering ... (Coding & Programming - QuickStart Guides)
    HTML and CSS QuickStart Guide: The Simplified Beginners Guide to Developing a Strong Coding Foundation, Building Responsive Websites, and Mastering ... (Coding & Programming - QuickStart Guides)
    4.54.5 out of 5 stars684
    EUR20.92 List:EUR29.89
  3. Shop the Store on Amazon ›
    Workflow Automation with Microsoft Power Automate: Design and scale AI-powered cloud and desktop workflows using low-code automation
    Workflow Automation with Microsoft Power Automate: Design and scale AI-powered cloud and desktop workflows using low-code automation
    4.84.8 out of 5 stars20
    EUR15.67 List:EUR38.43
  4. Shop the Store on Amazon ›
    Python Programming for Beginners: The Complete Python Coding Crash Course - Boost Your Growth with an Innovative Ultra-Fast Learning Framework and Exclusive Hands-On Interactive Exercises & Projects
    Python Programming for Beginners: The Complete Python Coding Crash Course - Boost Your Growth with an Innovative Ultra-Fast Learning Framework and Exclusive Hands-On Interactive Exercises & Projects
    4.54.5 out of 5 stars1,020
    EUR17.00
Next page

Customer reviews

4.7 out of 5 stars
407 global ratings

Customers say

Customers find the book effective as a learning guide, particularly for SQL beginners. Moreover, the content receives positive feedback, with one customer noting it's the most relevant text on T-SQL. Additionally, the writing quality is praised, with one customer mentioning there are no typos.
AI Generated from the text of customer reviews

Select to learn more

24 customers mention comprehensive, 22 positive, 2 negative
Customers find the book comprehensive and effective as a learning guide, particularly noting that it explains things well and is great for SQL beginners.
Tons of good information. Well written. Excellent resource.Read more
...No typos. Very informative and thorough-just the right level for a beginner.Read more
I love that it has exercises! It also has good explanations. It is very helpful. I am working for Certification.Read more
...as it is a book by Itzik Ben-Gan the expert of SQL Server and explains things so well and knows the material inside and out....Read more
19 customers mention content, 18 positive, 1 negative
Customers find the content of the book excellent and appreciate its good quality paper. One customer notes that it goes deep into descriptions, while another mentions it is the most relevant text on T-SQL.
Great book! I’m getting ready to take my Microsoft Certification on Transact-SQL and started with reading books....Read more
Good bookRead more
Have not read it yet, but it is aesthetically beautiful, good quality paper~~ would read it as soon as I got free time~Read more
Excellent & easy to understand reference for Transact-SQLRead more
7 customers mention writing quality, 7 positive, 0 negative
Customers praise the writing quality of the book, noting it is perfectly written with no typos, and one customer mentions the author's passion.
Beautifully written as both an effective learning guide and an essential reference for the practitioner....Read more
Very well written and structured book with very easy to follow examples....Read more
Perfectly written, accurate, great for sql beginners like myself. Focuses on select queries. Not too much info about indexes....Read more
Tons of good information. Well written. Excellent resource.Read more
Book is worthless with source code being unavailable.
1 out of 5 stars
Book is worthless with source code being unavailable.
Webpage providing source code /samples was unavailable. Not worth chasing. Thankfully I skipped to the section for examples and questions exercises. Otherwise, it would be lousy trying to get a refund from amazon at a later date.
Hide
Thank you for your feedback
Sorry, there was an error
Sorry we couldn't load the review

Top reviews from the United States

  • Kevin & Ema Gates
    5.0 out of 5 stars Helpful, IF you practice
    Reviewed in the United States on February 16, 2022
    Format: PaperbackVerified Purchase
    Sometimes his exercises can be difficult but that is the point. Life isn’t easy. If you take your time study his notes, practice the exercises, and couple it with Microsoft documentation then you’re golden. I have used this book for reference and can definitely say it has helped me in my career as a C# programmer learning T-SQL.
    4 people found this helpful
    Helpful
     Report
  • Malcolm Martin Harris
    5.0 out of 5 stars Wonderful book. Very Scholastic in nature.
    Reviewed in the United States on May 31, 2021
    Format: PaperbackVerified Purchase
    Great text. I wasn’t expecting such a scholastic and pedagogical approach to the material. (Meaning, it’s rare to see them use the word rows instead of “tuples”, or “attributes” instead of columns or predicates instead of “true or false conditions.”) Nevertheless, it’s very thorough and will certainly take your T-SQL skills to the next level.
    2 people found this helpful
    Helpful
     Report
  • Riley Weishaupt
    5.0 out of 5 stars *A MUST HAVE*
    Reviewed in the United States on May 18, 2020
    Format: PaperbackVerified Purchase
    Great book! I’m getting ready to take my Microsoft Certification on Transact-SQL and started with reading books. This one was perfect for me since I’m a complete beginner and have one teacher (me) haha. This book goes deep into description which is exactly what I need! Here’s the thing that I keep getting asked “Do you learn everything from one book?” The answer is No... the books are great, especially this one, but if you are going down the same rout as me (learning on your own and from the ground up) you need to immerse yourself In several resources and learning styles. I also use TeamTreeHouse for a more visual experience as well as YouTube and even threads(Reddit)/community Q&A’s.
    8 people found this helpful
    Helpful
     Report
  • Wolfgang Reh
    5.0 out of 5 stars Very impressive book
    Reviewed in the United States on March 6, 2017
    Format: PaperbackVerified Purchase
    Very well written and structured book with very easy to follow examples. I thought I learned about 90% of T-SQL over the years and wanted a book to learn the rest. It turned out I only knew about 70%.
    10 people found this helpful
    Helpful
     Report
  • Zgrogen
    4.0 out of 5 stars Writer is passionate, smart teacher, reputed
    Reviewed in the United States on November 26, 2021
    Format: PaperbackVerified Purchase
    Perfectly written, accurate, great for sql beginners like myself. Focuses on select queries. Not too much info about indexes. Removed one star because the index in the back is not very complete or organized.
    2 people found this helpful
    Helpful
     Report
  • ovadia gil
    5.0 out of 5 stars Great simple and clear T-SQL book
    Reviewed in the United States on June 10, 2019
    Format: KindleVerified Purchase
    Liked how it is explained both in simple and complex terms for all audiences.
    Recommended for beginners until advanced that learned by them self and want to make order and logic on what they know in practice.
    Helpful
     Report
  • Keith S. Safford
    5.0 out of 5 stars Awesome book
    Reviewed in the United States on February 14, 2020
    Format: KindleVerified Purchase
    What more can I say as it is a book by Itzik Ben-Gan the expert of SQL Server and explains things so well and knows the material inside and out. It is a book that EVERY SQL Server developer needs to have in his library!
    2 people found this helpful
    Helpful
     Report
  • PB
    5.0 out of 5 stars Excellent, thorough
    Reviewed in the United States on December 15, 2018
    Format: PaperbackVerified Purchase
    Returned the first one they sent which was not well wrapped and came with a crease in the cover...was immediately replaced. No typos. Very informative and thorough-just the right level for a beginner.
    Helpful
     Report

Top reviews from other countries

Translate all reviews to English
  • Caio Camargo
    5.0 out of 5 stars Melhor livro para aprender conceitos de SQL Server
    Reviewed in Brazil on March 5, 2020
    Format: PaperbackVerified Purchase
    Ótimo livro para quem quer adquirir uma base extremamente sólida sobre os conceitos de SQL.
    Indicado principalmente para iniciantes e intermediários mas pode ser útil para os usuários mais experientes pois contém muitos detalhes sobre algumas funcionalidades de SQL.
    Report
  • Leonardo Cursi
    5.0 out of 5 stars You can't say you can write in T-SQL if you haven't learned the basics explained in this book!
    Reviewed in Italy on August 28, 2021
    Format: PaperbackVerified Purchase
    I am a DBA and I always have the book with me when I want to go deeper in understanding the queries that I want to be able to make go faster! There are practical exercises at the end of each chapter so the concepts learned are immediately put into practice. Thanks Itzik!
    Report
  • ERIK SANCHEZ
    5.0 out of 5 stars Excelente libro
    Reviewed in Mexico on February 14, 2020
    Format: PaperbackVerified Purchase
    Es un excelente libro y muy completo, se los recomiendo mucho
    Report
  • Dubois
    1.0 out of 5 stars Impossible d'avoir l'ouvrage PDF avec le format papier
    Reviewed in France on March 7, 2020
    Format: PaperbackVerified Purchase
    Le livre en lui-même est pas mal, il présente bien le T-SQL.
    Mais, et c'est pourquoi je mets une étoile, il est impossible d'avoir une version PDF avec la version papier...
    Sur le site de Microsoft, il est possible d'acheter l'un ET l'autre! Tiens, deux achats au lieu d'un, il fallait y penser!
    Quand on achète un film aujourd'hui, il y a souvent pour le même prix, la version DVD, Blu-Ray et une version numérique : pourquoi pas la même chose avec les livres?
    Report
  • Franky
    5.0 out of 5 stars Covers the topic methodically
    Reviewed in the United Kingdom on March 5, 2020
    Format: PaperbackVerified Purchase
    Very detailed - and yet little or no redundancy in the text.

    As a novice I found it best to write 'bullet point' notes in OneNote based on this text - and then repeatedly review my notes.

    The structured approach and regular exercises in the book made it straightforward (but not necessarily easy!!) to get to grips with T-SQL.

    The author has clearly thought carefully about 'what needs to be in the book' and I felt I was not burdened by unnecessary 'small print' - while common pitfalls are well signposted. A very sensible approach to recent historical changes in T-SQL.
    Report
See more reviews