In this T-SQL training course you will learn about the Transact-SQL that expands on the SQL standard. The query language that uses Microsoft SQL Server is a variant of the ANSI-standard Structured Query Language, SQL. The SQL Server variant is called Transact-SQL. Database developers and database administrators must have a thorough knowledge of Transact-SQL to read data from and write date to SQL Server databases. Using Transact SQL is the only way to work with the data.
Types of joins
PIVOT operators, Full Text Search function and the TABLESAMPLE clause
User Defined Functions, Column Alias, Temporary Tables and the Select Into Clause
Use of transactions
TRY and Catch Blocks
10 tips about SQL Server that every developer should know
SQL Server 2008