SQL Server Tutorial

This SQL Server tutorial is for anyone who wishes to learn how to use SQL Server. It assumes a basic understanding of databases and how they work.

If you don't currently have an understanding of how databases work, start with the basic database tutorial first. That tutorial covers the basic concepts of databases, so the examples in this tutorial will make more sense once you return here.

To get the most out of this tutorial, you should have a copy of SQL Server installed on your computer, so that you can go through the examples yourself. If you don't have a copy, that's OK - you should still be able to gain an understanding of what SQL Server is and what's involved in using it.

You will find 2 tutorials here; a tutorial for SQL Server 2008, and a tutorial for SQL Server 2000.

SQL Server 2008

This tutorial covers the 2008 edition of SQL Server (SQL Server 2008). Specifically, it uses (the free) SQL Server 2008 Express with Advanced Tools.

This tutorial consists of the following lessons:

1. About SQL Server
2. SQL Server Editions
3. SQL Server - Management Studio
4. SQL Server - Create a Database
5. SQL Server - Create a Table
6. SQL Server - Adding Data
7. SQL Server - Query Designer
8. SQL Server Views
9. SQL Server Stored Procedures
10. User Logins
11. Server Roles
12. Database Schemas
13. Linked Servers
14. Integration Services
15. Summary

• Start Tutorial >>

SQL Server 2000

If you need to learn SQL Server 2000, use the SQL Server 2000 tutorial.

SQL Programming Tutorial

If you already know about SQL Server and like to learn more about SQL programming, check out the SQL tutorial.