Microsoft Transact-SQL


Transact-SQL, or T-SQL, is a dialect of, or extension to, Structured Query Language (SQL) for use with Microsoft SQL Server.

T-SQL was released in 1995 with Microsoft SQL Server version 6.0.


Here are certifications related to T-SQL.


Microsoft Certified Solutions Associate (MCSA) certification in SQL 2016 Database Development requires passing two (2) Microsoft examinations.

Microsoft retired these examinations on January 31, 2021.

70-761: Querying Data With Transact-SQL
70-762: Developing SQL Databases


Microsoft Solutions Associate (MCSA) certification in SQL 2016 Business Intelligence (BI) Development requires passing two (2) Microsoft examinations.

Microsoft retired these examinations on January 31, 2021.

70-767: Implementing A Data Warehouse Using SQL
70-768: Developing SQL Data Models


Microsoft Certified Solutions Expert (MCSE) certification in Data Management And Analytics requires a Microsoft Certified Solutions Associate (MCSA) certification and passing one (1) more Microsoft examination.

Microsoft retired these examinations on January 31, 2021.

70-762: Developing SQL Databases
70-767: Implementing A Data Warehouse Using SQL
70-768: Developing SQL Data Models


Here are books and videos about T-SQL.


2014-11-03
T-SQL Fundamentals
Edition: 1
Series: Live Lessons
Author: Alison Balter
Publisher: Pearson
ISBN: 9780789753953
Type: Video
Format: MP4
Price: US $300

On sale @ Amazon.

Shop @ Pearson.


2015-03-06
T-SQL Querying
Edition: 1
Series: Developer Reference
Authors: Itzik Ben-Gan, Adam Machanic, Dejan Sarka, and Kevin Farlee
Publisher: Microsoft
ISBN: 9780735685048
Type: Book
Format: Paperback
Price: US $60

On sale @ Amazon.

Shop @ Microsoft.


2016-08-03
T-SQL Fundamentals
Edition: 3
Series: Developer Reference
Author: Itzik Ben-Gan
Publisher: Microsoft
ISBN: 9781509302000
Type: Book
Format: Paperback
Price: US $50

On sale @ Amazon.

Shop @ Microsoft.


2016-12-12
Microsoft SQL Server T-SQL In 10 Minutes
Edition: 2
Series: Sams Teach Yourself
Author: Ben Forta
Publisher: Pearson
ISBN: 9780672337925
Type: Book
Format: Paperback
Price: US $30

On sale @ Amazon.

Shop @ Pearson.


2019-10-18
T-SQL Window Functions
Edition: 2
Series: Developer Reference
Author: Itzik Ben-Gan
Publisher: Microsoft
ISBN: 9780135861448
Type: Book
Format: Paperback
Price: US $40

On sale @ Amazon.

Shop @ Microsoft.


Where do we go from here?
Back to T-SQL.
Go to Microsoft SQL Server.