SQL Server 2000 Tutorial
Note that this tutorial uses the 2000 edition of SQL Server (SQL Server 2000).
For the latest version, see SQL Server tutorial.
Table of Contents
This tutorial consists of the following lessons:
- About SQL Server
- SQL Server - Enterprise Manager
- SQL Server - Create a Database
- SQL Server - Create a Table
- SQL Server - Adding Data
- SQL Server - SQL Query Analyzer
- SQL Server Views
- SQL Server Stored Procedures
- SQL Server Security
- SQL Server - Create a Login
- SQL Server - DTS
- SQL Server Agent
- SQL Server Agent Jobs
- SQL Server - Service Manager
- SQL Profiler
- SQL Server - Summary
This SQL Server 2000 tutorial is for anyone who wishes to learn how to use SQL Server 2000. 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 (preferably SQL Server 2000), 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.
If you already know about SQL Server and like to learn more about SQL programming, check out the SQL tutorial.