I'm a student
I'm an educator
Request full copy

T-SQL Fundamentals, 3rd edition

Published by Microsoft Press (August 3, 2016) © 2017

  • Itzik Ben-Gan

eTextbook

$47.99

  • Available for purchase from all major ebook resellers, including InformIT.com.
  • To request a review copy, click on the "Request a Review Copy" button.
$39.99

  • A print text (hardcover or paperback) 
  • Free shipping
  • Also available for purchase as an ebook from all major ebook resellers, including InformIT.com

Students will master the fundamentals of Transact-SQL—and develop their own code for querying and modifying data in Microsoft SQL Server 2016. Led by a SQL Server expert, readers learn the concepts behind T-SQL querying and programming, and then apply their knowledge with exercises in each chapter. Once students understand the logic behind T-SQL, they'll quickly learn how to write effective code.

  • Explains the why's, not just the how's, of T-SQL to vastly improve learners' understanding.
  • Up to date with SQL Server 2016 and Microsoft Azure SQL Database.
  • Written by an acknowledged master in the T-SQL and SQL Server field.
This edition of the book adds more exercises, a chapter on temporal tables (Chapter 8) and a chapter on T-SQL tips and tricks (Chapter 12). And it updates the content for Microsoft SQL Server through version 2016 and Microsoft Azure SQL Database.   
Contents at a Glance

Introduction

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 Beyond the fundamentals of querying

CHAPTER 8 Data modification

CHAPTER 9 Temporal tables

CHAPTER 10 Transactions and concurrency

CHAPTER 11 Programmable objects

Appendix: Getting started

Index

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

Need help? Get in touch

Video
Play
Privacy and cookies
By watching, you agree Pearson can share your viewership data for marketing and analytics for one year, revocable by deleting your cookies.

Video transcript (PDF | 16KB) 

Pearson eTextbook: What’s on the inside just might surprise you

They say you can’t judge a book by its cover. It’s the same with your students. Meet each one right where they are with an engaging, interactive, personalized learning experience that goes beyond the textbook to fit any schedule, any budget, and any lifestyle. 

Digital Learning NOW

Extend your professional development and meet your students where they are with free weekly Digital Learning NOW webinars. Attend live, watch on-demand, or listen at your leisure to expand your teaching strategies. Earn digital professional development badges for attending a live session.

Explore webinars