T-SQL Fundamentals

T-SQL Fundamentals

by Itzik Ben-Gan

Paperback

$48.91 $49.99 Save 2% Current price is $48.91, Original price is $49.99. You Save 2%.
View All Available Formats & Editions
Choose Expedited Shipping at checkout for guaranteed delivery by Wednesday, February 20

Product Details

ISBN-13: 9781509302000
Publisher: Microsoft Press
Publication date: 08/17/2016
Pages: 464
Sales rank: 229,591
Product dimensions: 7.40(w) x 9.00(h) x 1.00(d)

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

Table of Contents


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

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews