Intro T SQL

Module 00 - Getting Started
 Module 01 - Introduction to SQL Server Databases
 Module 02 - SQL Server Management Studio (SSMS)
 Module 03 - The SELECT Statement
 Module 04A - Expressions (Concatenating Columns)
 Module 04B - Expressions (Mathematical Expressions)
 Module 04C - Expressions (Other Functions)
 Module 04D - Expressions (Working with NULLs, DISTINCT and TOP)
 Module 05 - Indexes
 Module 06 - The WHERE Clause
 Module 07 - Complex WHERE Clauses
 Module 08 - Using a Sub-Query to Filter Data
 Module 09 - Joining Tables
 Module 10 - Outer Joins
 Module 11 - Other Query Patterns
 Module 12 - Aggregate Queries
 Module 13A - Modifying Data (Create Tables)
 Module 13B - Modifying Data (INSERT and SELECT INTO)
 Module 13C - Modifying Data (UPDATE Statement)
 Module 13D - Modifying Data (DELETE Statement)
 Module 14A - T-SQL Programming (Variables)
 Module 14B - T-SQL Programming (Conditional Logic)
 Module 14C - T-SQL Programming (Looping)
 Module 14D - T-SQL Programming (Stored Procedures)