Introduction to T-SQL

Introduction to T-SQL - What do you need to get started

Module 00 - Getting Started 16 min.

Module 01 - Introduction to SQL Server Databases 25 min.

Module 02 - SQL Server Management Studio (SSMS) 26 min.

Module 03 - The SELECT Statement 41 min.

Module 04A - Expressions (Concatenating Columns) 10 min.

Module 04B - Expressions (Mathematical Expressions) 16 min.

Module 04C - Expressions (Other Functions) 52 min.

Module 04D - Expressions (Working with NULLs, DISTINCT and TOP) 16 min.

Module 05 - Indexes 17 min.

Module 06 - The WHERE Clause 30 min.

Module 07 - Complex WHERE Clauses 27 min.

Module 08 - Using a Sub-Query to Filter Data 37 min.

Module 09 - Joining Tables 34 min.

Module 10 - Outer Joins 33 min.

Module 11 - Other Query Patterns 40 min.

Module 12 - Aggregate Queries 26 min.

Module 13A - Modifying Data (Create Tables) 5 min.

Module 13B - Modifying Data (INSERT and SELECT INTO) 12 min.

Module 13C - Modifying Data (UPDATE Statement) 17 min.

Module 13D - Modifying Data (DELETE Statement) 6 min.

Module 14A - T-SQL Programming (Variables) 6 min.

Module 14B - T-SQL Programming (Conditional Logic) 13 min.

Module 14C - T-SQL Programming (Looping) 6 min.

Module 14D - T-SQL Programming (Stored Procedures) 8 min.