You don't need to own a Kindle device to enjoy Kindle books. Download one of our FREE Kindle apps to start reading Kindle books on all your devices.

  • Apple
    Apple
  • Android
    Android
  • Windows Phone
    Windows Phone
  • Click here to download from Amazon appstore
    Android

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

kcpAppSendButton

Buying Options

Kindle Price: $36.26
includes tax, if applicable

These promotions will be applied to this item:

Some promotions may be combined; others are not eligible to be combined with other offers. For details, please see the Terms & Conditions associated with these promotions.

Deliver to your Kindle or other device

Deliver to your Kindle or other device

<Embed>

Loading recommendations for you
Recommendations for you

Adding to Cart...

Added to Cart

Not Added

Item is in your Cart

View Cart

Not Added

There was a problem adding this item to Cart. Please try again later.
Sorry, we're having trouble showing recommendations right now. Please try again later.
Continue shopping
T-SQL Fundamentals by [Ben-Gan, Itzik]
Kindle App Ad

Follow the Author

Something went wrong. Please try your request again later.


T-SQL Fundamentals 3rd Edition, Kindle Edition

4.5 out of 5 stars 26 customer reviews

See all 2 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle
$36.26

Length: 458 pages Enhanced Typesetting: Enabled Page Flip: Enabled
Language: English

Get 90 days FREE of Amazon Music Unlimited
with the purchase of any eligible product. Shop now

Product description

Product Description

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

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

  • Format: Kindle Edition
  • File Size: 28110 KB
  • Print Length: 458 pages
  • Page Numbers Source ISBN: 150930200X
  • Simultaneous Device Usage: Up to 5 simultaneous devices, per publisher limits
  • Publisher: Microsoft Press; 3 edition (29 July 2016)
  • Sold by: Amazon Australia Services, Inc.
  • Language: English
  • ASIN: B01J89I7PI
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Screen Reader: Supported
  • Enhanced Typesetting: Enabled
  • Average Customer Review: Be the first to review this item
  • Amazon Bestsellers Rank: #284,669 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
click to open popover

No customer reviews

5 star (0%) 0%
4 star (0%) 0%
3 star (0%) 0%
2 star (0%) 0%
1 star (0%) 0%

Review this product

Share your thoughts with other customers

Most helpful customer reviews on Amazon.com

Amazon.com: 4.5 out of 5 stars 26 reviews
Luis R.
5.0 out of 5 starsI finally found a book that took me clearly from the very foundations of T-SQL
3 December 2016 - Published on Amazon.com
Verified Purchase
23 people found this helpful
KingSonal
5.0 out of 5 starsGreat even for sql veterans
11 January 2019 - Published on Amazon.com
Verified Purchase
5 people found this helpful
Aimen Salman
5.0 out of 5 starsFive Stars
29 January 2018 - Published on Amazon.com
Verified Purchase
7 people found this helpful
Wolfgang Reh
5.0 out of 5 starsVery impressive book
7 March 2017 - Published on Amazon.com
Verified Purchase
7 people found this helpful
tania
4.0 out of 5 starsMaybe a little too light? But really good.
29 January 2018 - Published on Amazon.com
Verified Purchase
2 people found this helpful