Skip to product information
1 of 1

Itzik Ben-Gan

T-SQL Fundamentals

T-SQL Fundamentals

Regular price £25.33 GBP
Regular price £37.99 GBP Sale price £25.33 GBP
33% OFF Sold out
Tax included. Shipping calculated at checkout.

YOU SAVE £12.66

  • Condition: Brand new
  • UK Delivery times: Usually arrives within 2 - 3 working days
  • UK Shipping: Fee starts at £2.39. Subject to product weight & dimension
Trustpilot 4.5 stars rating  Excellent
We're rated excellent on Trustpilot.
  • More about T-SQL Fundamentals


Itzik Ben-Gan, a long-time Microsoft Data Platform MVP, teaches T-SQL fundamentals for querying and modifying data with modern Microsoft data technologies. He covers logical query processing, single-table queries, joins, subqueries, table expressions, set operators, data analysis, data modifications, temporal tables, transactions, and concurrency. Ben-Gan provides reusable T-SQL sample code for cloud, on-premises, and hybrid environments.

Format: Paperback / softback
Length: 608 pages
Publication date: 08 June 2023
Publisher: Pearson Education (US)


Master the fundamentals of Transact-SQL and write efficient and reliable code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance.

Long-time Microsoft Data Platform MVP Itzik Ben-Gan, who has extensive experience in the field, guides you through key T-SQL concepts, helping you apply your knowledge through hands-on exercises.

Ben-Gan begins by introducing the theory and underlying logic of T-SQL, presenting it as both a language and a way of thinking. He then delves into core topics such as logical query processing, single-table queries, joins, subqueries, table expressions, set operators, data analysis, data modifications, temporal tables, and transactions and concurrency.

Building on this foundation, you'll enhance your coding capabilities, from programmatic constructs to the powerful new SQL Graph. Throughout the course, Ben-Gan provides reusable T-SQL sample code that works seamlessly in cloud, on-premises, and hybrid environments.

By the end of this course, you'll have a solid understanding of T-SQL and its applications in modern data platforms. You'll be able to write better code, review relational theory elements, create tables with data integrity, build complex queries, perform data analysis, and handle transactions and concurrency effectively. Additionally, you'll explore the use of SQL Graph, a powerful tool for data manipulation and visualization.

Whether you're a database administrator, developer, or data analyst, this course will empower you to leverage the full potential of T-SQL and modern data technologies to solve complex data-related challenges. So, enroll now and embark on a journey to becoming a skilled T-SQL developer!

Weight: 1094g
Dimension: 189 x 235 x 35 (mm)
ISBN-13: 9780138102104
Edition number: 4 ed

This item can be found in:

UK and International shipping information

UK Delivery and returns information:

  • Delivery within 2 - 3 days when ordering in the UK.
  • Shipping fee for UK customers from £2.39. Fully tracked shipping service available.
  • Returns policy: Return within 30 days of receipt for full refund.

International deliveries:

Shulph Ink now ships to Australia, Belgium, Canada, France, Germany, Ireland, Italy, India, Luxembourg Saudi Arabia, Singapore, Spain, Netherlands, New Zealand, United Arab Emirates, United States of America.

  • Delivery times: within 5 - 10 days for international orders.
  • Shipping fee: charges vary for overseas orders. Only tracked services are available for most international orders. Some countries have untracked shipping options.
  • Customs charges: If ordering to addresses outside the United Kingdom, you may or may not incur additional customs and duties fees during local delivery.
View full details