SQL Server - Summary
Congratulations for reaching the end of this SQL Server tutorial!
SQL Server is a powerful application, and this tutorial has provided an overview of the main concepts involved in administering SQL Server 2008 Express.
To recap briefly, we've:
- Created databases
- Created database tables
- Inserted data into those tables
- Used the SSMS to run a query
- Created a login account
- Looked at server roles
- Learned about database schemas
- Looked at linked servers
- and more
If you haven't already, check out the latest SQL Server tutorial.
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.
To learn more about SQL, check out the SQL tutorial.
Also check out the other database tutorials here at Quackit.