T-SQL Fundamentals,9780138102104

T-SQL Fundamentals

by
Edition: 4th
ISBN13: 9780138102104
ISBN10: 0138102104
Format: Paperback
Pub. Date: 2023-05-05
Publisher(s): Microsoft Press
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

  • Complimentary 7-Day eTextbook Access - Read more
    When you rent or buy this book, you will receive complimentary 7-day online access to the eTextbook version from your PC, Mac, tablet, or smartphone. Feature not included on Marketplace Items.
List Price: $52.49

Buy New

Arriving Soon. Will ship when available.
$49.99
Add to Cart

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

Rent Digital

Rent Digital Options
Online:1825 Days access
Downloadable:Lifetime Access
$57.59
$57.59
Add to Cart

Used Book

We're Sorry
Sold Out

Buy from our Marketplace starting at $43.65

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Starting with the background to T-SQL querying and programming, including: logical query processing, book-querying constructs (single table queries, joins, subqueries, table expressions, set operators, data analysis), data modifications, temporal tables, transactions and concurrency, SQL Grah (completely new to this edition), as well as programmatic T-SQL constructs. The book includes extensive exercises and solutions with explanations, allowing the reader to practice what they've learned.

This book is widely considered as the authoritative guide on T-SQL fundamentals. It focuses on understanding why things work the way they do, and not just how to make them work. When people understand the "why" the code they write tends to be more correct and more meaningful. This edition of the book includes coverage of the newest T-SQL additions up to and including SQL Server 2022.

Author Biography

Itzik 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/.

Table of Contents

Previous TOC

Chapter 1: Background to T-SQL Querying and Programming
Chapter 2: Single-Table Queries
Chapter 3: Joins
Chapter 4: Subqueries
Chapter 5: Table Expressions
Chapter 6: Set Operators
Chapter 7: T-SQL for Data Analysis
Chapter 8: Data Modification
Chapter 9: Temporal Tables
Chapter 10: Transactions and Concurrency
Chapter 11: SQL Graph
Chapter 12: Programmable Objects
Appendix

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.