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 select books and videos about T-SQL.
2023-02-27
T-SQL Fundamentals
Edition: 4
Series: Developer Reference
Author: Itzik Ben-Gan
Publisher: Microsoft
ISBN: 9780138102104
Type: Book
Format: Paperback
Price: US $50
On sale @ Amazon.
Shop @ Microsoft.
Here are select books and videos awaiting updates.
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-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.
P4TE 