SQL Server Express 2008 R2 Video Tutorials
 






This tutorial shows where to download, install and setup SQL Server Express




Once SQL Server Express is installed, the next step is to make a database.




Tables hold data for the database.




This tutorial shows how to insert data into the database then select the data.




A simple select statement with a where clause is shown in this tutorial.




This tutorial will start by declaring variables. Integer and varchar are shown.




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



An Update is used to modify data.




This tutorial shows how to use Count, Group and Order.





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



Views can be used to retrieve data quickly.