SQL Server 2008 R2 Tutorial List

Tutorial 1 - Installation and Setup
This tutorial shows where to download, install and setup SQL Server Express

Tutorial 2 - Making a Database
Once SQL Server Express is installed, the next step is to make a database.

Tutorial 3 - Making a Table
Tables hold data for the database.

Tutorial 4 - Insert and Select Data
This tutorial shows how to insert data into the database then select the data.

Tutorial 5 - Select Statement Where Clause
A simple select statement with a where clause is shown in this tutorial.

Tutorial 6 - Inserting Data in Tables Using the While Loop
This tutorial will start by declaring variables. Integer and varchar are shown.

Tutorial 7 - Delete and Truncate
Delete and Truncate commands are shown. Be very careful using these commands.

Tutorial 8 - Update Statement
The Update statement is used to modify data.

Tutorial 9 - Grouping and Counts
This tutorial shows how to use Count, Group and Order.

Tutorial 10 - Ranking
Ranking, Order By, Partition, and Row Number are used in this video tutorial.

Tutorial 11 - View
Views can be used to retrieve data quickly.