SQL Server 2008 Tutorial

This SQL Server tutorial is for anyone who wants to learn how to use SQL Server 2008. 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. The examples in this tutorial are all done using the free version of SQL Server - SQL Server 2008 Express. You can download SQL Server 2008 Express from the Microsoft website (we'll get to that in a minute).

If you don't currently have SQL Server yet, that's OK. The tutorial is straight forward and contains plenty of screenshots.

Table of Contents

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

Enjoy this page?

  1. Link to this page (copy/paste into your own website or blog):
  2. Link to Quackit using one of these banner ads.

Thanks for supporting Quackit!

Sponsored Link: Design CODE-FREE Websites

Check a Domain:

ZappyHost Logo
Webydo Banner Ad
Webydo Banner Ad