T-SQL 101: Getting started with T-SQL
Application & Database Development
Learn Basics of SQL and T-SQL querying in Microsoft SQL Server. This session will assume you have no or very little knowledge of writing T-SQL. We will cover following in order: set based theory, select statement, joining two or more tables, T-SQL functions, update statement. We will also touch briefly on basic query performance tips. By the end of the session, you will know how to query a database.
If you want to follow along in the class, please have SQL Server and AdventureWorks2012 database installed on your computer.