[From SQL Server Magazine
Welcome to T-SQL 101. Over the course of the next 10 lessons, youll learn the basic principles to follow when writing queries with T-SQL. By the end of the course, youll be able to not only write query statements to view and manipulate data but also write custom stored procedures and functions. To start you on this journey, lets look at what T-SQL is, the query tools you use with it, and how to write the SELECT statements that the query tools use to retrieve the data you need.
The article continues at