Microsoft Transact-SQL


Transact-SQL (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.

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.

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.

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


Here are books about T-SQL.


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.


2017-01-17
70-762: Developing SQL Databases
Edition: 1
Series: Exam Ref
Authors: Louis Davidson and Stacia Varga
Publisher: Microsoft
ISBN: 9781509304912
Type: Book
Format: Paperback
Price: US $40

On sale @ Amazon.

Shop @ Microsoft.


2017-03-31
70-761: Querying Data With Transact-SQL
Edition: 1
Series: Exam Ref
Author: Itzik Ben-Gan
Publisher: Microsoft
ISBN: 9781509304332
Type: Book
Format: Paperback
Price: US $40

On sale @ Amazon.

Shop @ Microsoft.


2017-08-16
70-761: Querying Data With Transact-SQL
Edition: 1
Series: Live Lessons
Author: Marilyn White
Publisher: Pearson
ISBN: 9780134769882
Type: Video
Format: MP4
Price: US $300

On sale @ Amazon.

Shop @ Pearson.


2017-09-18
70-764: Administering A SQL Database Infrastructure
Edition: 1
Series: Exam Ref
Authors: Victor Isakov
Publisher: Microsoft
ISBN: 9781509303830
Type: Book
Format: Paperback
Price: US $40

On sale @ Amazon.

Shop @ Microsoft.


2017-01-17
70-765: Provisioning SQL Databases
Edition: 1
Series: Exam Ref
Authors: Joseph D’Antoni, Scott Klein
Publisher: Microsoft
ISBN: 9781509303816
Type: Book
Format: Paperback
Price: US $40

On sale @ Amazon.

Shop @ Microsoft.


2017-05-05
70-768: Developing SQL Data Models
Edition: 1
Series: Exam Ref
Author: Stacia Varga
Publisher: Microsoft
ISBN: 9781509305155
Type: Book
Format: Paperback
Price: US $40

On sale @ Amazon.

Shop @ Microsoft.


2017-10-11
70-768: Developing SQL Data Models
Edition: 1
Series: Live Lessons
Author: Scot Reagin
Publisher: Pearson
ISBN: 9780134840888
Type: Video
Format: MP4
Price: US $300

On sale @ Amazon.

Shop @ Pearson.


2017-11-09
70-767: Implementing A SQL Data Warehouse
Edition: 1
Series: Exam Ref
Authors: Jose Chinchilla and Raj Uchhana
Publisher: Microsoft
ISBN: 9781509306473
Type: Book
Format: Paperback
Price: US $40

On sale @ Amazon.

Shop @ Microsoft.


2018-01-08
70-762: Developing SQL Databases
Edition: 1
Series: Live Lessons
Authors: Marilyn White
Publisher: Pearson
ISBN: 9780134769899
Type: Video
Format: MP4
Price: US $300

On sale @ Amazon.

Shop @ Pearson.


2018-07-20
70-767: Implementing A SQL Data Warehouse
Edition: 1
Series: Live Lessons
Author: Scot Reagin
Publisher: Pearson
ISBN: 9780135224762
Type: Video
Format: MP4
Price: US $300

On sale @ Amazon.

Shop @ Pearson.


2019-11-13
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 Microsoft.
Go to Microsoft SQL Server.