SQL Server Tutorial

SQL Server Summary

SQL Server is a powerful application, and this tutorial has provided an overview of the main concepts involved in administering SQL Server.

To recap briefly, we've:

created databases
created database tables
inserted data into those tables
used the Query Analyzer to run a query
created a login account
created and executed a DTS package
executed that same DTS package via a scheduled job
and more
What Next?
The most logical next step from learning SQL Server is to learn SQL itself (if you haven't already done this that is). SQL stands for Structured Query Language and enables you to perform database related tasks programatically. Most of the tasks in this tutorial can be done programatically using SQL.

Probably the most common use for SQL is to work with the data in the database. For example, to insert data, select data, update data, or to delete data. Any database driven website will have many SQL statements doing this stuff.