T-SQL fundamentals / Itzik Ben-Gan.

Format:

Book

Author/Creator:

Ben-Gan, Itzik, author.

Language:

English

Subjects (All):

SQL (Computer program language).

Client/server computing.

Database management.

SQL server.

Physical Description:

1 online resource (608 pages) : illustrations

Edition:

[First edition].

Place of Publication:

[Place of publication not identified] : Pearson Education, [2023]

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 Graph (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.

Notes:

OCLC-licensed vendor bibliographic record.

Includes index.

ISBN:

9780138101930

0138101930

OCLC:

1371414125