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.