Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

A beginners guide to T-SQL ( Transact-SQL)

Video Introducing this tutorial

Database Download and Install :
Introduction
What is T-SQL
Hardware and Software Requirements for SQL Server Express 2014
Download SQL Server Express2014
Install SQL Server Express 2014
Download sample database
Install Sample Database


Useful T-SQL Commands :
TOP
USE
GO
DISTINCT and TOP
Using T-SQL Comments


Retrieving and Sorting Data with T-SQL :
Using SELECT Statements
Aliases
Using ORDER BY clause
Sort by ascending order
Sort by multiple columns
Case Expressions
Using Stored Procedures


How to query multiple tables with T-SQL :
Introduction to Table Joins
Why are table joins relevant
INNER Table Join
Left Outer Table Join
Right Outer Table Join
Conclusion


Filtering Rows of data with T-SQL :
Introduction
Using basic equality filters
Using basic comparison
Using logical comparisons
Using String Comparison
Using Null Comparison
Summary


Using T-SQL to modify data :
Introduction
Add new records to a database
Update existing data in the database
Delete data from a database
Summary


How to use T-SQL with Aggregate functions :
Introduction
COUNT Function
AVG Function
MAX Function
MIN Function
SUM function
Grouping Data
Summary