Transact-SQL 101

Series Duration:  4 Hours 37 Minutes

Number of Tutorials:  29

This series will introduce you to the Transact-SQL (T-SQL) language. T-SQL is used to interact with your relational database for such tasks as retrieving records from your tables, updating, inserting and deleting data. This series is geared towards the absolute beginner and will give you the foundation needed to becoming a T-SQL expert.

• Introduction to SQL

  Duration: 6 Minutes 34 Seconds



• Using SQL Server Management Studio (SSMS)

  Duration: 20 Minutes 24 Seconds



• Installing the Sample Databases

  Duration: 4 Minutes 58 Seconds

• Understanding and Using Data Types

  Duration: 16 Minutes 02 Seconds



• Understanding and Enforcing Data Integrity

  Duration: 7 Minutes 36 Seconds

• Retrieving Data Using the SELECT Statement

  Duration: 10 Minutes 55 Seconds



• Limiting Your Result Set Using TOP

  Duration: 3 Minutes 38 Seconds

• Filtering Results Using the WHERE clause

  Duration: 9 Minutes 15 Seconds



• Using AND, OR and Other Logical Operators

  Duration: 9 Minutes 10 Seconds



• Finding Data Using the LIKE Operator

  Duration: 13 Minutes 23 Seconds

• Joining Tables Using INNER Joins

  Duration: 10 Minutes 22 Seconds



• Using Inner Joins to Join More Than Two Tables

  Duration: 7 Minutes 15 Seconds



• Joining Tables Using LEFT, RIGHT and FULL OUTER Joins

  Duration: 10 Minutes 54 Seconds

• Inserting Records Using INSERT

  Duration: 10 Minutes 56 Seconds



• Updating Records Using UPDATE

  Duration: 9 Minutes 13 Seconds



• Deleting Records Using DELETE

  Duration: 3 Minutes 36 Seconds

• Introduction to SQL Server 2005 Functions

  Duration: 10 Minutes 59 Seconds



• Using the LEFT, RIGHT and SUBSTRING Functions

  Duration: 9 Minutes 05 Seconds



• Manipulating Strings Using LTRIM, RTRIM and Other String Functions

  Duration: 8 Minutes 47 Seconds



• Understanding and Using SQL Server Date Functions

  Duration: 5 Minutes 14 Seconds



• Performing Date Calculations Using DATEADD and DATEDIFF

  Duration: 5 Minutes 50 Seconds

• Using Aggregate Functions to Group Data

  Duration: 15 Minutes 15 Seconds



• ROWNUMBER, RANK and Other Ranking Functions

  Duration: 9 Minutes 08 Seconds



• Changing Data Types Using CAST and CONVERT

  Duration: 11 Minutes 31 Seconds

• Understanding and Using Subqueries

  Duration: 10 Minutes 49 Seconds

• Display Alternate Values Using the CASE Function

  Duration: 9 Minutes 38 Seconds

• Using Common Table Expressions (CTE)

  Duration: 7 Minutes 02 Seconds



• Writing Recursive Queries Using Common Table Expressions

  Duration: 9 Minutes 25 Seconds

• Introduction to SQL Server Variables

  Duration: 10 Minutes 43 Seconds